CREDENTIALS

Applies to: Databricks Runtime 15.4 and above

INFORMATION_SCHEMA.CREDENTIALS describes credentials.

Information is displayed only for credentials the user has permission to interact with.

This is an extension to the SQL Standard Information Schema.

Definition

The CREDENTIALS relation contains the following columns:

Name	Data type	Nullable	Description
CREDENTIAL_ID	STRING	No	ID of the credential.
CREDENTIAL_NAME	STRING	No	Name of the credential.
CREDENTIAL_OWNER	STRING	No	Owner of the credential.
CREDENTIAL_PURPOSE	STRING	No	Purpose of the credential (‘STORAGE’ or ‘SERVICE’)
CREDENTIAL_TYPE	STRING	No	Type of the credential.
CREDENTIAL	STRING	No	Redacted credential.
USED_FOR_MANAGED_STORAGE	STRING	No	Whether this credential is used as the root credential of the metastore.
COMMENT	STRING	Yes	An optional comment that describes the credential.
CREATED	TIMESTAMP	No	Timestamp when the credential was created.
CREATED_BY	STRING	No	Principal who created the credential.
LAST_ALTERED	TIMESTAMP	No	Timestamp when the credential was last altered in any way.
LAST_ALTERED_BY	STRING	No	Principal who last altered the credential.

Constraints

The following constraints apply to the CREDENTIALS relation:

Class	Name	Column list	Description
Primary key	CREDENTIALS_PK	CREDENTIAL_ID, CREDENTIAL_NAME	Unique identifier for the credential.

Examples

> SELECT credential_owner
    FROM information_schema.credentials

Related

• DESCRIBE CREDENTIAL

• Information schema

• INFORMATION_SCHEMA.CREDENTIAL_PRIVILEGES

• SHOW CREDENTIALS