Redshift Observatory

System Table Tracker

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

schema	name	column	data type
pg_catalog	stl_integration_ddl	checkpoint	char(128)
pg_catalog	stl_integration_ddl	db_name	char(128)
pg_catalog	stl_integration_ddl	error_reason	char(256)
pg_catalog	stl_integration_ddl	event_code	char(128)
pg_catalog	stl_integration_ddl	event_type	char(128)
pg_catalog	stl_integration_ddl	integration_id	char(128)
pg_catalog	stl_integration_ddl	log_coordinate	char(128)
pg_catalog	stl_integration_ddl	record_time	timestamp
pg_catalog	stl_integration_ddl	schema_name	char(128)
pg_catalog	stl_integration_ddl	sequence	int4
pg_catalog	stl_integration_ddl	source_type	char(128)
pg_catalog	stl_integration_ddl	sql_query	char(1024)
pg_catalog	stl_integration_ddl	table_name	char(128)

View Text

SELECT stll_integration_ddl.record_time,
       stll_integration_ddl.integration_id,
       stll_integration_ddl.db_name,
       stll_integration_ddl.checkpoint,
       stll_integration_ddl.log_coordinate,
       stll_integration_ddl.source_type,
       stll_integration_ddl.event_type,
       stll_integration_ddl.sequence,
       stll_integration_ddl.sql_query,
       stll_integration_ddl.error_reason,
       stll_integration_ddl.schema_name,
       stll_integration_ddl.table_name,
       stll_integration_ddl.event_code
FROM stll_integration_ddl

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