Skip to main content

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

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 Admins group.
    • 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.
description description description

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

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-engineers group owns the project c360 therefore they must be the owners of c360_bronze, c360_silver and c360_gold schemas.

The governance best practices would be covered on 4. Data Governance Strategy.

Screenshots

description

Expected results

For all external locs - storage creds - connections

description

For catalogs and schemas

description