SHARES

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

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.

Examples 

> SELECT share_owner
    FROM information_schema.shares