Refresh Materialized View RS
- DarkLight
Refresh Materialized View RS
- DarkLight
Article Summary
Share feedback
Thanks for sharing your feedback!
This article is specific to the following platforms - Redshift.
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
Redshift Properties | ||
|---|---|---|
| Property | Setting | Description |
| Name | String | A human-readable name for the component. |
| Schema | Select | Select the Redshift schema. The special value, [Environment Default], will use the schema defined in the environment. For more information, see the Schema documentation. |
| View Name | Select | Select the materialized view. Each materialized view has an "owner"—namely, whichever database user creates a given view. Users can only select and refresh views that they created. For more information, read Create Materialized View. |