STORAGE_CREDENTIALS
Applies to: Databricks SQL 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