szymon_dybczak
Esteemed Contributor III

Hi @Data_NXT ,

You can change the owner of a materialized view if you are a both a metastore admin and a workspace admin.

Use the following steps to change a materialized views owner:

  • Open the materialized view in Catalog Explorer, then on the Overview tab, click See refresh details. This opens the pipeline details for the pipeline that manages the materialized view.
  • Click Share. The Permissions Settings dialog appears. You must be a metastore and workspace admin to edit these settings.
  • Click x to the right of the current owner's name to remove the current owner.
  • Start typing to filter the list of available users. Click the user who should be the new pipeline owner.
  • Click Save to save your changes and close the dialog.

Here's a documentation:

Configure materialized views in Databricks SQL - Azure Databricks | Microsoft Learn

 

And if you would like to change owner of a pipeline as well, here's how to do this:

Cannot see how to change the owner of a DLT pipeline in the Databricks UI - Databricks

View solution in original post