Redshift Observatory

System Table Tracker

System view pg_catalog.svv_mv_dependency version 1.0.52931 / 2023-07-07

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