SHOW CREDENTIALS

Applies to: Databricks SQL Databricks Runtime 10.4 LTS and above 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: 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

Related articles

• DESCRIBE CREDENTIAL
• DROP CREDENTIAL
• INFORMATION_SCHEMA.CREDENTIALS