PROVIDERS
Applies to: Databricks SQL Databricks Runtime 10.4 LTS and above
INFORMATION_SCHEMA.PROVIDERS describes providers.
Information is displayed only for providers the user has permission to interact with.
This is an extension to the SQL Standard Information Schema.
Definition
The PROVIDERS
relation contains the following columns:
Name | Data type | Nullable | Description |
---|---|---|---|
PROVIDER_NAME |
STRING |
No | Name of the provider. |
PROVIDER_OWNER |
STRING |
No | Owner of the provider. |
AUTHENTICATION_TYPE |
STRING |
No | Authentication type used with the provider. |
SHARE_CREDENTIALS_VERSION |
STRING |
Yes | File format version of the profile file used in Delta Sharing protocol. |
ENDPOINT |
STRING |
Yes | Endpoint of the Delta Sharing server. |
COMMENT |
STRING |
Yes | An optional comment that describes the provider. |
CLOUD |
STRING |
No | Cloud vendor of the provider. |
REGION |
STRING |
No | Region of the provider. |
DATA_PROVIDER_GLOBAL_METASTORE_ID |
STRING |
No | Globally unique metastore ID of the provider. |
CREATED |
TIMESTAMP |
No | Timestamp when the provider was created. |
CREATED_BY |
STRING |
No | Principal who created the provider. |
LAST_ALTERED |
TIMESTAMP |
No | Timestamp when the provider was last altered in any way. |
LAST_ALTERED_BY |
STRING |
No | Principal who last altered the provider. |
Constraints
The following constraints apply to the PROVIDERS
relation:
Class | Name | Column List | Description |
---|---|---|---|
Primary key | PROVIDERS_PK |
PROVIDER_NAME |
Unique identifier for the provider. |
Examples
> SELECT provider_owner
FROM information_schema.providers