← Back to Microsoft Fabric — Complete Learning Series

Medallion Architecture in Fabric — The Perfect Fit

Fabric’s unified platform makes Medallion architecture seamless. Every component fits naturally into the Bronze → Silver → Gold flow.

• OneLake — All layers stored in one unified lake.
• Delta Lake — ACID transactions, schema evolution, partitioning.
• Lakehouses — Bronze, Silver, Gold stored as Delta tables.
• Pipelines — Ingest raw data into Bronze.
• Notebooks — Transform Bronze → Silver → Gold.
• SQL Endpoint — Query Silver/Gold directly.
• Direct Lake — Power BI reads Gold tables instantly.
• Purview — Govern each layer centrally.

Pipelines — The Ingestion Engine

Fabric Pipelines handle enterprise‑grade ingestion into Bronze.

Capabilities

• Scheduled ingestion
• Copy activities
• Parameterization
• Error handling & retry logic
• Monitoring & logging
• Notifications

Common Pipeline Patterns

• Full load
• Incremental load
• CDC load
• Metadata‑driven load
• Multi‑source ingestion

Notebooks — The Transformation Engine

PySpark notebooks transform Bronze → Silver → Gold.

Common Transformation Patterns

• Incremental loads
• Merge operations
• Partition pruning
• Schema evolution
• Delta optimization (Z‑Order, file compaction)

Source → Pipeline → Bronze → Silver → Gold Flow

A clean Medallion flow in Fabric looks like this:

1. Ingest raw data into Bronze using Pipelines.
2. Transform into Silver using PySpark notebooks.
3. Model Gold tables for business consumption.
4. Build semantic models using Direct Lake.
5. Publish Power BI dashboards.

Pipelines feed the Lakehouse. Notebooks shape the data. Gold delivers the value.

← Back to Microsoft Fabric — Complete Learning Series