Materialized Lake Views in Microsoft Fabric: Simplifying Data Pipelines with SQL | Episode 51 | MVP

In this episode of Fabric Tech Talk Fridays, host Patrick LeBlanc is joined by Mike Carlo, Microsoft MVP and creator of Fabric workloads like Power Designer, to explore one of the most powerful features in Microsoft Fabric: Materialized Lake Views. Materialized lake views bring a declarative, SQL‑first approach to data transformation in the lakehouse, eliminating the need for complex orchestration pipelines while automatically handling dependencies, refresh, and lineage. In this session, you’ll learn: What materialized lake views are and why they matter How they simplify bronze‑to‑gold medallion architectures Why declarative SQL can replace traditional ETL orchestration How Fabric automatically manages dependencies and refresh When to use automatic vs scheduled refresh How to chain materialized views together How to enforce data quality rules and constraints How to monitor lineage and data quality directly in Fabric Mike walks through a hands‑on demo showing how to create, chain, and monitor materialized lake views in a Fabric lakehouse, using nothing more than Spark SQL. If you’re building data pipelines in Microsoft Fabric and want simpler architecture, better performance, and less maintenance, this episode is a must‑watch. Learn more about materialized lake views in Fabric: https://msft.it/6050Q45V8 #Microsoft #MicrosoftFabric #FabricTechTalkFridays