When dbt creates table or a view in a database, it creates it as: {{ database }}.{{ schema }}.{{ identifier }}, e.g. analytics.finance.payments. Schema and database are defined in the profiles.yml...
Dynamic Data Masking is a Column-level Snowflake Security feature that uses masking policies to selectively mask data in table and view columns at query time. Currently, Snowflake supports Dynamic...
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...