topic Re: Datawarehouse MERGE command not working in Fabric in Pipelines

Datawarehouse MERGE command not working in Fabric

sudhav — Tue, 11 Jul 2023 03:47:49 GMT

Hi Team, I am trying to do incremental load from ADLS gen2 to Warehouse. In that process I need to create one store proc which includes MERGE statement(upsert), but its not allowing me to do that.

please look into it.

TIA

Re: Datawarehouse MERGE command not working in Fabric

GraceGu — Tue, 11 Jul 2023 08:57:26 GMT

Merge statement is not supported in Fabric data warehouse yet, refer to T-SQL surface area - Microsoft Fabric limitations.

Re: Datawarehouse MERGE command not working in Fabric

JamesBxxx — Fri, 03 Nov 2023 14:00:54 GMT

How do i track releases on this to see if/when a release covers MERGE statements implementation?

Re: Datawarehouse MERGE command not working in Fabric

daxman — Mon, 04 Mar 2024 20:42:54 GMT

Will MERGE statement support be coming soon to Data Warehouses?

Re: Datawarehouse MERGE command not working in Fabric

KimBeck — Mon, 11 Mar 2024 12:03:13 GMT

This guy has a proposed workaound:

https://www.purplefrogsystems.com/2023/06/microsoft-fabric-so-how-do-i-build-a-data-warehouse-without-identity-columns-and-merge/