Question

Your finance team uses a Looker dashboard backed by BigQuery that runs the same set of aggregation queries against a 400 GB partitioned sales table hundreds of times each morning. Executives complain that each dashboard tile takes 6-9 seconds to load, and on-demand query costs are climbing. You need sub-second dashboard response times with minimal changes to the existing SQL and no separate infrastructure to manage. What should you do?

Accepted Answer

Enable BigQuery BI Engine by creating a reservation in the project and let it cache and accelerate the recurring dashboard queries in memory.

Answer

Export the aggregated results to a Cloud SQL instance and repoint the Looker connection to Cloud SQL for faster reads.

Answer

Move the sales table to Bigtable and rewrite the dashboard queries to use row-key lookups for low latency.

Answer

Increase the BigQuery slot reservation for the project so the aggregation queries have more compute available.