Which isolation level is used by Snowflake streams?
Snowflake streams use repeatable read isolation, so multiple SQL statements within a transaction see the same set of stream records. Stream delta records span from the stream’s current position to the transaction start time.
Community Discussion