CATALOG_PROVIDER_SHARE_USAGE

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 10.4 LTS and above

INFORMATION_SCHEMA.CATALOG_PROVIDER_SHARE_USAGE lists catalogs that have mounted provider shares.

Information is displayed only for catalogs the user has permission to interact with.

This is an extension to the SQL Standard Information Schema.

Definition

The CATALOG_PROVIDER_SHARE_USAGE relation contains the following columns:

Name

Data type

Nullable

Description

CATALOG_NAME

STRING

No

Catalog that has mounted the share.

PROVIDER_NAME

STRING

No

Provider that shared the share.

SHARE_NAME

STRING

No

Name of the share.

Constraints

The following constraints apply to the CATALOG_PROVIDER_SHARE_USAGE relation:

Class

Name

Column List

Description

Primary key

CATALOG_PROVIDER_SHARE_USAGE_PK

CATALOG_NAME, PROVIDER_NAME, SHARE_NAME

Unique identifier for the catalog provider share usage.

Foreign key

CATALOG_PROVIDER_SHARE_USAGE_CATALOGS_FK

CATALOG_NAME

References CATALOGS

Foreign key

CATALOG_PROVIDER_SHARE_USAGE_PROVIDERS_FK

PROVIDER_NAME

References PROVIDERS

Examples 

> SELECT catalog_name, provider_name, share_name
    FROM information_schema.catalog_provider_share_usage;