MSCEWI2065

Non Unique Primary Index is not supported in Snowflake

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

Severity

Low

Description

Snowflake doesn't support Indexes, thus this message is shown when SnowConvert transforms Teradata Non Unique Primary Index.

Example code

Input Code:

CREATE TABLE DEMO.TABLE_PRIMARY_INDEX
     (
      "NAME" VARCHAR(13),
       ID INT)
PRIMARY INDEX PRIMARY_INDEX_NAME ( "NAME");

CREATE TABLE DEMO.TABLE_UNIQUE_PRIMARY_INDEX 
     (
      "NAME" VARCHAR(13),
       ID INT)
UNIQUE PRIMARY INDEX PRIMARY_INDEX_NAME ( "NAME");

Output Code:

CREATE TABLE DEMO.PUBLIC.TABLE_PRIMARY_INDEX
(
"NAME" VARCHAR(13),
ID INT)
/*** MSC-WARNING - MSCEWI2065 - PRIMARY INDEX IS NOT SUPPORTED IN SNOWFLAKE ***/
/*PRIMARY INDEX PRIMARY_INDEX_NAME("NAME")*/;

CREATE TABLE DEMO.PUBLIC.TABLE_UNIQUE_PRIMARY_INDEX (
"NAME" VARCHAR(13),
ID INT,
UNIQUE ( "NAME")
);

Recommendations

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