'Is it possible to only capture Inserts and Updates in snowflake streams

I have created snowflake stream on table TEST1 to capture change in the data in TEST1 table as below. I only want Inserts and Updates to be captured in STREAM_TEST, so that when I delete records from TEST1, it shouldn't get captured in STREAM_TEST. Is there a way to do that?

create or replace stream STREAM_TEST
on table TEST1
APPEND_ONLY = FALSE
comment = 'stream on stage table';
streamsnowflake-cloud-data-platform


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions