Redshift Observatory

System Table Tracker

System view pg_catalog.svv_integration version 1.0.45698 / 2023-01-27

schema	name	column	data type
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	source	char(128)
pg_catalog	svv_integration	state	char(128)
pg_catalog	svv_integration	target_database	char(128)

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
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