Can we able to create materialized view in databricks using all purpose cluster

Shivaprasad — Sat, 23 May 2026 15:09:12 GMT

I was unable to create materialized view in databricks using all purpose cluster wanted to check do we need serverless cluster to create MV

Re: Can we able to create materialized view in databricks using all purpose cluster

szymon_dybczak — Sat, 23 May 2026 16:53:27 GMT

Hi @Shivaprasad ,

Nope, all purpose cluster are not supported. Standalone materialized views can be created/refreshed either from a Unity Catalog-enabled Pro or Serverless SQL Warehouse, or from a notebook attached to Serverless General Compute.

So we don’t necessarily need a “serverless cluster” specifically, but we do need one of the supported compute options - I.e a SQL Warehouse. An all-purpose cluster is not supported for creating standalone materialized views.

For materialized view created via pipeline you can choose serverless or classic compute:

https://docs.databricks.com/aws/en/ldp/configure-compute

Here is similar thread:

https://community.databricks.com/t5/data-engineering/spark-declarative-pipelines-use-in-all-purpose-compute/td-p/144076

If my answer was helpful, please consider marking it as accepted solution

topic Re: Can we able to create materialized view in databricks using all purpose cluster in Data Engineering

Can we able to create materialized view in databricks using all purpose cluster

Re: Can we able to create materialized view in databricks using all purpose cluster