Professional Data Engineer

By Google · Question Mode

QuestionQ8

Preparing and using data for analysis

You currently use a SQL-based tool to visualize data stored in BigQuery. The data visualizations require outer joins and analytic functions. Visualizations must be based on data that is at least 4 hours old. Business users report that the visualizations take too long to generate. You want to improve the visualization-query performance while minimizing maintenance overhead for the data-preparation pipeline. What should you do?

Explanation

A non-incremental BigQuery materialized view supports outer joins and analytic functions when allow_non_incremental_definition is enabled. Its max_staleness setting can permit results up to four hours old, so visualization queries can use precomputed data for lower latency. Enabling refresh maintains the materialized view automatically, avoiding a separately managed export pipeline.

Learn more

Community Discussion

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