MERGE (UPSERT) - AZURE SQL DWH

1
votes

I been working long with on-premises DWH solutions. Now moving to AZURE DWH.

Right now am up-to doing most of the processing / transformation in Azure Databricks and writing the result set to Azure SQL DWH Staging Tables.

Now I want to MERGE (UPSERT) the Dimensions and Load Fact Tables.

As MERGE is not supported in AZURE SQL DWH, what is the best way to accomplish this?

1
azureazure-sql-databaseazure-databricksazure-sql-data-warehouse

1 Answers

2
votes

MERGE is not support with AZURE SQL DWH, Azure SQL DWH team said they are planning to support this feature. Reference: MERGE statement support.

I found this blog, MSFT give an example to use UPDATE/INSERT statements instead of MERGE.

Hope this helps.