Over the years, I’ve learned a decent amount of things when it comes to Microsoft’s SQL Server. Even with the new SQL Server 2022 which was just announced as being generally available just last week. But, sometimes, you just want to bust out of the old grind and do something a bit different.
For me, that something new – is Snowflake. (Y’all didn’t think I’d go heli-skiing or something, did you?)
With every thing you learn, there are some things that are just different than items you’ve learned elsewhere – in this case, SQL Server. Over the next several blog posts, I’ll go over things that I’ve come across that are just different that anyone wanting to get into Snowflake.
The first command I want to go over this time is probably one that we use the most:
SELECT * FROM TestDb.public.PHONEBOOK;Yes, that’s right. A SELECT statement. Nothing special about the actual SELECT query. I feel like I’ve done millions of these queries over my development life.
The only thing that may look a little different than what most people write for SQL Server is the semicolon at the end. This is actually necessary for Snowflake.
Next time, we’ll go over why it’s necessary, what it does for you, and some other fun things to do in Snowflake. But that’s for next time. Until next time my friends!