Redshift Observatory

System Table Tracker

System view pg_catalog.stl_integration_table_state version 1.0.51986 / 2023-06-17

schema	name	column	data type
pg_catalog	stl_integration_table_state	current_state	char(128)
pg_catalog	stl_integration_table_state	database_name	char(128)
pg_catalog	stl_integration_table_state	integration_id	char(128)
pg_catalog	stl_integration_table_state	previous_state	char(128)
pg_catalog	stl_integration_table_state	reason	char(256)
pg_catalog	stl_integration_table_state	record_time	timestamp
pg_catalog	stl_integration_table_state	schema_name	char(128)
pg_catalog	stl_integration_table_state	synced_log_coordinate	char(128)
pg_catalog	stl_integration_table_state	table_name	char(128)

View Text

SELECT stll_integration_table_state.integration_id,
       stll_integration_table_state.database_name,
       stll_integration_table_state.schema_name,
       stll_integration_table_state.table_name,
       stll_integration_table_state.current_state,
       stll_integration_table_state.previous_state,
       stll_integration_table_state.record_time,
       stll_integration_table_state.synced_log_coordinate,
       stll_integration_table_state.reason
FROM stll_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