SQL Merge Statement not working

[Raghu_Bindingan]

Hi I am trying to use the SQL Merge statement on databricks

MERGE INTO target

USING source

ON source.key = target.key

WHEN MATCHED

UPDATE SET *

WHEN NOT MATCHED

INSERT *

WHEN NOT MATCHED BY SOURCE

DELETE

This is failing with the error [PARSE_SYNTAX_ERROR] Syntax error at or near 'UPDATE'.(line 18, pos 2). I am running my notebook on a cluster that is running Databricks 12.2

Any help is appreciated.

[UmaMahesh1]

Are you using the wildcard for the Update and insert ?

#DAIS2023

[Raghu_Bindingan · Accepted solution]

I was missing the THEN before UPDATE, INSERT and DELETE. This keyword is missing from the documentation on Databricks https://learn.microsoft.com/en-us/azure/databricks/delta/merge

It now works. Thanks