This project transforms Snowflake sample data into a star schema structure (Fact + Dimensions) that is optimized for reporting and analytics. Sample data includes customers, their orders, and order line items.
The project utilizes a layered model structure, along with snapshots, seeds, and macros.
Layers include:
- Staging (stg): Cleanse, filter data, and rename columns
- Intermediate (int): Join and aggregate stg models
- Mart (mart): Join data and define a star schema using a fact and dimensions for optimized reporting
Lineage (DAG)
Database structure
