Surfalytics
All pet projects
Data Engineering intermediate ⏱ 15–20 hours

Typical Data Warehouse on Azure

Simulate a real company's data warehouse on Azure: ADF orchestration, Azure SQL as source, Snowflake as target, built week by week.

AzureADFSnowflakeData WarehouseSQL
View project on GitHub

What you’ll build

A complete data warehouse project modeled after real enterprise architecture: Azure Data Factory pipelines extract from Azure SQL, load into Snowflake, and dbt handles transformations. Each week adds a new layer to an incrementally built modern data platform.

Skills you’ll practice

  • Azure Data Factory: pipelines, linked services, triggers
  • Azure SQL as a relational source system
  • Loading data into Snowflake from Azure
  • Incremental load patterns and SCD handling