In this blog post I will explain what DBT models are and how to use them effectively. For background on DBT, click here; for some background on the role most…
In Snowflake, network policies enable the restriction of Snowflake account access by specifying blocked and allowed IP addresses for users. Let's dive in. Creating a Network Policy Network policies can…
This is part one of a two part series overviewing Snowflake's security measures and tools. In this part you will learn about Snowflake's measures and tools for data encryption and…
Snowflake, a cloud-based data warehousing platform, facilitates handling and analyzing large datasets with ease. One of its features is the concept of Snowflake Sessions, which are crucial for managing user…
In this post I will introduce you to the main components of the Snowflake Architecture. I will explain what it means for Snowflake to have a hybrid architecture and why…
Navigating through the realm of data management in Snowflake unveils a key feature known as Snowflake Internal Stages. These stages act as temporary storage areas, enabling a seamless data loading…
Data clustering in Snowflake, a process of organizing related rows within micropartitions, is pivotal for efficient query performance. While Snowflake automatically manages micropartitions, sub-optimal clustering can occur. To address this,…
In today's digital world, sharing and accessing data easily is crucial for business success. Snowflake offers a feature called Reader Accounts to make this easier. A Snowflake Reader Account lets…
Every database administrator has at some point in their life had the dreaded call: Something went wrong in the production database. Corrupted data was inserted, vital data overwritten, or the…
Background photo by Vienna Reyes on Unsplash Fan tokens have opened up exciting opportunities for fans to actively engage with their favorite sports teams and artists. These digital tokens, often…