Which table type is suitable for an insert-only stream?
Snowflake requires the INSERT_ONLY setting for streams on external tables and does not support insert-only streams on temporary, hybrid, or transient tables. An insert-only stream records newly added rows without recording deletions.
INSERT_ONLY
Community Discussion