MSCEWI2088

LAYOUT was not found

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

The warning is show when layout used in import clause in not found.

Example code

Input code

.IMPORT INFILE C:\USER\user\my_tr_file_1.tr
  FORMAT UNFORMAT 
  LAYOUT not_layout APPLY insert_into_my_table;

Output code

BEGIN
      CREATE OR REPLACE STAGE &{stagename};
      PUT file://C:\USER\user\my_tr_file_1.tr &{stagename};
      /*** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.  ***/
      /*.IMPORT INFILE C:\USER\user\my_tr_file_1.tr
        FORMAT UNFORMAT
        LAYOUT not_layout APPLY insert_into_my_table*/
       
      /*** MSC-WARNING - MSCEWI2088 - LAYOUT not_layout WAS NOT FOUND ***/
       
    END;

Recommendations

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