What is one characteristic of how streams operate in Snowflake?
A Snowflake stream’s offset advances when its change data is consumed in a DML transaction, such as an operation that updates a target table. A standalone query does not advance the offset, and stream results represent CDC change records rather than all rows in the source table.
Community Discussion