Orientation
What You'll Master Here
The classical methodologies (Kimball, Inmon, Data Vault) still define how to model, but the cloud era changed how warehouses are built and run. This chapter covers the modern patterns layered on top: ELT instead of ETL, the medallion architecture, wide tables, dbt, and the semantic layer.
These are not replacements for dimensional modeling, they are the operational context it now lives in. A modern warehouse still serves stars in its gold layer; it just gets there by loading raw first and transforming in-warehouse with version-controlled SQL.
You will see how each pattern works and how it connects to what you already know: medallion’s gold layer is where your stars live, dbt is how you build them, OBT is a denormalized serving option, and the semantic layer is how you keep "revenue" meaning one thing everywhere.
Why it matters
This is the stack data engineers actually work in today. Knowing how modern patterns relate to dimensional modeling lets you build maintainable, trustworthy warehouses instead of cargo-culting tools.
Core mental model
Modern warehouses load raw, then refine in layers (medallion) with version-controlled SQL (dbt), serving stars or wide tables, governed by one semantic layer.
- ELT
- Extract, Load, then Transform inside the warehouse (vs ETL transforming first).
- medallion
- Layered refinement: bronze (raw) → silver (clean) → gold (curated).
- dbt
- A tool for building warehouse models as version-controlled, tested, dependency-aware SQL.
- semantic layer
- A single governed place where metrics are defined once for all tools.
Common mistake
Thinking modern tools replace dimensional modeling.
You build unstructured "just dump it in" warehouses; the gold layer still needs sound models.
Better habit
- Load raw first, transform in the warehouse.
- Refine data in explicit layers with tested, versioned SQL.
- Define each metric once in a semantic layer.
Modern patterns are about how you build and operate the warehouse; the modeling (stars, grain, SCDs) you learned still governs what the gold layer should look like.
Map each pattern back to earlier chapters: gold = your stars, dbt = how you build them, semantic layer = consistent metrics. Nothing here throws away what you know.
Practice prompts
- Name where your dimensional stars live in a medallion architecture.
- Explain how ELT differs from ETL in one sentence.
Remember this
Modern warehouse patterns (ELT, medallion, dbt, OBT, semantic layer) are the operational context for dimensional modeling, not a replacement for it.