What’s changing
Admins for select Google Workspace editions can now allow their users to delegate access to BigQuery when using Connected Sheets. If the setting is enabled by the admin, end users with access to BigQuery data can delegate their credentials to collaborators to allow them to refresh or edit analysis as needed.
Who’s impacted
Admins and end users
Why you’d use it
Connected Sheets links Google Sheets to BigQuery, so you can analyze large BigQuery datasets using familiar spreadsheet tools and operations. This means users don’t need to know SQL and can generate insights with basic spreadsheet operations like formulas, charts, and pivot tables.
We hope this update makes it easier for your stakeholders and other collaborators to refresh or edit an analysis as needed, helping derive insights faster.
Getting started
- Admins: This feature will be OFF by default. Visit the Help Center to learn more about using Connected Sheets in your organization.
- End users: If enabled by your admin, you can allow collaborators to refresh and analyze BigQuery data using your credentials. You can also indicate whether you’d like to “sticky” this setting for all future connections. Visit the Help Center to learn more about how to analyze BigQuery data using delegated access in Connected Sheets.
Rollout pace
- Rapid and Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on July 12, 2022
Availability
- Available to Google Enterprise Essentials, Enterprise Standard, Enterprise Plus, Education Standard, Education Plus
- Not available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Education Fundamentals, Frontline, and Nonprofits, as well as G Suite Basic and Business customers