← Data Modeling with Databricks SQL
5% domain · module 2
Data vault, Medallion architecture, and gold views
Starts at 2:04:49 in this video — SQL Warehouse full course — DLT / pipeline overview (2:04:49)
Medallion
- Bronze — raw ingest (keep history, few transforms)
- Silver — cleaned, conformed, keyed
- Gold — consumer-ready stars / aggregates / metric views
Industry models align with Medallion: vault or 3NF often lives in silver; star/snowflake for BI usually in gold. Do not put a 20-join OLTP model on a dashboard dataset.
Data vault (exam mentions it)
Hubs (business keys), links (relationships), satellites (attributes/history). Vault is an integration pattern, not a dashboard pattern. Analysts usually query gold stars built from vault, not hubs directly.
Views as the contract
catalog.gold.revenue_daily hides joins. Dashboards and Genie should use this name.