Schema:

ACCOUNT_USAGE

SNOWPIPE_STREAMING_CLIENT_HISTORY View

This Account 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 your entire Snowflake account.

Columns

Column Name

Data Type

Description

CLIENT_NAME

TEXT

Name of the Snowpipe Streaming ingest client.

SNOWFLAKE_PROVIDED_ID

TEXT

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

TEXT

Type of the event.

BLOB_SIZE_BYTES

NUMBER

The blob size in bytes.

Usage Notes

  • Latency for the view may be up to 120 minutes (2 hours).

Examples

Query the amount of time spent loading data into Snowflake tables using Snowpipe Streaming within the last 365 days.

SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.SNOWPIPE_STREAMING_CLIENT_HISTORY;

The query returns the following results.

+----------------+----------------------------+------------------------------+--------------+----------------+
|    CLIENT_NAME |    SNOWFLAKE_PROVIDED_ID   |              EVENT_TIMESTAMP |   EVENT_TYPE | BLOB_SIZE_BYTES|
|----------------+--------------------------- +------------------------------+--------------|----------------|
|      MY_CLIENT |FE0B1xJrBAAL3bAAUz1M9876nMCd| 2023-02-04 02:07:34.000 +0000| BLOB_PERSIST |           1,648|
|      MY_CLIENT |D1CIBBPGGFyprBanMvAA1234V3ss| 2023-02-04 02:15:54.000 +0000| BLOB_PERSIST |           3,120|
+----------------+----------------------------+------------------------------+--------------+----------------+
Language: English