CREDENTIALS

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