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.

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 Lakeflow Spark Declarative Pipelines, instead remove the streaming table from the pipeline definition in Lakeflow Spark Declarative Pipelines.

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 Lakeflow Spark Declarative Pipelines, instead refresh the streaming table in Lakeflow Spark Declarative Pipelines.

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.