Redshift Observatory

System Table Tracker

System view pg_catalog.stl_integration_cdc_detail version 1.0.72982 / 2024-08-17

schema name column data type
pg_catalog stl_integration_cdc_detail bytes_ingested int8
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)
pg_catalog stl_integration_cdc_detail updated_rows int8
pg_catalog stl_integration_cdc_detail validation_status int4
pg_catalog stl_integration_cdc_detail xid int8

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,
       stll_integration_cdc_detail.bytes_ingested,
       stll_integration_cdc_detail.updated_rows,
       stll_integration_cdc_detail.validation_status,
       stll_integration_cdc_detail.xid
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