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
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.