Admins for make a selection Google Workspace editions can now permit their customers to delegate get admission to to BigQuery when the usage of Hooked up Sheets. If the surroundings is enabled via the admin, finish customers with get admission to to BigQuery information can delegate their credentials to collaborators so they can refresh or edit research as wanted.
Admins and finish customers
Why you’d use it
Hooked up Sheets hyperlinks Google Sheets to BigQuery, so you’ll analyze massive BigQuery datasets the usage of acquainted spreadsheet equipment and operations. This implies customers don’t wish to know SQL and will generate insights with elementary spreadsheet operations like formulation, charts, and pivot tables.
We are hoping this replace makes it more uncomplicated in your stakeholders and different collaborators to refresh or edit an research as wanted, serving to derive insights sooner.
- Admins: This selection will likely be OFF via default. Seek advice from the Assist Heart to be informed extra about the usage of Hooked up Sheets for your group.
- Finish customers: If enabled via your admin, you’ll permit collaborators to refresh and analyze BigQuery information the usage of your credentials. You’ll be able to additionally point out whether or not you’d love to “sticky” this surroundings for all long run connections. Seek advice from the Assist Heart to be informed extra about methods to analyze BigQuery information the usage of delegated get admission to in Hooked up Sheets.
For all new connections, customers will see this conversation which asks customers to explicitly select ON or OFF sooner than they are able to continue
- To be had to Google Undertaking Necessities, Undertaking Same old, Undertaking Plus, Training Same old, Training Plus
- No longer to be had to Google Workspace Necessities, Industry Starter, Industry Same old, Industry Plus, Training Basics, Frontline, and Nonprofits, in addition to G Suite Fundamental and Industry shoppers