ALTER PROVIDER

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 11.1 and above check marked yes Unity Catalog only

Renames a provider. Transfers the ownership of a provider to a new principal.

Syntax

ALTER PROVIDER provider_name
  { RENAME TO to_provider_name |
    [ SET ] OWNER TO principal }

Parameters

  • provider_name

    The name of the provider to be altered.

  • RENAME TO to_provider_name

    Renames the provider. The name must be unique among all providers in the metastore. To run this statement, you must be the owner of the provider and have CREATE PROVIDER privilege on the metastore.

  • [ SET ] OWNER TO principal

    Transfers ownership of the provider to principal. To run this statement, you must be the owner of the provider.

    Applies to: check marked yes Databricks SQL SQL warehouse version 2022.35 or higher check marked yes Databricks Runtime 11.2 and above

    SET is allowed as an optional keyword.

Examples

-- Rename a provider
> ALTER PROVIDER `Center for Disease Control` RENAME TO cdc;

-- Change ownership of the provider
> ALTER PROVIDER cdc OWNER TO `alf@melmak.et`