At what isolation level are Snowflake streams?
At what isolation level are Snowflake streams?
Snowflake streams operate at the repeatable read isolation level. This means that multiple SQL statements within a single transaction will see the same set of records in a stream. This ensures consistency within the transaction and differs from the read committed mode typically supported for tables.
Streams support repeatable read isolation. In repeatable read mode, multiple SQL statements within a transaction see the same set of records in a stream. This differs from the read committed mode supported for tables, in which statements see any changes made by previous statements executed within the same transaction, even though those changes are not yet committed.
https://docs.snowflake.com/en/user-guide/streams-intro