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
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.

MSCEWI2064

MSCEWI2066

Last modified 10mo ago