Which isolation level do Snowflake streams use?
Snowflake streams provide repeatable read isolation, so multiple SQL statements in the same transaction see the same stream records. The stream offset advances to the transaction start time only when that transaction commits.
Community Discussion