MSCEWI2033

Columns may be reordered.

Severity

Low

Description

The referenced table was not found during semantic analysis. The referenced columns may need to be reordered to preserve functionality. This is done automatically when the referenced table is found in the input code, as shown in MSCEWI2032.

Example Code

Input Code:

      CREATE TABLE FK3(
            COL1 INTEGER,
            COL2 INTEGER,
            COL3 INTEGER,
            FOREIGN KEY (COL1, COL2, COL3) REFERENCES FK4 (COL1, COL2, COL3)
      );

Output Code:

      CREATE TABLE DATAWAREHOUSE.PUBLIC.FK3 (
            COL1 INTEGER,
            COL2 INTEGER,
            COL3 INTEGER
      );
      
      /*** MSC-Low - MSCEWI2033 - REFERENCED TABLE NOT FOUND, REFERENCED COLUMNS MAY NEED TO BE REORDERED ***/
      ALTER TABLE DATAWAREHOUSE.PUBLIC.FK3 ADD CONSTRAINT COL1
      FOREIGN KEY (COL1, COL2, COL3) REFERENCES DATAWAREHOUSE.PUBLIC.FK4 (COL1, COL2, COL3) ;

Recommendations

  • Check if you are able to add the missing referenced table to your input code so that SnowConvert is able to automatically reorder the referenced columns.

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