by Rodrigo Meléndez, on Sep 13, 2022, 3:00:00 AM
Last week, we published a blog post on how to write a Scala UDF for Snowflake. This week? We've taken our talents to Python. We'll take the same function (IS_PALINDROME) …
Read Storyby Andrés Campos, on Sep 8, 2022, 3:00:00 AM
Whenever you migrate SQL Server IF statements that are found within scalar functions using BlackDiamond Studio, you will soon find out that they require special handling to make them work …
Read Storyby Luis Alonso Montero, on Sep 6, 2022, 9:04:12 AM
Snowflake provides a set of built-in functions which can be used to manipulate your data. (In Snowflake's documentation, you can find a big list that describes all of those functions) …
Read Storyby Andrés Campos, on Jun 30, 2022, 1:48:40 PM
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 …
Read Storyby Brandon Carver, on Jun 30, 2022, 3:00:00 AM
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 …
Read Storyby Mauricio Rojas, on Jun 6, 2022, 1:58:29 PM
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 …
Read Storyby Pedro Meléndez, on May 25, 2022, 8:35:20 AM
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 …
Read Storyby Mauricio Rojas, on Apr 5, 2022, 6:55:17 AM
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 …
Read Storyby Mauricio Rojas, on Mar 29, 2022, 11:01:54 AM
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, …
Read Storyby Brandon Carver, on Mar 17, 2022, 5:33:57 AM
It's Spring (or at least it will be soon), and while nature may take the Winter off from growing its product, GAPVelocity AI did not. As Snowflake continues to grow, …
Read Story
