Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-17-2025 11:05 AM - edited 09-17-2025 11:06 AM
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