- Schema:
SNOWPIPE_STREAMING_CHANNEL_HISTORY view¶
The channel history view provides a historical record of pipeline errors, enabling users to monitor performance trends. This view displays key metrics such as processed data volume, error rates, and latency.
You can use this Account Usage view to query the error history for a specific pipe or channel.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
ACCOUNT_ID |
INT |
The ID of the Snowflake account. |
CREATED_ON |
TIMESTAMP_LTZ |
Date and time when the rowset channel history was created. |
CHANNEL_ID |
INT |
The internal, system-generated ID of the Snowpipe Streaming channel. |
PIPE_ID |
INT |
The internal ID of the Snowpipe object associated with this Snowpipe Streaming channel. |
END_OFFSET |
STRING |
The last offset token processed and included in this specific channel history record. |
TABLE_ID |
INT |
The internal ID of the target table for this Snowpipe Streaming channel. |
TABLE_NAME |
STRING |
The name of the target table for this Snowpipe Streaming channel. |
TABLE_SCHEMA_ID |
INT |
The internal ID of the schema containing the target table. |
TABLE_SCHEMA_NAME |
STRING |
The name of the schema containing the target table. |
TABLE_DATABASE_ID |
INT |
The internal ID of the database containing the target table. |
TABLE_DATABASE_NAME |
STRING |
The name of the database containing the target table. |
PIPE_NAME |
STRING |
The user-defined name of the Snowpipe object associated with this Snowpipe Streaming channel. |
PIPE_SCHEMA_ID |
INT |
The internal ID of the schema containing the Snowpipe object. |
PIPE_SCHEMA_NAME |
STRING |
The name of the schema containing the Snowpipe object. |
PIPE_DATABASE_ID |
INT |
The internal ID of the database containing the Snowpipe object. |
PIPE_DATABASE_NAME |
STRING |
The name of the database containing the Snowpipe object. |
LAST_ERROR_OFFSET_UPPER_BOUND |
STRING |
The upper bound of the offset token range of the last rowset that encountered errors during this historical period. |
LAST_ERROR_MESSAGE |
STRING |
Displays NULL. |
SNOWFLAKE_PROCESSING_LATENCY_MS |
NUMBER |
The average latency, in milliseconds, observed by the Snowflake service in processing rowsets for this channel during this historical period. |
ROWS_INSERTED |
NUMBER |
The total number of rows successfully inserted through this channel during this historical period. |
ROWS_PARSED |
NUMBER |
The total number of rows parsed (processed) by the channel during this historical period. |
ROWS_ERROR_COUNT |
NUMBER |
The total number of rows that encountered errors and were not inserted through this channel during this historical period. |
Usage notes¶
The Snowpipe Streaming high-performance architecture only supports ON_ERROR=CONTINUE . Other ON_ERROR options are not supported.