Streams: CREATE STREAM with INSERT_ONLY = TRUE Not Allowed on Non-external Tables¶

Attention

This behavior change is in the 2023_01 bundle.

For the current status of the bundle, refer to Bundle History.

CREATE STREAM with INSERT_ONLY = TRUE specified for a non-external table now produces an error and the statement fails:

Previously:

The Snowflake Documentation states that the use of INSERT_ONLY is not allowed on non-external tables. However, when INSERT_ONLY was specified, the command executed successfully, but INSERT_ONLY was not enforced.

Currently:

Any attempt to create an INSERT_ONLY stream on non-external tables throws the following error:

Streams of type INSERT_ONLY can only be created on external tables.

Ref: 795