STORAGE_CREDENTIALS

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

INFORMATION_SCHEMA.STORAGE_CREDENTIALS describes storage credentials.

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

This is an extension to the SQL Standard Information Schema.

Definition

The STORAGE_CREDENTIALS relation contains the following columns:

Name

Data type

Nullable

Description

STORAGE_CREDENTIAL_ID

STRING

No

ID of the storage credential.

STORAGE_CREDENTIAL_NAME

STRING

No

Name of the storage credential.

STORAGE_CREDENTIAL_OWNER

STRING

No

Owner of the storage credential.

CREDENTIAL_TYPE

STRING

No

Type of the storage credential.

CREDENTIAL

STRING

No

Redacted storage credential.

USED_FOR_MANAGED_STORAGE

STRING

No

Whether this storage credential is used as the root credential of the metastore.

COMMENT

STRING

Yes

An optional comment that describes the storage credential.

CREATED

TIMESTAMP

No

Timestamp when the storage credential was created.

CREATED_BY

STRING

No

Principal who created the storage credential.

LAST_ALTERED

TIMESTAMP

No

Timestamp when the storage credential was last altered in any way.

LAST_ALTERED_BY

STRING

No

Principal who last altered the storage credential.

Constraints

The following constraints apply to the STORAGE_CREDENTIALS relation:

Class

Name

Column List

Description

Primary key

STORAGE_CREDENTIALS_PK

STORAGE_CREDENTIAL_ID, STORAGE_CREDENTIAL_NAME

Unique identifier for the storage credential.

Examples 

> SELECT storage_credential_owner
    FROM information_schema.storage_credentials