NodeBits & StepBits change about snowflake HOT 2 CLOSED

Without a bit of testing or a lot more thinking, I'm not sure 100% that you couldn't find some whacky mixture of node bits and step bits where you could create the same ID, though I think it's very unlikely. They would have to be made during the exact same millisecond and somehow have the node, and step bits be aligned too.

I would say, the uniqueness guarantee is for ID's created with the same NodeBits and StepBits settings.

You example above isn't valid though, the NodeBits + StepBits cannot be more than 22 total, that's the amount of space available to them.

from snowflake.

Thanks your reply. In theory, It will be a tiny chance to get the same id when stepBits run out in the same millisecond. Yes, it's better to create snowflakeID with same NodeBits and StepBits settings at the same project or cluster.

from snowflake.