Redshift Observatory

System Table Tracker

System view pg_catalog.svv_integration_table_state version 1.0.56242 / 2023-09-15

schema name column data type
pg_catalog svv_integration_table_state integration_id char(128)
pg_catalog svv_integration_table_state last_updated_timestamp timestamp
pg_catalog svv_integration_table_state reason char(256)
pg_catalog svv_integration_table_state schema_name char(128)
pg_catalog svv_integration_table_state table_last_replicated_checkpoint char(128)
pg_catalog svv_integration_table_state table_name char(128)
pg_catalog svv_integration_table_state table_state char(128)
pg_catalog svv_integration_table_state target_database char(128)

View Text

SELECT stv_integration_table_state.integration_id,
       stv_integration_table_state.database_name AS target_database,
       stv_integration_table_state.schema_name,
       stv_integration_table_state.table_name,
       stv_integration_table_state.state AS table_state,
       stv_integration_table_state.synced_log_coordinate AS table_last_replicated_checkpoint,
       stv_integration_table_state.reason,
       stv_integration_table_state.last_updated AS last_updated_timestamp
FROM stv_integration_table_state


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