SHOW SHARES
Introduced or updated: v1.2.949
Data Sharing is an Enterprise Edition feature. Contact Databend Support for a license.
Shows the Shares of the current tenant (OUTBOUND) and the Shares that give access to the current tenant (INBOUND).
Syntax
SHOW SHARES [ LIKE '<pattern>' ] [ LIMIT <rows> ]
LIKE filters the Share names. WHERE is not supported.
Output
| Column | Description |
|---|---|
created_on | The time of creation. |
kind | OUTBOUND or INBOUND. |
owner_account | The provider tenant ID. |
name | The Share name. |
database_name | The name of the granted database. Empty if the Share does not grant a database. |
to | The consumer accounts. Empty for INBOUND Shares. |
owner | Not used. Always empty. |
comment | The comment. |
listing_global_name | Not used. Always empty. |
For the privileges, see Access Control.
Examples
SHOW SHARES;
SHOW SHARES LIKE 'sales%' LIMIT 10;