Build Your AI Foundation with Fabric Metadata-driven Framework

Proposed session for SQLBits 2026

TL; DR

Ready to learn how to build your AI foundation? Discover how Microsoft Fabric’s metadata-driven framework, combined with Data Factory pipelines and a Fabric database, powers automated data integration for AI-ready environments. Gain insights on governance, scalability, and accelerating AI-driven analytics.

Session Details

Efficient data management is essential for modern organizations, and automation is the cornerstone of scalability and AI readiness. In this hands-on session, you’ll learn how to build a robust metadata-driven framework using Microsoft Fabric SQL Database and Data Factory pipelines to streamline data integration and accelerate analytics.

We’ll explore control tables, automation strategies, data integrity checks, and auditing mechanisms that reduce repetitive tasks and simplify pipeline development. Through live demos, you’ll gain practical experience configuring the Fabric Metadata-Driven Framework (FMD), applying best practices and optimizing performance for enterprise-scale workloads.

Finally, discover how this framework powers AI-ready environments, enabling governance, scalability, and continuous delivery. Whether you’re tired of rebuilding pipelines or aiming to boost efficiency, this session equips you with actionable tools and insights to transform your data engineering workflows, from automation fundamentals to building a foundation for AI-driven analytics.

3 things you'll get out of this session

Design a Metadata-Driven Framework Build an AI-Ready Data Foundation Implement a metadata‑driven ingestion pattern

Erwin de Kreuk's other proposed sessions for 2026

Empowering Data Products and Data Agents through Data Mesh in Microsoft Fabric - 2026

From Insight to Oversight: Securing Power BI with Purview - 2026

Why Data Quality Matters for AI-Driven Insights - 2026

Erwin de Kreuk's previous sessions

Managing access to data sources in your data estate with Microsoft Purview

One of the new applications within Microsoft Purview Governance Portal are Access Policies. Access policies in Microsoft Purview allow you to manage access to different data systems across your entire data estate. The big advantage of these policies is that you do not have to apply RBAC roles and you have an overview of all applied policies. Are you a data consumer? Then the self-service access policy is an easy way to request access to data while browsing or searching for data. Are you a data producer? Then access policies helps you to easily create and publish access to data sources In this session, I will explain and show you how to create and publish policies and how to set up a self-service access workflow.

Data Governance with Azure Purview - Ask the Experts

Join us for an hour to examine data governance for business and how it can benefit you.

Lake Database with Database Template and Mapping Data with Azure Synapse Analytics

Learn how to easily build your lake database without having to start with a blank canvas on Azure Synapse.

Azure Key Vault, Azure Dev Ops and Data Factory

Azure Key Vault, Azure Dev Ops and Data Factory how do these Azure Services work perfectly together!