A stream object will advance its offset when it is used in which statement?
A stream object will advance its offset when it is used in which statement?
https://docs.snowflake.com/en/user-guide/streams-intro Note To advance the offset of a stream to the current table version without consuming the change data in a DML operation, complete either of the following actions: Recreate the stream (using the CREATE OR REPLACE STREAM syntax). Insert the current change data into a temporary table. In the INSERT statement, query the stream but include a WHERE clause that filters out all of the change data (e.g. WHERE 0 = 1).