STREAMING_TABLE_OPERATION_NOT_ALLOWED error condition

SQLSTATE: 42601

The operation <operation> is not allowed:

APPLY_CHANGES_UNSUPPORTED_OPERATION

The operation is not supported on AUTO CDC streaming tables.

AUTOCDC_NON_ADDITIVE_COLUMN_ALTER

Non-additive column ALTER operations (DROP COLUMN, RENAME COLUMN) are not allowed on AutoCDC streaming tables.

CREATE_OR_REPLACE

REPLACE is not allowed for streaming tables; please update the command to use CREATE OR REFRESH instead and then retry the command.

CREATE_TABLE_IN_HIVE_METASTORE

Cannot CREATE a streaming table in the Hive Metastore. streaming tables are only supported in Unity Catalog. Please specify a destination catalog for this table in your Unity Catalog metastore by USE CATALOG catalogName; CREATE STREAMING TABLE schemaName.tableName or CREATE STREAMING TABLE catalogName.schemaName.tableName. You can see a list of available catalogs by SHOW CATALOGS.

DROP_DELTA_LIVE_TABLE

The operation does not apply to streaming tables created from Spark Declarative Pipelines on Lakeflow, instead remove the streaming table from the pipeline definition in Spark Declarative Pipelines on Lakeflow.

INVALID_ALTER

To alter the schema or properties of streaming tables, please use the CREATE OR REFRESH command.

NON_STREAMING_TABLE

<tableName> is not a streaming table.

REFRESH_DELTA_LIVE_TABLE

The operation does not apply to streaming tables created from Spark Declarative Pipelines on Lakeflow, instead refresh the streaming table in Spark Declarative Pipelines on Lakeflow.

REQUIRES_SHARED_COMPUTE

Cannot <operation> a streaming table <tableName> from an Assigned or No isolation shared cluster, please use a SHARED cluster or a Databricks SQL warehouse instead.

ST_NOT_ENABLED_ON_SERVERLESS_GENERIC_COMPUTE

Cannot <operation> the streaming table <tableName> in Serverless Generic Compute for your workspace. Enable it by enrolling in the Serverless Generic Compute materialized view/streaming table workspace feature preview. If you do not see the beta feature preview available in workspace, please contact your Databricks representative.

UNKNOWN_FEATURES

streaming table <tableName> supports features from newer versions. Please run this <operation> operation on a newer release.

UNSUPPORTED_OPERATION

The operation is not supported on streaming tables.