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