Modeling One Big Table (OBT) vs Star Schema — Roadmap Step & Resources
A more denormalized alternative gaining popularity in modern warehouses
- 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: Modeling One Big Table (OBT) vs Star Schema.
- freeCodeCamp (Video) — freeCodeCamp's data engineering course covers dimensional modeling. Relevant to: Modeling One Big Table (OBT) vs Star Schema.
Part of
- Dimensional Modeling — section
- Analytics Engineering (dbt & Data Warehousing) roadmap — the full learning path