Skip to content

Refresh Materialized View

The Refresh Materialized View orchestration component refreshes a selected Redshift materialized view, identifying changes to an underlying table in a database and applying those changes to the materialized view.

Materialized views are initially created with the Create View component.

For an explanation of materialized views, read Creating materialized views in Amazon Redshift.

Each materialized view has an "owner"—namely, whichever database user creates a given view. Users can only refresh views that they created.


Name = string

A human-readable name for the component.

Schema = drop-down

Select the table schema. The special value, [Environment Default], will use the schema defined in the environment. For information about using multiple schemas, read Schemas.

View Name = drop-down

Select the materialized view to refresh. For more information, read Create Materialized View.

Snowflake Databricks Amazon Redshift