Redshift Observatory

System Table Tracker

System view pg_catalog.stl_load_errors_redacted version 1.0.106980 / 2025-02-06

schema	name	column	data type
pg_catalog	stl_load_errors_redacted	col_length	char(10)
pg_catalog	stl_load_errors_redacted	colname	char(127)
pg_catalog	stl_load_errors_redacted	copy_job_id	int8
pg_catalog	stl_load_errors_redacted	err_code	int4
pg_catalog	stl_load_errors_redacted	err_reason	char(100)
pg_catalog	stl_load_errors_redacted	filename	char(256)
pg_catalog	stl_load_errors_redacted	is_partial	int4
pg_catalog	stl_load_errors_redacted	line_number	int8
pg_catalog	stl_load_errors_redacted	position	int4
pg_catalog	stl_load_errors_redacted	query	int4
pg_catalog	stl_load_errors_redacted	raw_field_value_redacted	char(1024)
pg_catalog	stl_load_errors_redacted	raw_line_redacted	char(1024)
pg_catalog	stl_load_errors_redacted	session	int4
pg_catalog	stl_load_errors_redacted	slice	int4
pg_catalog	stl_load_errors_redacted	start_offset	int8
pg_catalog	stl_load_errors_redacted	starttime	timestamp
pg_catalog	stl_load_errors_redacted	tbl	int4
pg_catalog	stl_load_errors_redacted	type	char(10)
pg_catalog	stl_load_errors_redacted	userid	int4

View Text

SELECT stll_load_errors_redacted.userid,
       stll_load_errors_redacted.slice,
       stll_load_errors_redacted.tbl,
       stll_load_errors_redacted.starttime,
       stll_load_errors_redacted.session,
       stll_load_errors_redacted.query,
       stll_load_errors_redacted.filename,
       stll_load_errors_redacted.line_number,
       stll_load_errors_redacted.colname,
       stll_load_errors_redacted.type,
       stll_load_errors_redacted.col_length,
       stll_load_errors_redacted.position,
       stll_load_errors_redacted.raw_line_redacted,
       stll_load_errors_redacted.raw_field_value_redacted,
       stll_load_errors_redacted.err_code,
       stll_load_errors_redacted.err_reason,
       stll_load_errors_redacted.is_partial,
       stll_load_errors_redacted.start_offset,
       stll_load_errors_redacted.copy_job_id
FROM stll_load_errors_redacted

Home 3D Друк Blog Bring-Up Times Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace Slack System Table Tracker The Known Universe White Papers