SHOW CREDENTIALS

Applies to: check marked yes 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