Search code examples
azureazure-sql-databaseazure-databricksazure-synapse

MERGE (UPSERT) - AZURE SQL DWH

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?

Solution

  • 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.