DESCRIBE CREDENTIAL

  • Article

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

Returns the metadata of an existing credential. The metadata information includes credential name, comment, owner and other metadata.

Syntax

DESCRIBE [ STORAGE | SERVICE ] CREDENTIAL credential_name

Parameters

  • credential_name

    The name of an existing credential in the metastore. If the name does not exist, an exception is thrown.

Examples

> DESCRIBE STORAGE CREDENTIAL good_cred;
  name      owner  created_at               created_by   credential
  --------- ------ ------------------------ ------------ ---------------------------------------------
  good_cred admins 2022-01-01T08:00:00.0000 jane@doe.com AwsIamRole:arn:aws:iam:123456789012:roe/us....

> DESCRIBE SERVICE CREDENTIAL secrets;
  name      owner  created_at               created_by   credential
  --------- ------ ------------------------ ------------ ---------------------------------------------
  secrets   admins 2022-01-01T08:00:00.0000 jane@doe.com AwsIamRole:arn:aws:iam:123456789012:roe/us....

> DESCRIBE CREDENTIAL secrets;
  name      owner  created_at               created_by   credential
  --------- ------ ------------------------ ------------ ---------------------------------------------
  secrets   admins 2022-01-01T08:00:00.0000 jane@doe.com AwsIamRole:arn:aws:iam:123456789012:roe/us....