Category: Snowflake

One of those functions that can be helpful – in the right circumstances – is SOUNDEX. If you hop into the Wayback Machine with Sherman, Mr. Peabody, and me, I created a blog post about this very subject – found here. In Snowflake, the SOUNDEX function works exactly the same way: In Snowflake, there is…

Whenever I say the keyword INSERT in conjunction with databases, we – as data developers – automatically think that we’re going to be putting data into a table (or multiple tables with Snowflake – see here). With Snowflake, that isn’t always true. Now, you’re probably saying to yourself “Sherpa has obviously lost his/her mind. Who…

Sometimes, in Snowflake as well as in SQL Server, you’re forced to delete data. Hopefully, you’re not deleting from the main table of a database in Production, but that is definitely one way to wake up in the morning. If you’re only deleting from one table, then Snowflake is like SQL Server in the formatting…

One of the things that I’ve gotten used to with Snowflake is that it’s just different. Well, today, I’ve got some goodness for y’all – and in a place that you really wouldn’t expect – the INSERT statement. For most of your everyday use, it works exactly as you’d expect. As some would say, it…

It’s no secret that I like Snowflake. When I say like, I mean that I like some of the different ways that I can find data within other data. For example, see this post from last time. This time, I want to show why one of the many operators are used over another and what…

With SQL Server, you’ll find that, quite often, when dealing with strings, you’re almost stuck using the like operator to check if items are “like” another string. I don’t know how many times I’ve done something like the following: Hopefully, many of you get the gist of the above. We’re wanting anything that shows in…

Sometimes you think you have something down. With years of SQL Server experience, you would think you’d know at least the basics of the SELECT statement no matter the relational database. Well, my friends, you’d be wrong. With Snowflake, we could do many different things that we’re not used to seeing with a SELECT statement.…

With our last blog post, we started discussing Snowflake and the SELECT statement. Now, if you remember, there is this great thing called a semi-colon. The main reason you should use the semicolon is to terminate all of your queries. Snowflake does this great thing by default, letting you run one query at a time.…

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,…