Microsoft Fabric Updates Blog

Warehouse Snapshots in Microsoft Fabric (Preview)

Maintaining data consistency during ETL (Extract, Transform, Load) processes has long been a critical challenge for data engineers. Whether it’s a nightly pipeline overwriting key records or a mid-day transformation introducing schema drift, the risk of disrupting downstream analytics is both real and costly. In today’s fast-paced, data-driven world, even brief inconsistencies can break dashboards, … Continue reading “Warehouse Snapshots in Microsoft Fabric (Preview)”

Session-scoped distributed #temp tables in Fabric Data Warehouse (Generally Available)

Introducing distributed session-scoped temporary (#temp) tables in Fabric Data Warehouse and Fabric Lakehouse SQL Endpoints. #temp tables have been a feature of Microsoft SQL Server (and other database systems) for many years. In the current implementation of Fabric data warehouse, #temp tables are session scoped or local temp tables. Global temp tables are not included … Continue reading “Session-scoped distributed #temp tables in Fabric Data Warehouse (Generally Available)”