Redshift Observatory System Table Tracker

Tables

pg_catalog.stcs_loaderror_detail_redacted

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
slice	int4			NN
session	int4			NN
query	int4			NN
filename	char(256)			NN
line_number	int8			NN
field	int4			NN
colname	char(1024)			NN
value_redacted	char(1024)			NN
is_null	int4			NN
type	char(10)			NN
col_length	char(10)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_load_errors_redacted

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
slice	int4			NN
tbl	int4			NN
starttime	int8			NN
session	int4			NN
query	int4			NN
filename	char(256)			NN
line_number	int8			NN
colname	char(127)			NN
type	char(10)			NN
col_length	char(10)			NN
position	int4			NN
raw_line_redacted	char(1024)			NN
raw_field_value_redacted	char(1024)			NN
err_code	int4			NN
err_reason	char(100)			NN
is_partial	int4			NN
start_offset	int8			NN
copy_job_id	int8			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stcs_replacements_redacted

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
slice	int4			NN
tbl	int4			NN
starttime	int8			NN
session	int4			NN
query	int4			NN
filename	char(256)			NN
line_number	int8			NN
colname	char(127)			NN
raw_line_redacted	char(1024)			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

pg_catalog.stll_loaderror_detail_redacted

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
slice	int4			NN
session	int4			NN
query	int4			NN
filename	char(256)			NN
line_number	int8			NN
field	int4			NN
colname	char(1024)			NN
value_redacted	char(1024)			NN
is_null	int4			NN
type	char(10)			NN
col_length	char(10)			NN

pg_catalog.stll_load_errors_redacted

old
column	data type	PK	U	NN

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

pg_catalog.stll_replacements_redacted

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
userid	int4			NN
slice	int4			NN
tbl	int4			NN
starttime	timestamp			NN
session	int4			NN
query	int4			NN
filename	char(256)			NN
line_number	int8			NN
colname	char(127)			NN
raw_line_redacted	char(1024)			NN

pg_internal.redshift_auto_health_check_7092392

old
column	data type	PK	U	NN

new
column	data type	PK	U	NN
deletexid	int8			NN
insertxid	int8			NN
oid	oid			NN
a	int4

pg_internal.redshift_auto_health_check_7003461

old
column	data type	PK	U	NN
deletexid	int8			NN
insertxid	int8			NN
oid	oid			NN
a	int4

new
column	data type	PK	U	NN

Views

pg_catalog.stl_loaderror_detail_redacted

old
column	data type

new
column	data type
userid	int4
slice	int4
session	int4
query	int4
filename	char(256)
line_number	int8
field	int4
colname	char(1024)
value_redacted	char(1024)
is_null	int4
type	char(10)
col_length	char(10)

pg_catalog.stl_load_errors_redacted

old
column	data type

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

pg_catalog.stl_replacements_redacted

old
column	data type

new
column	data type
userid	int4
slice	int4
tbl	int4
starttime	timestamp
session	int4
query	int4
filename	char(256)
line_number	int8
colname	char(127)
raw_line_redacted	char(1024)