QuestionQ65

VerifiedPreparing and using data for analysis

You need to examine BigQuery data from a particular table several times per day. The underlying table being queried is several petabytes in size, but you need to filter the data and provide straightforward aggregations to downstream users. You want queries to run faster and to obtain up-to-date insights sooner. What should you do?

Explanation

BigQuery materialized views precompute and periodically cache query results, including filters and aggregations. They reduce repeated scanning of large base tables and use incremental base-table changes where possible to return up-to-date results with improved performance and efficiency.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!