Databricks - Data Analyst Associate Study Guide

8: Data Modeling with Databricks SQL

This chapter maps the three industry-standard analytical data models, star schema, snowflake schema, and data vault, onto the Databricks Lakehouse and shows how each shape is expressed in Databricks SQL against Unity Catalog Delta tables. It then aligns those models to the Bronze, Silver, and Gold layers of the Medallion Architecture, with concrete DDL, join patterns, and clustering choices for each layer.