Redshift Research Project

System Table Tracker

System view pg_catalog.stl_integration_cdc_detail version 1.0.63269 / 2024-02-17

schema	name	column	data type
pg_catalog	stl_integration_cdc_detail	checkpoint	char(128)
pg_catalog	stl_integration_cdc_detail	database_name	char(128)
pg_catalog	stl_integration_cdc_detail	inserts	int8
pg_catalog	stl_integration_cdc_detail	inserts_dt	int8
pg_catalog	stl_integration_cdc_detail	integration_id	char(128)
pg_catalog	stl_integration_cdc_detail	is_bursted	int4
pg_catalog	stl_integration_cdc_detail	parsed_rows	int8
pg_catalog	stl_integration_cdc_detail	record_time	timestamp
pg_catalog	stl_integration_cdc_detail	schema_name	char(128)
pg_catalog	stl_integration_cdc_detail	skipped_rows	int8
pg_catalog	stl_integration_cdc_detail	source_type	char(128)
pg_catalog	stl_integration_cdc_detail	src_deletes	int8
pg_catalog	stl_integration_cdc_detail	src_inserts	int8
pg_catalog	stl_integration_cdc_detail	src_updates	int8
pg_catalog	stl_integration_cdc_detail	status	int4
pg_catalog	stl_integration_cdc_detail	synced_log_coordinate	char(128)
pg_catalog	stl_integration_cdc_detail	table_name	char(128)

View Text

SELECT stll_integration_cdc_detail.record_time,
       stll_integration_cdc_detail.integration_id,
       stll_integration_cdc_detail.database_name,
       stll_integration_cdc_detail.checkpoint,
       stll_integration_cdc_detail.source_type,
       stll_integration_cdc_detail.schema_name,
       stll_integration_cdc_detail.table_name,
       stll_integration_cdc_detail.status,
       stll_integration_cdc_detail.synced_log_coordinate,
       stll_integration_cdc_detail.src_inserts,
       stll_integration_cdc_detail.src_deletes,
       stll_integration_cdc_detail.src_updates,
       stll_integration_cdc_detail.inserts,
       stll_integration_cdc_detail.inserts_dt,
       stll_integration_cdc_detail.parsed_rows,
       stll_integration_cdc_detail.skipped_rows,
       stll_integration_cdc_detail.is_bursted
FROM stll_integration_cdc_detail

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