SYS_STREAM_SCAN_ERRORS - Amazon Redshift

SYS_STREAM_SCAN_ERRORS

Records errors for records loaded via streaming ingestion.

SYS_STREAM_SCAN_ERRORS is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of data in system tables and views.

Table columns

Column name Data type Description
external_schema_name character(128) The name of the Kinesis stream or Amazon MSK topic's schema. It is case sensitive.
stream_name character(255) The name of the stream or topic. It is case sensitive.
mv_name character(128) The name of the associated materialized view. Empty if none. It is case sensitive.
transaction_id bigint The transaction ID.
query_id bigint The query ID.
stream_timestamp_type character(1) The type of the stream timestamp. It is case sensitive.
stream_timestamp timestamp without time zone The time when the record arrived.
record_time timestamp without time zone The time when the error message was logged.
partition_id character(128) The partition/shard id. It is case sensitive.
position character(128) The position of the record. This corresponds with the sequence number in Kinesis or the offset in Amazon MSK. It is case sensitive.
error_code integer The error code.
error_reason character(128) The error reason. It is case sensitive.