MSCEWI3001

Sequence start value with 'LIMIT VALUE' is not supported by Snowflake.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Medium

Description

This error appears when the START WITH statement value is LIMIT VALUE.

Example Code

Input Code:

CREATE SEQUENCE SEQUENCE1
  START WITH LIMIT VALUE;

Output Code:

/*** MSC-ERROR - MSCEWI3001 - SEQUENCE START VALUE WITH 'LIMIT VALUE' IS NOT SUPPORTED BY SNOWFLAKE. ***/
CREATE SEQUENCE PUBLIC.SEQUENCE1
--START WITH LIMIT VALUE
                      ;

Recommendations

• No additional user actions are required.

• If you need more support, you can email us at [email protected]