Write a Snowflake UDF in Scala with BlackDiamond Studio Snowflake provides a set of built-in functions which can be used to manipulate your data. (In Snowflake's documentation, you can find …

In the last 12 hours two blasts from the past showed up in my feed. First, this excellent github readme which is a super-simple explainer of what exactly assembly language …

Code migration always presents unique and interest challenges. As the longtime leaders in migration tooling, we’ve seen a lot of those challenges. When we find one that’s interesting, we like …

Decisions. Whether it's paper or plastic, coffee or tea, gas or electric... there's always another decision waiting around the corner. And if you landed on this page, your next decision …

It's always helpful to get advice from someone who has been where you're trying to go. When Snowflake needed to build automated migration tools for converting SQL, sprocs, and scripts …

Snowpipe is a powerful tool for automating your data loading process. However, it's not always easy to setup all the transformations you may need in the COPY statement. You might …

The ability to pivot has been key to moving couches and manipulating dataframes for more than 30 years. But not all pivots and unpivots are created equal. Let's take a …

With the surge of Snowflake and its pay-for-what-you-use cloud Data Warehouse solution, more and more companies are looking to migrate their existing data warehouses into Snowflake. This has two main …

This may be a small post, but hopefully, it will save you some time. Recently, I had the problem where I had a procedure in Snowflake that was using the …

Snowflake is the Data Cloud, but does that mean that I can also use Snowflake as a Data Lake? Well, yes. Snowflake could be your Data Lake, your Data Warehouse, …