Question

A finance team wants to analyze a 400 GB BigQuery sales table directly in Google Sheets. Business users need to build pivot tables that always reflect the previous day's loaded data each morning, without writing SQL and without downloading the full dataset into the spreadsheet. What is the most appropriate way to configure this?

Accepted Answer

Use Connected Sheets to link the BigQuery table, build pivot tables against the live connection, and configure a scheduled daily refresh.

Answer

Export the BigQuery table to CSV nightly via a scheduled query and have users import the CSV into Sheets each morning.

Answer

Create a BigQuery materialized view and paste its results into Sheets manually, refreshing by re-copying the data daily.

Answer

Enable BigQuery BI Engine on the dataset so that Sheets automatically caches the full table in memory for the finance team.