MSCEWI2006

Column name not supported.

Severity

Medium

Description

Some column names that are supported for Teradata are not supported for Snowflake, such as reserved names.

Code Example

Input Code:

CREATE MULTISET TABLE T_2006 ,
NO FALLBACK
(
LOCALTIME INTEGER,
LOCALTIMESTAMP INTEGER,
CURRENT_TIME INTEGER
);

Output Code:

CREATE TABLE PUBLIC.T_2006
(
XXX_LOCALTIME_XXX INTEGER /*** MSC-WARNING - MSCEWI2006 - LOCALTIME COLUMN NAME NOT SUPPORTED ***/,
XXX_LOCALTIMESTAMP_XXX INTEGER /*** MSC-WARNING - MSCEWI2006 - LOCALTIMESTAMP COLUMN NAME NOT SUPPORTED ***/,
XXX_CURRENT_TIME_XXX INTEGER /*** MSC-WARNING - MSCEWI2006 - CURRENT_TIME COLUMN NAME NOT SUPPORTED ***/
);

Recommendations

  • Consider renaming the columns that use names that are not supported in Snowflake.

  • For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.