OWNED_SHARES view
The MD_INFORMATION_SCHEMA.OWNED_SHARES view provides information about the shares that the current user created.
Schema
When you query the MD_INFORMATION_SCHEMA.OWNED_SHARES view, the query results contain one row for each share that the current user created.
The MD_INFORMATION_SCHEMA.OWNED_SHARES view has the following schema:
| Column Name | Data Type | Value |
|---|---|---|
| NAME | STRING | The name of the share |
| URL | STRING | The share_url which can be used to attach the share |
| SOURCE_DB_NAME | STRING | The name of the database where this share was created from |
| SOURCE_DB_UUID | UUID | UUID of the database where this share was created from |
| ACCESS | STRING | Whether anyone (referred to as UNRESTRICTED) or only organization members (referred to as ORGANIZATION) can attach to the share by its share_url |
| VISIBILITY | STRING | Whether the share is DISCOVERABLE or HIDDEN |
| UPDATE | STRING | The share’s update mode (MANUAL vs. AUTOMATIC) |
| CREATED_TS | TIMESTAMP | The share’s creation time |
Example usage
from MD_INFORMATION_SCHEMA.OWNED_SHARES;
select name, url, created_ts from MD_INFORMATION_SCHEMA.OWNED_SHARES;
| name | url | source_db_name |
|---|---|---|
| my_share | md:_share/my_share/2ef6b580-2445-4f4f-bce8-c13a85812464 | db1 |