Sematic information could not be loaded.
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 the creation of such an object depends on another one that is missing, and therefore SnowConvert could not complete the analysis of the original object.
In the following example, it can be seen that the creation of
TABLE1, but if this table was not found in the input code, then SnowConvert cannot complete the semantic analysis for
VIEW1and will add the following warning on the output code.
CREATE VIEW VIEW1 AS SELECT FUN2(COL2) FROM TABLE1;
/*** MSC-WARNING - MSCEWI1039 - SEMANTIC INFORMATION COULD NOT BE LOADED FOR VIEW1. CHECK IF THE NAME IS INVALID OR DUPLICATED. ***/
CREATE OR REPLACE VIEW PUBLIC.VIEW1