Member-only story
BigQuery Materialized Views without Aggregation
New Google Feature is now generally available
If you rely on faster results the following update might be interesting for you, because now Google BigQuery allows materialized views without aggregation.
What are materialized Views and why using them?
In BigQuery materialized views are pre-computed views that cache the results of a query periodically. You can use that feature to improve performance and efficiency. BigQuery uses pre-computed results from materialized views and, when possible, reads only delta changes from the base table to compute actual results. Materialized views can be queried directly or used by BigQuery Optimization to process queries to the base tables.
Queries that use materialized views are typically faster and consume fewer resources than queries that retrieve the same data exclusively from the base table. Materialized views can significantly improve the performance of workloads that have frequent and repetitive queries [1].
How to create a Materialized View
Creating a materialized view is actually quite simple — you can use the following statement as a blueprint [2]:
CREATE MATERIALIZED VIEW…
