SHARES

Applies to: Databricks SQL Databricks Runtime 10.4 LTS and above

INFORMATION_SCHEMA.SHARES describes 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 SHARES relation contains the following columns:

Name	Data type	Nullable	Description
SHARE_NAME	STRING	No	Name of the share.
SHARE_OWNER	STRING	No	Owner of the share.
COMMENT	STRING	Yes	An optional comment that describes the share.
CREATED	TIMESTAMP	No	Timestamp when the share was created.
CREATED_BY	STRING	No	Principal who created the share.
LAST_ALTERED	TIMESTAMP	No	Timestamp when the share was last altered in any way.
LAST_ALTERED_BY	STRING	No	Principal who last altered the share.

Name	Data type	Nullable	Description
SHARE_NAME	STRING	No	Name of the share.
SHARE_OWNER	STRING	No	Owner of the share.
COMMENT	STRING	Yes	An optional comment that describes the share.
CREATED	TIMESTAMP	No	Timestamp when the share was created.
CREATED_BY	STRING	No	Principal who created the share.
LAST_ALTERED	TIMESTAMP	No	Timestamp when the share was last altered in any way.
LAST_ALTERED_BY	STRING	No	Principal who last altered the share.

Constraints

The following constraints apply to the SHARES relation:

Class	Name	Column List	Description
Primary key	SHARES_PK	SHARE_NAME	Unique identifier for the share.

Class	Name	Column List	Description
Primary key	SHARES_PK	SHARE_NAME	Unique identifier for the share.

Examples

SQL

> SELECT share_owner
    FROM information_schema.shares

Related

• DESCRIBE SHARE
• Information schema
• INFORMATION_SCHEMA.SHARE_RECIPIENT_PRIVILEGES
• SHOW SHARES