22-25 April 2026

Build It Right: Real-World Microsoft Fabric Pipelines with Metadata & Medallion Architecture

Proposed session for SQLBits 2026

TL; DR

Understand how metadata-driven design improves scalability and reusability in Microsoft Fabric pipelines. Learn how to implement the Medallion Architecture (Bronze, Silver, Gold) using Fabric-native services. Gain practical guidance for delivering trusted, analytics-ready data for downstream consumption.

Session Details

In this session, you’ll learn how to build data pipelines the right way—scalable, reusable, and future-proof—using Microsoft Fabric and the Medallion Architecture (Bronze, Silver, Gold).

Through a fully working demo based on a real-world scenario, we’ll show how to:

** Load messy data from Excel files, on-prem databases, & APIs
** Ingest and land it into OneLake using (ADF)
** Use metadata tables to control pipeline behaviour & automate transformations
** Apply business logic using Fabric SQL DB & Notebooks
** Deliver clean, trusted data for Fabric Data Agent


Fabric components covered:

** Fabric Data Factory (ADF)
** OneLake + Lakehouse
** Fabric SQL DB
** Fabric Notebooks
** Fabric Data Agent

This session is perfect if you're tired of rebuilding pipelines from scratch for every use case. Learn how to design once, scale with metadata, and deploy with confidence across environments—all within the Microsoft Fabric ecosystem.


3 things you'll get out of this session

- Learn how to design scalable, reusable data pipelines using Microsoft Fabric and the Medallion Architecture. - See how metadata-driven pipelines simplify ingestion, transformation, and automation across data sources. - Understand how to deliver trusted, analytics-ready data for downstream consumption using Fabric-native tools

Speakers

Alpa Buddhabhatti

medium.com/@meetalpa