MSC-PG0024

Advance sequence and return new value

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

Severity

Low

Description

Snowflake does not guarantee generating sequence numbers without gaps. The generated numbers consistently increase in value (or decrease in value if the step size is negative) but are not necessarily contiguous.

Code Example

Input Code:

First Tab

SELECT nextval('seq1');

Output Code:

First Tab

SELECT seq1.nextval;

Recommendations

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