Did You Snow? is a series created covering content around lesser-known facts of Snowflake Data Cloud! ❄️ Sequences feature is used to generate an auto-incremented series of unique numbers while…

Snowflake Community is a platform for users of the Snowflake cloud data platform to share knowledge, ask questions, and collaborate. Readers can learn about cloud data warehousing, data analytics, and data engineering best practices. With forums, user groups, and community events, Snowflake Community provides resources for Snowflake users to connect and learn from each other.

Snowflake Community

Snowflake sequences do not guarantee gap-free numbers. The ORDER vs NOORDER behavior does not affect the gaps in sequence numbers. To generate a guaranteed contiguous sequence of numbers, one potential solution is to use the ROW_NUMBER() window function.

Did You Snow? #1—Snowflake Sequence does not guarantee gap-free numbers. Why?