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
The full project guide is for members
Join Surfalytics to unlock every step of this project, all other projects, the full course, and the private community.
7-day free trial · Cancel any time