Redshift Observatory

System Table Tracker

System view pg_catalog.svv_mv_dependency version 1.0.58558 / 2023-10-25

schema	name	column	data type
pg_catalog	svv_mv_dependency	database_name	char(128)
pg_catalog	svv_mv_dependency	dependent_database_name	char(128)
pg_catalog	svv_mv_dependency	dependent_name	char(128)
pg_catalog	svv_mv_dependency	dependent_schema_name	char(128)
pg_catalog	svv_mv_dependency	name	char(128)
pg_catalog	svv_mv_dependency	schema_name	char(128)

View Text

SELECT s.db_name AS database_name,
       s.schema AS schema_name,
       s.name,
       s.ref_database_name AS dependent_database_name,
       s.ref_schema AS dependent_schema_name,
       s.ref_name AS dependent_name
FROM stv_mv_deps AS s

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