SSC-FDM-0019

Sematic information could not be loaded.

Description

This warning lets the user know that SnowConvert was not able to load semantic information for a specific object. This is most likely caused because if there is a duplicated object with the same name, SnowConvert could not load the semantic information of this object and complete the analysis.

Example Code

Input Code:

IN -> Teradata_01.sql
CREATE TABLE T1
(
    COL1 INTEGER
);


CREATE TABLE T1
(
    COL2 INTEGER
);

Output Code:

OUT -> Teradata_01.sql
CREATE OR REPLACE TABLE T1
(
    COL1 INTEGER
)
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"teradata"}}'
;

--** SSC-FDM-0019 - SEMANTIC INFORMATION COULD NOT BE LOADED FOR T1. CHECK IF THE NAME IS INVALID OR DUPLICATED. **
CREATE TABLE T1
(
    COL2 INTEGER
)
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"teradata"}}'
;

Recommendations

  • Check for duplicate objects in the input code since this may affect the loading of semantic information.

  • If you need more support, you can email us at snowconvert-support@snowflake.com

Last updated