MSC-PG0026

The sequence option 'option_name' is not supported by Snowflake.

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

Severity

Low

Description

Some options available in PostgreSQL for the sequence statement are not available in Snowflake. Therefore, they are commented out from the code, and an EWI (Error Warning Information) is generated to inform the user.

The unsupported options are:

• Unlogged.

• AS <data_type>.

• MinValue.

• MaxValue.

• No MinValue.

• No MaxValue.

• Cache.

• Cycle.

• Owner By.

Code Example

Input code:

PostgreSQL

CREATE UNLOGGED SEQUENCE sequence_name;

Output code:

Snowflake

 CREATE
----** MSC-WARNING - MSC-PG0026 - 'UNLOGGED' IS NOT SUPPORTED BY SNOWFLAKE. **
--  UNLOGGED
SEQUENCE sequence_name;

Recommendations

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