Microsoft Fabric Lakehouse — Medallion Architecture

Design and implement a Medallion Lakehouse pattern in Microsoft Fabric.

31|18|Updated Apr 4, 2026

Search Tags:#fabric #data-engineering #lakehouse #delta-lake #medallion-architecture #bronze-silver-gold #onelake

Ready to run

npx skills add https://github.com/ThomazRossito/data-agents --skill microsoft-fabric-lakehouse-medallion-architecture

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: Microsoft Fabric Lakehouse — Medallion Architecture
Source: https://github.com/ThomazRossito/data-agents/tree/main/skills/fabric/fabric-medallion
Command: npx skills add https://github.com/ThomazRossito/data-agents --skill microsoft-fabric-lakehouse-medallion-architecture

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Provides a structured blueprint to design and implement a Medallion Lakehouse pattern on Microsoft Fabric, enabling scalable, governed data pipelines across Bronze, Silver, and Gold layers with clear guidance on ingestion, cleaning, and analytics workflows.

Core Features & Use Cases

Bronze-Silver-Gold medallion architecture for end-to-end data ingestion, cleaning, enrichment, and analytics.
Data governance patterns including schema enforcement, deduplication, PII masking, and lineage considerations.
Performance optimization through V-Order, OPTIMIZE, and Direct Lake strategies, plus cross-workspace data sharing via Shortcuts.

Quick Start

Review the Medallion architecture guidance and start scaffolding Bronze/Silver/Gold layers in Fabric Lakehouse using Delta Lake on OneLake.

Frequently Asked Questions about Microsoft Fabric Lakehouse — Medallion Architecture

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

FAQPage Schema

What is the medallion architecture pattern in a Microsoft Fabric Lakehouse?▼

The medallion architecture in a Fabric Lakehouse organizes data into Bronze, Silver, and Gold layers. This pattern progressively structures raw ingested data through cleansing and enrichment into refined Delta Lake tables optimized for analytics.

How do I implement Bronze, Silver, and Gold data pipelines in Fabric Lakehouse?▼

You implement Bronze, Silver, and Gold pipelines by ingesting raw data into Bronze, cleansing and enforcing schemas in Silver, and delivering optimized analytics tables in Gold using Spark or SQL endpoints with Delta Lake on OneLake.

Can I use Delta Lake MERGE upserts and V-Order optimization in a Fabric Lakehouse?▼

Yes, the Fabric Lakehouse medallion architecture supports Delta Lake MERGE upserts for data updates and V-Order optimization for analytics performance, ensuring efficient querying and data management across your pipeline layers.

Does Microsoft Fabric support cross-workspace data sharing for a medallion lakehouse?▼

Yes, Fabric supports cross-workspace data sharing using OneLake Shortcuts. This allows you to reference and share Delta Lake tables across different workspaces without duplicating data across your medallion architecture layers.

How do I handle schema enforcement and data quality in a Fabric Lakehouse medallion architecture?▼

You handle schema enforcement and data quality during the Silver layer transformation phase. This involves cleansing data, applying schema rules, deduplication, and PII masking before promoting validated records to the Gold analytics layer.

What is the best way to maintain Delta Lake tables in a Fabric Lakehouse medallion architecture?▼

The best way to maintain Delta Lake tables is by running periodic OPTIMIZE and VACUUM maintenance tasks. These operations compact small files and remove obsolete data, keeping your Fabric Lakehouse medallion layers performant.