Monday, July 18, 2022

Allow collaborators to analyze data in Connected Sheets with delegated access

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.
For all new connections, users will see this dialog which asks users to explicitly choose ON or OFF before they can proceed

Rollout pace



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

Resources