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’s features and capabilities enable you to manage, protect, and share your data securely and compliantly. This is called Data Governance. You can implement data governance in Snowflake by using…
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,…
Snowflake is a cloud data platform that provides fast and scalable data warehousing, data sharing, and data analytics. One of the features that makes Snowflake efficient and cost-effective is its…
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…