Month: January 2023

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. https://youtu.be/pm_1L27JGFg In Snowflake, the SOUNDEX function works exactly the same way: For all the…… Continue reading Sound of Silence in Snowflake

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…… Continue reading Inserting an Insert into Snowflake

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…… Continue reading Expunging data, the Snowflake way.

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…… Continue reading Insert differently with Snowflake and SQL Server

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…… Continue reading Somehow I like Snowflake more and more