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;