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 Google BigQuery? Read Introduction to materialized views.

---

Properties

Name = string

A human-readable name for the component.

---

Project = drop-down

Select the Google Cloud project. The special value [Environment Default] uses the project defined in the environment. For more information, read Creating and managing projects.

---

Dataset = drop-down

Select the Google BigQuery dataset to load data into. The special value [Environment Default] uses the dataset defined in the environment. For more information, read Introduction to datasets.

---

Materialized View = drop-down

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. To learn more, read Creating and using materialized views.

---

Snowflake	Delta Lake on Databricks	Amazon Redshift	Google BigQuery	Azure Synapse Analytics
❌	❌	❌	✅	❌