Check out the first Dataiku 8 Deep Dive focusing on Productivity on October 29th Read More

SQL Merge command in SQL query

Neuron
Neuron
SQL Merge command in SQL query

Hello Community,

I was wondering if I could use the SQL MERGE command inside a DSS SQL Query recipe.

The structure of the Merge command is:

MERGE target_table
USING source_table ON merge_condition
WHEN MATCHED THEN update_statement
WHEN NOT MATCHED THEN insert_statement
WHEN NOT MATCHED BY SOURCE THEN DELETE;

See https://www.sqlservertutorial.net/sql-server-basics/sql-server-merge/ 

 

Thanks in advance.

0 Kudos
2 Replies
Dataiker
Dataiker

Hi,

you cannot use MERGE inside a SQL Query recipe, but that should work inside a SQL Script recipe (the second option in the modal you get when you create a SQL recipe)

Neuron
Neuron
Author

Thank you for your response.

0 Kudos