Star Schema vs Snowflake Schema — Roadmap Step & Resources
Two classic approaches to structuring a dimensional model
- Level: beginner
- Estimated time: 1 days
- Roadmap: Analytics Engineering (dbt & Data Warehousing)
Before this step
Study resources
- Snowflake Documentation (Article) — Official documentation for the Snowflake cloud data warehouse. Background reading/viewing for: Star Schema vs Snowflake Schema.
- freeCodeCamp (Video) — freeCodeCamp's data engineering course covers dimensional modeling. Relevant to: Star Schema vs Snowflake Schema.
Part of
- Dimensional Modeling — section
- Analytics Engineering (dbt & Data Warehousing) roadmap — the full learning path