MATERIALIZED_VIEW_OPERATION_NOT_ALLOWED error class
SQLSTATE: 56038
The materialized view operation <operation>
is not allowed:
DROP_DELTA_LIVE_TABLE
Cannot DROP a materialized view created from Delta Live Tables, instead remove the materialized view from the pipeline definition in Delta Live Tables and retry the pipeline again.
MV_NOT_ENABLED
Materialized view features are not enabled for your workspace. Please reach out to Databricks to enable materialized views for your workspace.
REPLACE_DELTA_LIVE_TABLE
Cannot REPLACE a materialized view created from Delta Live Tables, instead update the materialized view from the pipeline definition in Delta Live Tables and retry the pipeline again.
REQUIRES_DBSQL_PRO_PLUS
Cannot <operation>
the materialized view <tableName>
from <environment>
, please use DBSQL Serverless (recommended) or Pro warehouse.
REQUIRES_SHARED_COMPUTE
Cannot <operation>
the materialized view <tableName>
from an Assigned or No Isolation Shared cluster, please use a Shared cluster or a Databricks SQL warehouse instead.