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-...

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