SHOW CREDENTIALS

  • Article

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

List all of the credentials present in the workspace that are accessible to the requesting user.

Syntax

SHOW [ STORAGE | SERVICE ] CREDENTIALS

Parameters

  • STORAGE: Lists the storage credentials.

  • SERVICE: Lists the service credentials.

    Applies to: check marked yes Databricks Runtime 15.4 and above.

If none of STORAGE or SERVICE are specified, lists all accessible credentials.

Examples

> SHOW STORAGE CREDENTIALS
  name         comment
  ------------ -----------------
  some_creds   Used to access s3

> SHOW SERVICE CREDENTIALS
  name          comment
  ------------- ----------------------
  service_creds Used to access secrets

> SHOW CREDENTIALS
  name          comment
  ------------- ----------------------
  service_creds Used to access secrets
  some_creds    Used to access s3