UC assets ownership
info
- Change Unity Catalog assets ownership to follow the best practices mentioned on the groups section.
- Change the ownership of the existing assets to the
Metastore Admins|Unity Adminsgroup.
Step-by-step guide for external locations - storage credentials - connections.
- Check the screenshots.
- On the workspace left panel, click on Catalog.
- Click on ⚙️ and go to External Locations.
- For each tab (External Locations, Credentials, Connections, External Metadata), change the owner of all assets to
Metastore Admins|Unity Adminsgroup.- Click on the asset.
- On the far right, click the ✏️ edit button next to the owners name.
- There is going to be at most 3 storage locations and external locations.
- Note: If the External Locations or Credentials tab is empty, probably you don't belong to the metastore Admins group.
Screenshots
warning
- Access external locations, storage credentials, and connections by clicking the wheel icon (⚙️).
- The first screenshot is going to be updated soon.
Step-by-step guide for catalogs.
- On the workspace left panel, click on Catalog.
- For each catalog that is not the system catalog:
- Click the catalog.
- On the overview tab, search for the About this catalog section to find the Owner.
- Click the ✏️ icon to change the owner to
Metastore Admins|Unity Adminsgroup.
What about the schemas owner?
-
In Databricks, we use Schemas (aka Databases) to hold all the Unity Catalog assets (tables, views, models, etc..) for a specific project.
-
The Rule of Ownership: If a specific group is in charge of a project, that group should own the folder (Schema) too.
- i.e
data-engineersgroup owns the projectc360therefore they must be the owners ofc360_bronze,c360_silverandc360_goldschemas.
- i.e
The governance best practices would be covered on 4. Data Governance Strategy.
Screenshots
Expected results
For all external locs - storage creds - connections
For catalogs and schemas
