Slide thumbnail

Update knowledge G Suite

Knowledge

Analyze hefty data sets with BigQuery and Google Sheets

18/02/2019

What’s new: We’re connecting Sheets and BigQuery to make it easier to analyze and share data. The BigQuery 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

Who’s impacted

 

End users

 

Why you’d use it

 

We built BigQuery to help analysts make sense of large datasets—now it’s easier for employees and team members outside of data analyst functions to access and analyze data. By bringing these two tools together, collaborators and other stakeholders can view up to 10,000 rows of data from BigQuery in an easy, familiar interface. This makes collaboration and insight sharing easier, enabling faster decision making.

 

How to get started:

 

 

To check key permissions for the BigQuery data connector see here.

 

Google Sheets & BigQuery

 

Additional details

 

Anyone you share the spreadsheet with will see the data contained in the sheet. Only those with edit access in Sheets and view access to the BigQuery table have the ability to refresh the dataset.

 

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.

 

Helpful links

 

Help Center: Analyze BigQuery Data within Sheets

 

Updated: Gimasys

Knowledge

Update and support center for administrator and user