The Jaffle Shop is a fictional food & beverage business with multiple store locations. Raw seed data covering customers, orders, payments, products, and stores is loaded via dbt seed, then transformed through a staging layer into clean dim_ and fct_ mart models ready for analytics.
Tech Stack
Tool | Role dbt Core | Data transformation, testing, and documentation Databricks | Cloud data warehouse (Unity Catalog, Serverless SQL Warehouse) dbt-databricks | dbt adapter for Databricks / Spark SQL dbt_utils Utility | macros package (dbt-labs) Python | Virtual environment and dependency management Git / GitHub | Version control