Finally, MERGE Statement Will Be Supported in Fabric DW
Microsoft Fabric Data Warehouse now supports the powerful MERGE statement, streamlining data sync operations. It enables seamless INSERT, UPDATE, and DELETE logic in one atomic block—ideal for SCD and ETL workflows. This long-awaited feature simplifies code, boosts performance, and aligns Fabric DW with enterprise SQL standards. A major win for data engineers—Fabric just got more intuitive, efficient, and migration-friendly! Why MERGE Matters The MERGE statement allows you to: Synchronize staging and target tables in one atomic operation Handle Slowly Changing Dimensions (SCD) with ease (Types 0, 1, and 2) Simplify ETL logic by combining INSERT, UPDATE, and DELETE into a single block Reduce code complexity and improve performance in large-scale transformations