Track

Snowflake

Build a complete analytics platform on Snowflake, the way it is built at work: an operational SQL Server database loaded into a raw layer, cleaned and modelled with dbt into star schemas and a data mart, tested, reconciled to the cent, and run every night by Airflow. Every number and screenshot on these pages comes from the working lab.

Snowflake · dbt Core · Airflow · SQL Server 2022 Medallion: Bronze → Silver → Gold → data mart Level: intermediate → advanced

Tutorials

Tutorial · End to end

Snowflake Data Platform with dbt and Airflow: WideWorldImporters End to End

From the complete design diagrams to a running platform: the lab, the source system, Snowflake setup with key-pair security, incremental loading into Bronze, dbt Silver, Gold and a Sales data mart, tests, reconciliation and a simple Airflow DAG.