MSCEWI3044

An option was removed from the options.

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

Severity

Low

Description

An option was removed from a CREATE SEQUENCE query because is not supported in Snowflake.

Example Code:

Input Code:

CREATE SEQUENCE SequenceSample
START WITH     1000
INCREMENT BY   1
NOCACHE
NOCYCLE
NOPARTITION;

Output Code:

/*** MSC-WARNING - MSCEWI3044 - NOCACHE REMOVED FROM THE OPTIONS. ***/
/*** MSC-WARNING - MSCEWI3044 - NOCYCLE REMOVED FROM THE OPTIONS. ***/
/*** MSC-WARNING - MSCEWI3044 - NOPARTITION REMOVED FROM THE OPTIONS. ***/
CREATE SEQUENCE PUBLIC.SequenceSample
START WITH     1000
INCREMENT BY   1;

Recommendations

• No additional user actions are required.

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