SSC-EWI-RS0009
Semantic information not found for the source table.
Severity
Low
Description
In Snowflake, the MERGE with REMOVE DUPLICATES clause is not supported. To fully support the original code, a workaround is needed. An INSERT WHEN NOT MATCHED clause needs to be generated in the output code, and it requires the source table columns. If the source table was not found during migration, no columns are generated, and an error will be thrown.
Code Example
Input Code:
IN -> Redshift_01.sql
Output Code:
OUT -> Redshift_01.sql
Recommendations
Search to see if the source table is present in the migrated code and manually add the columns in the insert operation.
Last updated