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


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:


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.


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