Share via

TABLE_SHARE_USAGE

  • Article

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 10.4 LTS 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

SQL 
> SELECT share_name, catalog_name, schema_name, table_name
    FROM information_schema.table_share_usage;