DROP STORAGE 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 storage credential. An exception is thrown if the location does not exist in the metastore. To drop a storage credential you must be its owner.

Syntax 

DROP STORAGE CREDENTIAL [ IF EXISTS ] credential_name

Parameters

  • IF EXISTS

    If specified, no exception is thrown when the credential does not exist.

  • 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.

Examples 

> DROP STORAGE CREDENTIAL street_cred;