MSCEWI2065

Non Unique Primary Index is not supported in Snowflake

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