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