TABLE_SHARE_USAGE
Applies to: 
Databricks SQL Databricks Runtime 10.2 and above
INFORMATION_SCHEMA.TABLE_SHARE_USAGE lists tables which belong to shares.
Information is displayed only for shares the user has permission to interact with.
This is an extension to the SQL Standard Information Schema.
Definition
The TABLE_SHARE_USAGE relation contains the following columns:
| Name | Data type | Nullable | Description |
|---|---|---|---|
CATALOG_NAME |
STRING |
No | Catalog of the table in the share. |
SCHEMA_NAME |
STRING |
No | Schema of the table in the share. |
TABLE_NAME |
STRING |
No | Table in the share. |
SHARE_NAME |
STRING |
No | Name of the share. |
PARTITION_SPEC |
STRING |
Yes | Partition filtering specification for the shared table. |
CDF_ENABLED |
STRING |
No | Whether CDF is enabled on the shared table. |
START_VERSION |
LONG |
No | The start version associated with the shared table. |
SHARED_AS_SCHEMA |
STRING |
No | Alias of the shared schema. |
SHARED_AS_TABLE |
STRING |
No | Alias of the shared table. |
COMMENT |
STRING |
Yes | An optional comment that describes the table share usage. |
Constraints
The following constraints apply to the TABLE_SHARE_USAGE relation:
| Class | Name | Column List | Description |
|---|---|---|---|
| Primary key | TABLE_SHARE_USAGE_PK |
SHARE_NAME, SHARED_AS_SCHEMA, SHARED_AS_TABLE |
Unique identifier for the table share usage. |
| Foreign key | TABLE_SHARE_USAGE_TABLES_FK |
CATALOG_NAME, SCHEMA_NAME, TABLE_NAME |
References TABLES |
| Foreign key | TABLE_SHARE_USAGE_SHARES_FK |
SHARE_NAME |
References SHARES |
Examples
> SELECT share_name, catalog_name, schema_name, table_name
FROM information_schema.table_share_usage;