New in Microsoft Fabric: The Warehouse and the SQL Analytics Endpoint

Microsoft Fabric’s Warehouse and SQL analytics endpoint have evolved rapidly—with capabilities that make SQL-first analytics faster, safer, and simpler to operate. In this session, you’ll see how the SQL analytics endpoint provides a read-only, T-SQL experience over Delta tables with support for views, functions, and granular SQL security, while using the same engine that powers the Warehouse for low-latency queries. We’ll unpack automatic metadata discovery that keeps table stats and schema in sync without manual steps, and we’ll cover endpoint behavior, limitations, and reprovisioning options you can use to self-mitigate provisioning hiccups. On the Warehouse side, we’ll dive into Warehouse Snapshots—point-in-time, read-only views retained for up to 30 days that decouple reporting from ongoing ETL and enable safe roll-forward of the snapshot timestamp for consistent BI and compliance scenarios. You’ll leave with concrete patterns to combine Warehouse and the SQL analytics endpoint for resilient, performant lake-centric analytics in Fabric.