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

Alpa Buddhabhatti's previous sessions

Data Quality Revolution : The Fabric-OpenAI Approach
In this session, we'll walk you through practical techniques for handling various data issues, such as formatting problems, conversion, and more. Whether you're a seasoned data professional or just starting your data journey, this session will equip you with the skills and knowledge needed to turn chaotic datasets into valuable insights. Don't miss this opportunity to master the art of data cleaning with Fabric and Open AI.
 
Microsoft Copilot Demystified: A 20-Minute Introduction
Discover how Copilot empowers developers by automating tasks, offering code suggestions, and providing real-world assistance. We'll showcase its capabilities through practical demonstrations, including a use-case in building an Azure Function. Technologies covered in the demo include Azure Function and Visual Studio/Visual Studio Code.
 
Unlocking Azure OpenAI: A 20-Minute Introduction
Join our 20-minute session to explore Azure OpenAI's core principles, capabilities, and real-world applications. Whether you're a newcomer or need a quick refresher, this session is your gateway to unlock the potential of Azure OpenAI. We'll also demonstrate its integration with Azure Data Factory and Azure SQL, providing valuable insights for your projects.
 
Can an Introvert become an International Speaker? If so, How?
Are you a data professional and would like to share your learnings with others but are scared to speak in public? Are you an Introvert and are comfortable in your own space but also wanted to make an impact in this world? Is something inside you pulling you back from taking the action on your dream? Meet the two data platform speakers who started their speaking journey from the same exact situation but now sharing their learnings across the world helping other data professionals in their journey. How did they actually begin, what challenges did they go through and who helped them along the way? As they speak about their incredible journey, they will share some key details in becoming a speaker, the advantages, steps to improve data skills and develop careers along the way so the audience can carry the knowledge as they take their first steps in becoming one.
 
Top 10 Azure Data Factory Tips & Tricks
ADF Tips and Tricks which help you to speed up your Azure Data Integration solution,save operational cost and improve performance.
 
Azure Data Factory, Azure Logic Apps and Power BI for everyone
As above