Перейти к содержимому

Build a Star Schema + Medallion Architecture 1

Hamdi Eltaheir

0:00 / 0:00

Build a Star Schema + Medallion Architecture 1

21 просмотр · 7 месяцев назад
Hamdi Eltaheir
48 подписчиков
21 просмотр · 7 месяцев назад
In this hands-on tutorial, you'll learn how to: ✅ Create a database schema using PySpark in a Databricks notebook ✅ Build a *star schema* with fact & dimension tables (healthcare example) ✅ Implement **Medallion Architecture**: Bronze → Silver → Gold layers ✅ Use Unity Catalog to organize data across catalogs and schemas 📌 Real-World Use Case: A hospital system tracking patient visits, doctors, departments, and treatments. 📁 What You’ll Learn: • How to use `CREATE SCHEMA` and `CREATE TABLE` in Spark SQL • Best practices for star schema design • Why Medallion Architecture improves data quality • How to manage data lifecycle from raw to trusted