Contents x
    Refresh Materialized View BQ
      • Dark
        Light
      Contents

      Refresh Materialized View BQ

        • Dark
          Light
        Article Summary

        This article is specific to the following platforms - BigQuery.

        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.

        Important Information

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


        BigQuery Properties

        PropertySettingDescription
        NameStringA human-readable name for the component.
        ProjectSelectSelect the Google BigQuery project. The special value, [Environment Default], will use the project defined in the environment.
        For more information, refer to the BigQuery documentation.
        DatasetSelectSelect the Google BigQuery dataset to load data into. The special value, [Environment Default], will use the dataset defined in the environment.
        For more information, refer to the BigQuery documentation.
        Materialized ViewSelectSelect 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 Creating and using materialized views.
        What's Next