SSC-FDM-RS0005

Duplicates not allowed in source table

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Description

In Redshift, the MERGE statement throws an error when the source table has duplicate values. Snowflake doesn't throw the error and instead, it allows the query execution. The FDM warns about this behavior, that it could change the result in the converted MERGE.

Code Example

Input Code:

Redshift

IN -> Redshift_01.sql

MERGE INTO target USING source ON target.id = source.id
WHEN MATCHED THEN DELETE
WHEN NOT MATCHED THEN INSERT VALUES (source.id, source.name);

Output Code:

Snowflake

OUT -> Redshift_01.sql

--** SSC-FDM-RS0005 - REDSHIFT MERGE STATEMENT DOESN'T ALLOW DUPLICATES IN THE SOURCE TABLE. SNOWFLAKE BEHAVIOR MAY DIFFER IF THERE ARE DUPLICATE VALUES. **
MERGE INTO target USING source ON target.id = source.id
WHEN MATCHED THEN DELETE
WHEN NOT MATCHED THEN INSERT VALUES (source.id, source.name);

Recommendations

• If you need more support, you can email us at [email protected]