Index

Translation reference to convert INDEX statement to Snowflake

Currently, Create Index statement is not being converted but it is being parsed. Also, if your source code has Create index statements, these are going to be accounted for in the Assessment Report.

Example of Create Index

Teradata input

CREATE INDEX (col1, col2, col3) ORDER BY VALUES (col2) ON table1;

CREATE INDEX my_index_name ON my_table (column1, column2);

Snowflake output

----** MSC-INFORMATION - MSCINF0011 - CREATE INDEX NOT SUPPORTED. **
--CREATE INDEX (col1, col2, col3) ORDER BY VALUES (col2) ON table1
                                                                ;

----** MSC-INFORMATION - MSCINF0011 - CREATE INDEX NOT SUPPORTED. **
--CREATE INDEX my_index_name ON my_table (column1, column2)
                                                         ;

Related EWIs

1. MSCINF0011 - CREATE INDEX NOT SUPPORTED