There are multiple requirements for materialized views. You can check below

• You must use a Unity Catalog enabled pro or serverless SQL warehouse.

• To incrementally refresh a materialized view from Delta tables, the source tables must have row tracking enabled.

• The owner (the user who creates the materialized view) must have the following permissions:

  • SELECT privilege on the base tables referenced by the materialized view.
  • USE CATALOG and USE SCHEMA privileges on the catalog and schema containing the source tables for the materialized view.
  • USE CATALOG and USE SCHEMA privileges on the target catalog and schema for the materialized view.
  • CREATE TABLE and CREATE MATERIALIZED VIEW privileges on the schema containing the materialized view.
• Workspace must be in a region that supports serverless SQL warehouses.