topic Re: SQL Merge Statement not working in Data Engineering

SQL Merge Statement not working

Raghu_Bindingan — Wed, 12 Apr 2023 14:18:17 GMT

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.

Re: SQL Merge Statement not working

UmaMahesh1 — Thu, 13 Apr 2023 10:10:13 GMT

Are you using the wildcard for the Update and insert ?

#DAIS2023

Re: SQL Merge Statement not working

Raghu_Bindingan — Thu, 13 Apr 2023 18:11:03 GMT

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