STORAGE_CREDENTIALS

  • Article

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.

Warning

Starting with Databricks Runtime 15.4, this relation is deprecated. Use INFORMATION_SCHEMA.CREDENTIALS instead.

Note also that during the service credentials preview, INFORMATION_SCHEMA.STORAGE_CREDENTIALS displays both storage credentials and service credentials. This is incorrect preview behavior that will be corrected, and you should not depend on it to continue.

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