MSCEWI2040

The format in a table is not supported.

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

Severity

Low

Description

The specified format is not supported.

Example Code

Input Code:

CREATE TABLE T_2040
(
    C1 VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC FORMAT 'X(50)',
    C2 VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC FORMAT 'X(75)'
);

Output Code:

CREATE TABLE PUBLIC.T_2040
(
    C1 VARCHAR(255) COLLATE 'en-ci' /*** MSC-WARNING - MSCEWI2040 - FORMAT 'X(50)' NOT SUPPORTED ***/,
    C2 VARCHAR(255) COLLATE 'en-ci' /*** MSC-WARNING - MSCEWI2040 - FORMAT 'X(75)' NOT SUPPORTED ***/
);

Recommendations

• No additional user actions are required.

• For INTEGER FORMAT '99:99:99' a workaround is to use TIME(6) in Snowflake.

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