Skip to main content
Last updated on

DROP CREDENTIAL

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

Drops an existing credential. Databricks throws an exception if the location does not exist in the metastore. To drop a credential you must have the MANAGE privilege on the credential or be its owner.

Syntax​

DROP [ STORAGE | SERVICE ] CREDENTIAL [ IF EXISTS ] credential_name [ FORCE ]

Parameters​

  • IF EXISTS

    If specified, Databricks does not throw an exception when the credential does not exist.

  • [ STORAGE | SERVICE ] credential_name

    The name of an existing credential in the metastore. If the name does not exist, an exception is thrown unless IF EXISTS has been specified.

    The usage of STORAGE and SERVICE (check marked yes Databricks Runtime 15.4 and above) is optional.

  • FORCE

    Optionally force Databricks to drop the credential even if existing objects use it. If FORCE is not specified, an error is raised when the credential is in use.

    important

    Forcing the deletion of a storage credential leaves any external locations that depend on it without a valid credential. Those external locations are no longer usable until you assign a new credential.

Examples​

SQL
> DROP CREDENTIAL street_cred;

-- Drop a storage credential even if external locations depend on it.
> DROP STORAGE CREDENTIAL street_cred FORCE;

Related articles​

On this page