MSCEWI2065
Non Unique Primary Index is not supported in Snowflake
Low
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")
);
- 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.
Last modified 10mo ago