⚙️ dbt SQL Transformation

This stage uses dbt and SQL to transform raw Snowflake data into clean, tested, and business-ready analytics models.

dbt Setup

• Configured dbt sources from Snowflake
• Built modular SQL models
• Organized transformations into layers
• Added tests and documentation

Transformation Layers

Staging

Raw data is cleaned, renamed, typed, and standardized.

Intermediate

Data is enriched and combined into reusable transformation logic.

Marts

Final business-ready models are created for reporting and analysis.

Data Quality

• Not null tests
• Unique tests
• Source freshness checks
• Relationship validation

dbt DAG

The DAG shows the dependency flow between dbt models across the pipeline.