- Schema:
For guidance on query performance when using organization-wide usage views, see Performance (Organization Usage).
SNOWPIPE_
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 can be used to query the amount of time spent loading data into Snowflake tables using Snowpipe Streaming within the last 365 days (1 year). The view displays the amount of data loaded and timestamp of the Snowpipe Streaming client calls for accounts in your organization.
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 |
|---|---|---|
| CLIENT_NAME | VARCHAR | Name of the Snowpipe Streaming ingest client. |
| SNOWFLAKE_PROVIDED_ID | VARCHAR | Internal/system-generated identifier for the Snowpipe Streaming ingest client used for the data load. |
| EVENT_TIMESTAMP | TIMESTAMP_LTZ | Start of the time (in the local time zone) range in which data loading took place. |
| EVENT_TYPE | VARCHAR | Type of the event. |
| BLOB_SIZE_BYTES | NUMBER | The blob size in bytes. |
Usage notes¶
- Latency for the view may be up to 240 minutes (4 hours).