Refresh Materialized View
The Refresh Materialized View component refreshes a selected materialized view, identifying changes to an underlying table in a database and applying those changes to the materialized view.
New to materialized views in Amazon Redshift? 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.
Properties
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 more information on using multiple schemas, read Schemas.
View Name = drop-down
The materialized view to refresh. For more information, read Create Materialized View.
| Snowflake | Delta Lake on Databricks | Amazon Redshift | Google BigQuery | Azure Synapse Analytics |
|---|---|---|---|---|
| ❌ | ❌ | ✅ | ❌ | ❌ |