Google Sheets Integrates BigQuery Saved Queries

November 20, 2024 at 4:23:30 AM

TL;DR Google now allows users to search and use pre-defined BigQuery queries directly within Google Sheets Connected Sheets, improving data analysis efficiency. Access saved queries via Connection Settings, Edit connection, Saved queries and query editor, and Project-based search. The feature is rolling out to all domains, expected to complete by December 6, 2024, and is available to Google Workspace customers, Workspace Individual Subscribers, and personal users.

Google Sheets Integrates BigQuery Saved Queries

Google has announced a new feature enabling users to search and utilize pre-defined BigQuery queries directly within Google Sheets Connected Sheets, streamlining the data analysis workflow.

New Feature Details

Direct access to saved BigQuery queries
Search functionality by project
Integration with Connected Sheets
No more manual query copy/pasting required

Access Path

Users can access saved queries through:

Connection Settings
Edit connection
Saved queries and query editor
Project-based search

Search for and reuse pre-defined queries from BigQuery in Connected Sheets.gif

Rollout Timeline

Currently rolling out to all domains
Extended rollout pace (15+ days)
Expected completion: December 6, 2024

Availability

The feature is accessible to:

All Google Workspace customers
Workspace Individual Subscribers
Personal Google account users

This integration represents a significant improvement in the workflow between BigQuery and Google Sheets, making data analysis more efficient and accessible.