Snowflake Study Notes

Auto-Scaling and Auto-Suspend

Learn how AUTO_SUSPEND and AUTO_RESUME, combined with multi-cluster auto-scaling, keep Snowflake compute cost-efficient without manual intervention.

Building a Data Warehouse Schema

How to design a layered, star-schema Snowflake warehouse with correctly-chosen grain, slowly changing dimensions, and incremental loading.

Clustering Keys

Understand how clustering keys influence micro-partition organization in Snowflake to improve pruning and query performance on large tables.

Cost Management and Credits

Explains how Snowflake's credit-based consumption pricing works across compute, storage, and cloud services, and the tools available to monitor and control spe…

Databases, Schemas, and Warehouses

How Snowflake organizes data into databases and schemas, and how virtual warehouses exist independently as compute resources.

Integrating Snowflake with BI Tools

Covers how BI tools like Tableau, Power BI, and Looker connect to Snowflake, and the performance and governance patterns that keep dashboards fast and secure.

Loading Data with COPY INTO

Learn how Snowflake's COPY INTO command bulk-loads data from staged files into tables, including file formats, load options, parallelism, and load history.

Masking Policies and Row Access Policies

How Snowflake dynamically hides sensitive column values or entire rows from unauthorized roles, enforced consistently at query time across every downstream con…

Multi-Cluster Warehouses

Understand how multi-cluster warehouses handle high concurrency by automatically adding and removing compute clusters.

Query Performance and Caching

Explore Snowflake's layered caching model, including result cache, local disk cache, and metadata cache, and how each speeds up repeated queries.

Querying with Snowflake SQL

A practical tour of Snowflake's SQL dialect, covering joins, window functions, common table expressions, and result caching.

Roles and Access Control

How Snowflake's role-based access control model governs who can do what, using hierarchical roles, privilege grants, and secure ownership rather than per-user…

Secure Data Sharing

How Snowflake lets one account share live, read-only data with another account instantly, without copying or moving any data between them.

Semi-Structured Data: JSON and VARIANT

Learn how Snowflake's VARIANT data type stores semi-structured JSON, and how to query, flatten, and optimize access to nested data.

Setting Up a Snowflake Account

A practical walkthrough of creating a Snowflake account, choosing an edition and region, and configuring initial roles and warehouses.

Snowflake Architecture

A deep dive into Snowflake's three-layer architecture: storage, compute, and cloud services.

Snowflake Best Practices

Practical guidance for sizing warehouses, controlling cost, tuning performance, and governing access in a production Snowflake account.

Snowflake Interview Questions

Common Snowflake interview questions on architecture, Time Travel, cloning, and cost troubleshooting, with the reasoning strong answers demonstrate.

Snowflake Quick Reference

A condensed cheat sheet of core Snowflake objects, editions, and everyday SQL commands for fast lookup during daily work.

Snowflake vs Redshift vs BigQuery

A practical architecture, pricing, and ecosystem comparison of the three leading cloud data warehouses to guide platform selection.

Snowpark Basics

Introduces Snowpark, Snowflake's developer framework for writing DataFrame-style transformations and stored procedures in Python, Java, or Scala that execute i…

Snowpipe and Continuous Loading

Learn how Snowflake's Snowpipe service ingests data continuously and automatically from cloud storage, and how it differs from batch COPY INTO loads.

Stages: Internal and External

Understand Snowflake's internal and external stages, the staging areas where files land before or after being loaded into or unloaded from tables.

Tasks and Streams

Understand how Snowflake Streams capture change data and how Tasks schedule and chain SQL automation, including the common stream-and-task CDC pattern.