MSCEWI1048
Sequence warning.
Last updated
Sequence warning.
Last updated
This is a deprecated version of the SnowConvert documentation, please visit the official site .
Low
Information from sequences inside CREATE TABLE statements is extracted in order to build a CREATE OR REPLACE SEQUENCE statement in the migrated Snowflake code.
This EWI is added to the original location of the sequence from which the information was originally collected to create that statement.
No additional user actions are required.
Snowflake has an data type. SnowConvert does not transform IDENTITY columns to this data type because there is no way to update the sequence created by the identity definition. After data is migrated, it might be necessary to update the START WITH
value to ensure that old values are not reused that can be already on the source data. In general, the sequence is considered more flexible as identity creates an unalterable sequence behind the scene.
Also, notice that this will affect the database metadata. If a column uses the IDENTITY then the reports that columns as IS_IDENTITY when the sequence is used that column will not be reported as such but you can check the sequence usage in COLUMN_DEFAULT.
If you need more support, you can email us at