Skip to main content
The Refresh Materialized View orchestration component refreshes a selected materialized view, identifying changes to an underlying table in a database and applying those changes to the materialized view. In Amazon Redshift, materialized views are initially created with the Create View component. For an explanation of materialized views, read Creating materialized views in Amazon Redshift or Introduction to materialized views in Google BigQuery. 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. In Google BigQuery, refresh access is governed by IAM rather than view ownership. Any user assigned the bigquery.dataEditor, bigquery.dataOwner, or bigquery.admin role on the dataset can refresh a materialized view, regardless of who created it. For more information, read Required permissions.

​
Properties

​
Name
string
required
A human-readable name for the component.
​
Schema
drop-down
required
Select the table schema. The special value [Environment Default] uses the schema defined in the environment. For more information on using multiple schemas, read Schemas.
​
View name
drop-down
required
Select the materialized view to refresh. For more information, read Create Materialized View.