DROP STORAGE CREDENTIAL

Preview

Unity Catalog is in Public Preview. To participate in the preview, contact your Databricks representative.

Drops an existing storage credential. An exception is thrown if the location does not exist in the metastore.

Since: Databricks Runtime 10.3

Syntax 

DROP STORAGE CREDENTIAL [ IF EXISTS ] credential_name [ FORCE ]

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.

  • FORCE

    Optionally force the credential to be dropped even if it is used by existing objects. If FORCE is not specified an error is raised if the credential is in use.

Examples 

> DROP STORAGE CREDENTIAL street_cred FORCE;