Datawarehouse MERGE command not working in Fabric

[sudhav]

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

[KimBeck]

This guy has a proposed workaound:

https://www.purplefrogsystems.com/2023/06/microsoft-fabric-so-how-do-i-build-a-data-warehouse-withou... 

[JamesBxxx]

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

[GraceGu · Accepted solution]

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

[daxman]

Will MERGE statement support be coming soon to Data Warehouses?