Roadmap › ETL & Data Warehousing Concepts › Module: Fundamentals
Lessons in this course (12)
3. Staging area and the medallion architecture
Basic★ Must knowLesson 3 of 12
Staging = a landing zone holding raw extracted data, usually truncated and reloaded each run. Benefits: decouples extraction from transformation, reduces load on sources (extract once), allows reprocessing, simplifies debugging and reconciliation.
Medallion architecture (lakehouse):
| Layer | Content |
|---|---|
| Bronze | Raw data as ingested (append-only, full history) |
| Silver | Cleaned, deduplicated, conformed, validated |
| Gold | Business-level aggregates and star schemas for reporting |