🗄️Medallion Architecture
Also known as Bronze Silver Gold, Multi-Hop Architecture
Three layers of tables. Bronze is raw, silver is clean, gold is ready to use.
Think of it like
It is like making juice. First you pick the fruit, then you wash it, then you pour the juice.
Example
Raw orders land in bronze. A job removes copies and fixes dates into silver. A daily sales table for the finance team sits in gold.
Why it matters
Everyone knows how much to trust a table by its layer. A bug can be fixed by rebuilding from the layer below.
Definition
Common mistake
Key takeaways
- 1Bronze. Raw data, kept as it came.
- 2Silver. Cleaned, checked and joined.
- 3Gold. Shaped for one business use.