A few months ago, I was discussing with a colleague regarding the SnowPro certification and whether it properly prepares you for the future. While a year ago I would...
Snowflake stored procedures allow us to write procedural code that executes SQL. In a stored procedure, we can use programmatic constructs to perform branching and looping. Just like functions,...
Streamlit is a startup that developed a popular open source project for building data-based apps. Snowflake had recently announced it was acquiring Streamlit for $800 million, quite a sum! In Frosty Friday...
History access in snowflake can provide us many insights regarding who accessed what. Say we have sensitive info on which we wish to find who accessed it. In challenge...
In this blog post, I will go through Frosty Challenge #6, dealing with geographic objects and the way to manipulate them for our own needs. It will also help...
In the 5th Frosty Friday challenge, we are to create a Python User defined Function (UDF) within the Snowflake ecosystem. Hence, in this post we will create a Python...
Frosty Friday’s week 4 challenge asks us to take a Json file, ingest it into the data warehouse, and parse it into a table. Resulting table should include all...
Our frosty journey continues with Frosty Friday challenge #3, where we keep nurishing our Snowflake skills. In this challenge we will be ingesting S3 data as we did in...
The development of Snowflake skills continues with Frosty Friday challenge #2. In this post, we will go over challenge 2 – Streams, and try to explore more features within...