PROVIDERS

Applies to: check marked yes Databricks SQL check marked yes 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