ALTER CREDENTIAL

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

Renames a credential.

Syntax 

ALTER [ STORAGE | SERVICE ] CREDENTIAL credential_name
  { RENAME TO to_credential_name |
    [ SET ] OWNER TO principal }

Parameters

  • [ STORAGE | SERVICE ] [credential_name](sql-ref-names.md#credential-name)

    Identifies the credential being altered. The keywords STORAGE and SERVICE (check marked yes Databricks Runtime 15.4 and later) are optional.

  • RENAME TO to_credential_name

    Renames the credential a new name. The name must be unique among all credentials in the metastore.

  • [ SET ] OWNER TO principal

    Transfers ownership of the credential to principal.

    Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 11.3 LTS and above

    SET is allowed as an optional keyword.

Examples 

> ALTER CREDENTIAL street_cred RENAME TO good_cred;

> ALTER CREDENTIAL street_cred OWNER TO `alf@melmak.et`