topic Re: Support for MERGE statement in Data Warehouse

Support for MERGE statement

pmscorca — Fri, 11 Oct 2024 14:57:08 GMT

Hi,

reading the documentation I've noticed the absence of the MERGE statement.

Does Fabric support this more important statement? Why not?

A such statement is very very important to work with a data warehouse!

In SQL Server I've used this statement, in Azure Synapse Analytics I've used this statement,

but I cannot find it in Fabric.

I hope that this feature could be released as soon as possible.

Many many thanks

Re: Support for MERGE statement

tackytechtom — Fri, 11 Oct 2024 17:08:14 GMT

Hi pmscorca ,

You are right, it seems ot be a current limitation:

T-SQL surface area - Microsoft Fabric | Microsoft Learn

However, you might be able to use another syntax than the merge statement, e.g. the code below:

MERGE INTO target_table AS target
USING source_table AS source
ON target.id = source.id
WHEN MATCHED THEN
    UPDATE SET 
        target.col1 = source.col1,
        target.col2 = source.col2
WHEN NOT MATCHED THEN
    INSERT (id, col1, col2)
    VALUES (source.id, source.col1, source.col2);

translates to:

UPDATE target_table
SET 
    target_table.col1 = source_table.col1,
    target_table.col2 = source_table.col2
FROM source_table
WHERE target_table.id = source_table.id; 

INSERT INTO target_table (id, col1, col2)
SELECT source_table.id, source_table.col1, source_table.col2
FROM source_table
LEFT JOIN target_table
ON source_table.id = target_table.id
WHERE target_table.id IS NULL;

Let me know, if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/