MSCEWI1045

Column Name Is Snowflake Reserved Keyword.

Severity
Low
Description
Column names that are valid for Oracle but are reserved keywords in Snowflake.  These columns are being converted to lowercase and added double -quotes.
Code Example
Input Code:
CREATE TABLE T1
(
    LOCALTIME NUMBER,
    CURRENT_USER NUMBER
);
Output Code:
CREATE OR REPLACE TABLE PUBLIC.T1
( /*** MSC-WARNING - MSCEWI1045 - COLUMN NAME LOCALTIME IS A SNOWFLAKE RESERVED KEYWORD ***/
 "localtime" NUMBER (38,19),
/*** MSC-WARNING - MSCEWI1045 - COLUMN NAME CURRENT_USER IS A SNOWFLAKE RESERVED KEYWORD ***/
"current_user" NUMBER (38,19)
);
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.

MSCEWI1044

MSCEWI1046

Last modified 1yr ago