STREAMING_TABLE_OPERATION_NOT_ALLOWED error class

SQLSTATE: 42601

The operation <operation> is not allowed:

APPLY_CHANGES_UNSUPPORTED_OPERATION

The operation is not supported on APPLY CHANGES 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 Delta Live Tables, instead remove the streaming table from the pipeline definition in Delta Live Tables.

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 Delta Live Tables, instead refresh the streaming table in Delta Live Tables.

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.

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.