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. |
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