Google launches the Materialized Recommender
How to Query Time and Costs with the new Query Analyzer
Published in
2 min readApr 12, 2024
For every Data Engineer and Scientist less query execution time while also cutting costs sounds awesome — this is what Google has now launched as an ready to use service in BigQuery.
Just a few weeks ago, Google has also launched a similar feature, called History based Optimization for Queries, also with the goal to optimize query execution:
Now, Google is also presenting the BigQuery materialized view recommender which analyzes your past query jobs to identify opportunities to apply materialized views to your queries for potential cost savings. You can view all available materialized view recommendations through the BigQuery UI or Recommender API[1].
