Databricks · Databricks Data Analyst Associate
Data modeling
Databricks Data Analyst Associate · Lesson 17 of 18 · 2:04:09
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the Databricks Certified Data Analyst Associate exam. In this lesson: the star schema (facts and dimensions), the snowflake schema, the data vault (hubs, links, and satellites), and which model fits each layer of the medallion architecture, with primary and foreign keys. Includes three original practice questions.
Preview the topics
- In a star schema for rentals, each rental has a date, a store, a bike, a duration, and a price, and each store has a name, a city, and a manager. Where should the city of each store go?
- Cobbleway loads customers from the CRM and from the loyalty program, and the address of a customer changes over time. In a data vault, where should the history of addresses go?
- Cobbleway builds a data vault, with hubs, links, and satellites, from the raw data in bronze, and dashboards will read star schemas built from it. In which layer should the vault itself go?