RetroSearch Browse

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-ddl-alter-provider below:

ALTER PROVIDER | Databricks Documentation

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.

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: Databricks SQL Databricks Runtime 11.3 LTS and above

SET is allowed as an optional keyword.

Examplesâ

SQL

-- 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`