Analyze hefty data sets with BigQuery and Google Sheets
Tuesday, January 15, 2019
What’s changing
We’re connecting Sheets and BigQuery to make it easier to analyze and share data. The Big Query data connector will help you:- Collaborate with partners, analysts or other stakeholders in a familiar spreadsheet interface
- Ensure a single source of truth for data without having to create additional CSV exports
- Streamline reporting and dashboarding workflows
- Admins: No Action
- End users: Here’s how to get your data from BigQuery and analyze it in Sheets:
- From the Menu, select Data > Data Connectors > BigQuery
- Use the Explore feature
- Create Charts
- Create Pivot Tables
For key permissions for the BigQuery data connector see here.
As always, use share permissions to control who can view, edit or share your data.
In the coming weeks, you’ll be able to use tools like Apps Script and the macro recorder to schedule automatic updates within Sheets to the connected BigQuery data. For example, you can automatically refresh sales data in your spreadsheet so the data is fresh and ready for analysis at the beginning of the day. To learn more about how to record or run macros in Sheets, check out this G Suite Pro Tip.
Rollout Details
- Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on January 15, 2019.
- Scheduled Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on January 29 2019.
G Suite editions
- Available to G Suite Business, G Suite Enterprise, G Suite for Education, G Suite Enterprise for Education, and Drive Enterprise.
- Not available to G Suite Basic and G Suite for Nonprofits.
On/off by default?
- This feature will be ON by default.
- Get G Suite product update alerts by email
- See the G Suite launch release calendar
- Subscribe to the RSS feed of these updates
Notice the new format for these launch announcements? Give us feedback on it here.