Build a modern end-to-end data pipeline ingesting TPCH data from S3 into Snowflake, transforming via dbt (Silver/Gold layers), orchestrated by Airflow, with one Alteryx hybrid ETL workflow.
AWS S3 → Snowflake RAW → dbt SILVER → dbt GOLD → Airflow Orchestration → Alteryx ETL
Snowflake — Cloud Data Warehouse dbt Core — Transformations and testing Airflow (Docker) — Pipeline orchestration Alteryx Designer — Hybrid ETL GitHub — Version control Notion — Documentation
| Phase | Tool | Status |
|---|---|---|
| Raw Layer | Snowflake | ✅ Done |
| Transformations | dbt Core | ✅ Done |
| Orchestration | Airflow | ✅ Done |
| Hybrid ETL | Alteryx | ✅ Done |
| Documentation | GitHub + Notion | ✅ Done |
Screenshots
