ALTER CATALOG (Databricks SQL)

Preview

Unity Catalog is in Public Preview. To participate in the preview, contact your Databricks representative.

Transfers the ownership of a catalog to a new principal.

Syntax

ALTER CATALOG [ catalog_name ] OWNER TO principal

Parameters

  • catalog_name

    The name of the catalog to be altered. If you provide no name the default is hive_metastore.

  • OWNER TO principal

    Transfers ownership of the catalog to principal.

Examples

-- Creates a catalog named `some_cat`.
> CREATE CATALOG some_cat;

-- Transfer ownership of the catalog to another user
> ALTER CATALOG some_cat OWNER TO `alf@melmak.et`;