Source
Snowflake Data Clean Rooms: Identity and data provider connectors
Identity connectors can be used to resolve and join entities between tables when different values refer to the same entity.
Why does a gap occur on identity columns?
Answer: Snowflake utilizes an internal sequence to generate the values for the identity column, and it does not guarantee to generate gap - free sequence numbers. This is because of Snowflake caches "sequence values" when they are started…