MERGE
Last updated
Last updated
For more information please refer to Redshift .
There are no differences between both languages. The code is kept in its original form.
There are no differences between both languages. The code is kept in its original form.
The REMOVE DUPLICATES clause is not supported in Snowflake, however, there is a workaround that could emulate the original behavior.
The output code will have three new statements:
A TEMPORARY TABLE with the duplicate values from the source and target table that matches the condition
An INSERT statement that adds the pending values to the target table after the merge
A DROP statement that drops the generated temporary table.
These are necessary since the DROP DUPLICATES behavior removes the duplicate values from the target table and then inserts the values that match the condition from the source table.
There are no known issues.
: Semantic information not found for the source table.
: Duplicates not allowed in source table.