CATALOG_PROVIDER_SHARE_USAGE
Applies to: 
Databricks SQL 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
SQL
> SELECT catalog_name, provider_name, share_name
FROM information_schema.catalog_provider_share_usage;