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. |