- Schema:
For guidance on query performance when using organization-wide usage views, see Performance (Organization Usage).
SHARES view¶
Important
This view is only available in the organization account. For more information, see Premium views in the organization account.
Organization Usage performance
When you query a specific view in the SNOWFLAKE.ORGANIZATION_USAGE schema, follow the organization-wide guidance in
Performance (Organization Usage): bound every scan on history views, list
columns explicitly, and use the time filter column table plus worked SQL and anti-patterns there.
This Organization Usage view returns the shares owned by the accounts in your organization, including dropped shares.
Each row in this view corresponds to a different share.
This view is available only in the organization account. Users with the GLOBALORGADMIN role, or users granted the SNOWFLAKE.ORGANIZATION_USAGE_VIEWER application role, can access it. For details, see Accessing the ORGANIZATION_USAGE schema.
Columns¶
Organization-level columns
| Column Name | Data Type | Description |
|---|---|---|
| ORGANIZATION_NAME | VARCHAR | Name of the organization. |
| ACCOUNT_LOCATOR | VARCHAR | System-generated identifier for the account. |
| ACCOUNT_NAME | VARCHAR | User-defined identifier for the account. |
Additional columns
| Column Name | Data Type | Description |
|---|---|---|
| CREATED_ON | TIMESTAMP_LTZ | The timestamp when the share was created. |
| MODIFIED_ON | TIMESTAMP_LTZ | The timestamp when the share was last updated. |
| DELETED_ON | TIMESTAMP_LTZ | The timestamp when the share was deleted. This value is NULL if the share hasn’t been deleted. |
| NAME | VARCHAR | The name of the share. |
| OWNER | VARCHAR | The name of the role that owns the share. |
| COMMENT | VARCHAR | Comment associated with the share, if any. |
| DATABASE_NAME | VARCHAR | The name of the primary database associated with the share. This field is empty if no database has been granted to the share. |
| SECURE_OBJECTS_ONLY | BOOLEAN | Indicates whether the share can only have secure objects granted to it. |
| TARGET_ACCOUNTS | VARCHAR | A comma-separated list of target accounts the share is shared with (outbound). This field is empty if the share has no target accounts. |
| LISTING_GLOBAL_NAME | VARCHAR | Global unique name of the listing associated with the share, if any. |
Usage notes¶
- Latency for the view may be up to 24 hours.