Redshift Observatory System Table Tracker

Tables

pg_internal.redshift_auto_health_check_8158384

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

old
column	data type	PK	U	NN
record_time	int8			NN
integration_id	char(128)			NN
database_name	char(128)			NN
checkpoint	char(128)			NN
source_type	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
status	int4			NN
synced_log_coordinate	char(128)			NN
src_inserts	int8			NN
src_deletes	int8			NN
src_updates	int8			NN
inserts	int8			NN
inserts_dt	int8			NN
parsed_rows	int8			NN
skipped_rows	int8			NN
is_bursted	int4			NN
bytes_ingested	int8			NN
updated_rows	int8			NN
validation_status	int4			NN
xid	int8			NN
replication_mode	int4			NN
__path	varchar(2050)			NN
__size	int8			NN
__spectrum_oid	varchar(128)			NN
__log_generated_date	char(8)			NN
__cluster_type	char(4)			NN

new
column	data type	PK	U	NN
record_time	int8			NN
integration_id	char(128)			NN
database_name	char(128)			NN
checkpoint	char(128)			NN
source_type	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
status	int4			NN
synced_log_coordinate	char(128)			NN
src_inserts	int8			NN
src_deletes	int8			NN
src_updates	int8			NN
inserts	int8			NN
inserts_dt	int8			NN
parsed_rows	int8			NN
skipped_rows	int8			NN
is_bursted	int4			NN
bytes_ingested	int8			NN
updated_rows	int8			NN
validation_status	int4			NN
xid	int8			NN
replication_mode	int4			NN
filter_status	int4			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_integration_cdc_detail

old
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
database_name	char(128)			NN
checkpoint	char(128)			NN
source_type	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
status	int4			NN
synced_log_coordinate	char(128)			NN
src_inserts	int8			NN
src_deletes	int8			NN
src_updates	int8			NN
inserts	int8			NN
inserts_dt	int8			NN
parsed_rows	int8			NN
skipped_rows	int8			NN
is_bursted	int4			NN
bytes_ingested	int8			NN
updated_rows	int8			NN
validation_status	int4			NN
xid	int8			NN
replication_mode	int4			NN

new
column	data type	PK	U	NN
record_time	timestamp			NN
integration_id	char(128)			NN
database_name	char(128)			NN
checkpoint	char(128)			NN
source_type	char(128)			NN
schema_name	char(128)			NN
table_name	char(128)			NN
status	int4			NN
synced_log_coordinate	char(128)			NN
src_inserts	int8			NN
src_deletes	int8			NN
src_updates	int8			NN
inserts	int8			NN
inserts_dt	int8			NN
parsed_rows	int8			NN
skipped_rows	int8			NN
is_bursted	int4			NN
bytes_ingested	int8			NN
updated_rows	int8			NN
validation_status	int4			NN
xid	int8			NN
replication_mode	int4			NN
filter_status	int4			NN

pg_internal.redshift_auto_health_check_8118012

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_integration_cdc_detail

old
column	data type
record_time	timestamp
integration_id	char(128)
database_name	char(128)
checkpoint	char(128)
source_type	char(128)
schema_name	char(128)
table_name	char(128)
status	int4
synced_log_coordinate	char(128)
src_inserts	int8
src_deletes	int8
src_updates	int8
inserts	int8
inserts_dt	int8
parsed_rows	int8
skipped_rows	int8
is_bursted	int4
bytes_ingested	int8
updated_rows	int8
validation_status	int4
xid	int8
replication_mode	int4

new
column	data type
record_time	timestamp
integration_id	char(128)
database_name	char(128)
checkpoint	char(128)
source_type	char(128)
schema_name	char(128)
table_name	char(128)
status	int4
synced_log_coordinate	char(128)
src_inserts	int8
src_deletes	int8
src_updates	int8
inserts	int8
inserts_dt	int8
parsed_rows	int8
skipped_rows	int8
is_bursted	int4
bytes_ingested	int8
updated_rows	int8
validation_status	int4
xid	int8
replication_mode	int4
filter_status	int4