Question

A finance team uses Google Sheets to build monthly reports off a 4 TB BigQuery sales table. They currently copy a static CSV export into Sheets each month, but analysts complain the numbers are stale by the time they present, and manual exports frequently miss late-arriving corrections. The team lead wants analysts to explore and pivot the data directly in the familiar Sheets interface while always reflecting the latest committed rows in BigQuery, without hitting Sheets' 10-million-cell limit. What should you recommend?

Accepted Answer

Connect the Sheet to the BigQuery table using Connected Sheets, so pivot tables and formulas run queries against BigQuery on demand rather than importing rows into the grid.

Answer

Schedule a Cloud Function to export the full table to CSV nightly and use the IMPORTDATA function to pull it into the Sheet automatically.

Answer

Create a BigQuery materialized view and copy its results into the Sheet with a scheduled Apps Script that paginates through all rows.

Answer

Enable BigQuery BI Engine on the dataset and paste the query results into the Sheet after each acceleration run.