--- title: "Did You Snow? #1—Snowflake Sequence does not guarantee gap-free numbers. Why?" url: https://daily.dev/posts/did-you-snow-1-snowflake-sequence-does-not-guarantee-gap-free-numbers-why--v73aeoch7 source_url: https://medium.com/snowflake/did-you-snow-1-sequences-does-not-guarantee-gap-free-numbers-why-cd6d2f74c0ec type: article source: "Snowflake Community" published: 2024-05-10T21:23:40.535Z updated: 2024-05-10T21:23:39.600Z tags: ["big-data", "snowflake"] reading_time: 3 upvotes: 0 comments: 0 language: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Did You Snow? #1—Snowflake Sequence does not guarantee gap-free numbers. Why? **[Snowflake Community](https://daily.dev/sources/snowflake_comm)** · 3 min read · 0 upvotes · 0 comments ## Summary 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. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [Don’t just attend KubeCon \+ CloudNativeCon, Merge Forward your experience\!](https://daily.dev/posts/don-t-just-attend-kubecon-cloudnativecon-merge-forward-your-experience--l0rpp73x8) · CNCF · 0 upvotes · 0 comments - [Announcing H2 2026 KCDs](https://daily.dev/posts/announcing-h2-2026-kcds-m96goajm1) · CNCF · 1 upvotes · 0 comments - [Two months of Open Community Groups](https://daily.dev/posts/two-months-of-open-community-groups-asf52zhbs) · CNCF · 0 upvotes · 0 comments --- Tags: [#big-data](https://daily.dev/tags/big-data), [#snowflake](https://daily.dev/tags/snowflake) [View this post on daily.dev](https://daily.dev/posts/did-you-snow-1-snowflake-sequence-does-not-guarantee-gap-free-numbers-why--v73aeoch7)