SQL Analytics Endpoint - SQL on the Lakehouse

Your Lakehouse speaks SQL — but there's a catch. The SQL Analytics Endpoint is read-only. Why is that the case, and how does the architecture work behind the scenes? In this Fabric Friday episode, I explain the complete architecture from OneLake to TDS endpoint, show how the metadata sync works, demonstrate the security model (RLS, CLS, dynamic masking), and walk you through the decision matrix: SQL Endpoint vs. Warehouse vs. SQL Database. 📋 Chapters: 00:00 Introduction – Speaks SQL, But... 00:15 Architecture Overview 02:07 Metadata Sync – Less Than One Minute Lag 03:16 SQL Engine – Distributed Query Engine (DQE) 04:23 TDS Protocol – Standard Compatible 05:21 Demo: Create Lakehouse & Ingest Data 07:05 Demo: Import Data with Pipeline 10:30 Auto-Sync Deep Dive – Background Scanner 13:00 Security Model – Workspace Roles & Permissions 15:30 Demo: Run Notebook to Load Tables 18:00 Demo: Query with SQL Endpoint 20:00 Demo: Connect from VS Code 22:00 Power BI Direct Lake vs. Direct Query 25:30 Fallback Triggers – When Direct Lake Falls Back 28:00 Decision Matrix: SQL Endpoint vs. Warehouse vs. SQL Database 31:00 Community Q&A 37:00 Outro 🔗 Links & Resources: 📖 SQL Analytics Endpoint Overview: https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-sql-analytics-endpoint 📖 Performance Considerations: https://learn.microsoft.com/en-us/fabric/data-warehouse/sql-analytics-endpoint-performance 📖 Decision Guide: https://learn.microsoft.com/en-us/fabric/fundamentals/decision-guide-lakehouse-warehouse 📖 SQL Granular Permissions: https://learn.microsoft.com/en-us/fabric/data-warehouse/sql-granular-permissions 📖 Row-Level Security: https://learn.microsoft.com/en-us/fabric/data-warehouse/row-level-security 📖 Direct Lake Overview: https://learn.microsoft.com/en-us/fabric/fundamentals/direct-lake-overview 🧪 Fabric Periodic Table: https://fabric-periodic-table.com 👤 About me: Matthias Falland – The Trusted Advisor Microsoft Data Platform MVP 🌐 https://www.the-trusted-advisor.com 🔗 LinkedIn: https://www.linkedin.com/in/intune/ 🎓 Fabric Periodic Table: https://fabric-periodic-table.com 📍 Fabric Community Meetup (Zürich/Hamburg/Basel): https://www.meetup.com/ai-and-intelligent-cloud/