Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

STV_MV_DEPS - Amazon Redshift

STV_MV_DEPS

The STV_MV_DEPS table shows the dependencies of materialized views on other materialized views within Amazon Redshift.

For more information about materialized views, see Materialized views in Amazon Redshift.

STV_MV_DEPS is visible to all users. Superusers can see all rows; regular users can only list materialized views residing in schemas they have access to. For more information, see Visibility of data insystem tables and views.

Table columns

Column name Data type Description
db_name char(128) The database that contains the specified materialized view.
schema char(128) The schema of the materialized view.
name char(128) The name of the materialized view.
ref_schema char(128) The materialized view schema on which this materialized view depends.
ref_name char(128) The name of the materialized view on which this materialized view depends.
ref_database_name char(128) The name of the database on which this materialized view depends.

Sample query

The following query returns an output row that indicates that the materialized view mv_over_foo uses the materialized view mv_foo in its definition as a dependency.

CREATE SCHEMA test_ivm_setup; CREATE TABLE test_ivm_setup.foo(a INT); CREATE MATERIALIZED VIEW test_ivm_setup.mv_foo AS SELECT * FROM test_ivm_setup.foo; CREATE MATERIALIZED VIEW test_ivm_setup.mv_over_foo AS SELECT * FROM test_ivm_setup.mv_foo; SELECT * FROM stv_mv_deps; db_name | schema | name | ref_schema | ref_name | ref_database_name ---------+-----------------+-------------+----------------+----------+------------------ dev | test_ivm_setup | mv_over_foo | test_ivm_setup | mv_foo | dev
PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.