Question

A financial operations team wants business analysts to explore a 4 TB BigQuery transactions table using a familiar spreadsheet interface. The analysts need to build pivot tables, apply filters, and create charts on the full dataset without exporting data or hitting spreadsheet row limits, while ensuring queries run against BigQuery and respect existing IAM permissions. Which approach best meets these requirements?

Accepted Answer

Use Connected Sheets in Google Sheets to connect directly to the BigQuery table, allowing analysts to build pivot tables and charts that execute queries in BigQuery.

Answer

Schedule a daily BigQuery export of the full table to CSV in Cloud Storage and have analysts import the CSVs into Google Sheets.

Answer

Create a BigQuery materialized view and have analysts download the results with the bq command-line tool into Sheets.

Answer

Enable BigQuery BI Engine and have analysts query the table through the BigQuery console, copying results into Sheets manually.