ALTER PROVIDER
Applies to: Databricks SQL Databricks Runtime 11.3 LTS and above 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
-
The name of the provider to be altered.
RENAME TO
to_provider_nameRenames 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
principalTransfers ownership of the provider to
principal
. To run this statement, you must be the owner of the provider.Applies to: Databricks SQL Databricks Runtime 11.3 LTS 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`