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.