Redshift Observatory

System Table Tracker

System view pg_catalog.svv_integration version 1.0.77028 / 2024-10-24

schema name column data type
pg_catalog svv_integration creation_time timestamp
pg_catalog svv_integration current_lag int8
pg_catalog svv_integration integration_id char(128)
pg_catalog svv_integration last_replicated_checkpoint char(128)
pg_catalog svv_integration refresh_interval int4
pg_catalog svv_integration source char(128)
pg_catalog svv_integration source_database char(128)
pg_catalog svv_integration state char(128)
pg_catalog svv_integration target_database char(128)
pg_catalog svv_integration total_tables_failed int4
pg_catalog svv_integration total_tables_replicated int4

View Text

SELECT stv_integration.integration_id,
       stv_integration.database_name AS target_database,
       stv_integration.integration_type AS source,
       stv_integration.state,
       stv_integration.lag_ms AS current_lag,
       stv_integration.synced_log_coordinate AS last_replicated_checkpoint,
       stv_integration.total_tables_replicated,
       stv_integration.total_tables_failed,
       stv_integration.creation_time,
       stv_integration.refresh_interval,
       stv_integration.source_database
FROM stv_integration


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