MSCEWI3069

The sequence CURRVAL property is not supported in Snowflake.

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

Severity

Medium

Description

The sequence CURRVAL property is not supported in Snowflake.

Example Code

Input Code:

select seq1.currval from dual;

Output Code:

select
/*** MSC-ERROR - MSCEWI3069 - THE SEQUENCE CURRVAL PROPERTY IS NOT SUPPORTED IN SNOWFLAKE. ***/
PUBLIC.CURRVAL_UDF('seq1.currval')
from dual;

Recommendations

• You can check this link to see what Snowflake suggests to handle situations where the CURRVAL property is used.

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