e2e-medallion-architecture

Deploy Bronze, Silver, and Gold lakehouses with notebooks and pipelines in Microsoft Fabric.

952|267|Updated Feb 17, 2026
One-click install
npx skills add https://github.com/microsoft/skills-for-fabric --skill e2e-medallion-architecture
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: e2e-medallion-architecture
Source: https://github.com/microsoft/skills-for-fabric/tree/main/plugins/fabric-authoring/skills/e2e-medallion-architecture
Command: npx skills add https://github.com/microsoft/skills-for-fabric --skill e2e-medallion-architecture

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Implement end-to-end Medallion Architecture (Bronze/Silver/Gold) lakehouse patterns in Microsoft Fabric using PySpark, Delta Lake, and Fabric Pipelines. Use when the user wants to: (1) design a Bronze/Silver/Gold data lakehouse, (2) set up multi-layer workspace with lakehouses for each tier, (3) build ingestion-to-analytics pipelines with data quality enforcement, (4) optimize Spark configurations per medallion layer, (5) orchestrate Bronze-to-Silver-to-Gold flows via notebooks. Triggers: "medallion architecture", "bronze silver gold", "lakehouse layers", "e2e data pipeline", "end-to-end lakehouse", "data lakehouse pattern", "multi-layer lakehouse", "build medallion", "setup medallion".

Core Features & Use Cases

  • Design and deploy separate Bronze, Silver, and Gold lakehouses across dedicated workspaces for governance and performance.
  • Bind notebooks to lakehouses and orchestrate end-to-end workflows from ingestion to analytics, including validation and governance checks.
  • Enforce data quality, schema conformance, and optimization patterns per medallion layer (Bronze write-heavy, Silver balanced, Gold read-heavy).
  • Automate workspace and lakehouse provisioning, notebook deployment, and sequential execution (Bronze → Silver → Gold) with verification and lifecycle management.
  • Enable downstream consumption through Direct Lake connections to analytics and BI tools (e.g., Power BI) with end-to-end traceability.

Quick Start

Set up Bronze/Silver/Gold workspaces and lakehouses, deploy notebooks, bind them, and execute Bronze → Silver → Gold end-to-end.

Frequently Asked Questions about e2e-medallion-architecture

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
What is medallion architecture in a Fabric lakehouse?

Medallion architecture in a Fabric lakehouse is a multi-layer data design pattern organizing data into Bronze, Silver, and Gold tiers to progressively refine raw data into curated analytics assets.

How do I build an end-to-end Bronze Silver Gold pipeline in Fabric?

Build an end-to-end Bronze Silver Gold pipeline in Fabric by provisioning dedicated workspaces and lakehouses, deploying PySpark notebooks, binding them to each layer, and orchestrating execution via Fabric Pipelines.

Can I enforce data quality and schema conformance per lakehouse layer?

Yes, you can enforce data quality and schema conformance per lakehouse layer by applying layer-specific optimization patterns in PySpark, balancing write-heavy Bronze, balanced Silver, and read-heavy Gold transformations.

Does this medallion architecture approach support direct Power BI consumption?

Yes, this medallion architecture approach supports Power BI consumption by enabling Direct Lake connections to the Gold lakehouse, providing end-to-end traceability from ingestion to analytics.

What's the best way to orchestrate notebooks across multiple lakehouses?

The best way to orchestrate notebooks across multiple lakehouses is using Fabric Pipelines to wire sequential execution from Bronze to Silver to Gold, incorporating validation, error handling, and governance checks.