This is a deprecated version of the SnowConvert documentation, please visit the official site .
Snowflake doesn't support Indexes, thus this message is shown when SnowConvert transforms Teradata Non Unique Primary Index.
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");
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")
);