Skip to content
BENIBIX Learn

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

Medallion architecture sorts lakehouse tables into three layers. Bronze holds raw data, just as it arrived. Silver holds data that has been cleaned, checked and joined. Gold holds tables shaped for one use, such as a sales report. Each layer is built from the one before it.
Data gets cleaner and more useful as it moves up each layer.

Common mistake

Letting reports read bronze tables. Raw data has copies and errors that gold was meant to remove.

Key takeaways

  1. 1
    Bronze. Raw data, kept as it came.
  2. 2
    Silver. Cleaned, checked and joined.
  3. 3
    Gold. Shaped for one business use.