Redshift Research Project

System Table Tracker

System view pg_catalog.svl_stream_scan_errors version 1.0.43551 / 2022-11-08

View Text

SELECT stl_kinesis_scan_errors.query,
       stl_kinesis_scan_errors.pid,
       stl_kinesis_scan_errors.timestamp_type,
       stl_kinesis_scan_errors.arrival_time AS stream_timestamp,
       stl_kinesis_scan_errors.record_time,
       stl_kinesis_scan_errors.mv_name,
       stl_kinesis_scan_errors.schema_name,
       stl_kinesis_scan_errors.stream_name,
       stl_kinesis_scan_errors.shard_id AS partition_id,
       stl_kinesis_scan_errors.seq_num AS position,
       stl_kinesis_scan_errors.err_code,
       stl_kinesis_scan_errors.err_reason,
       stl_kinesis_scan_errors.raw_data
FROM stl_kinesis_scan_errors

UNION ALL

SELECT stl_kafka_scan_errors.query,
       stl_kafka_scan_errors.pid,
       stl_kafka_scan_errors.timestamp_type,
       stl_kafka_scan_errors.kafka_timestamp AS stream_timestamp,
       stl_kafka_scan_errors.record_time,
       stl_kafka_scan_errors.mv_name,
       stl_kafka_scan_errors.schema_name,
       stl_kafka_scan_errors.topic_name AS stream_name,
       CAST(stl_kafka_scan_errors.partition_id AS varchar(128)) AS partition_id,
       CAST(stl_kafka_scan_errors.record_offset AS varchar(128)) AS position,
       stl_kafka_scan_errors.err_code,
       stl_kafka_scan_errors.err_reason,
       stl_kafka_scan_errors.raw_data
FROM stl_kafka_scan_errors

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers