Google has launched a new beta that connects BigQuery and Sheets. The connection happens in a data connector that dynamically connects Sheets with BigQuery. BigQuery users can join the beta here.
According to Google, users in the Beta will be able to create a BigQuery query, get a preview, and insert the results into Sheets without leaving the Sheets interface. The data can then be refreshed from within the Sheets interface.
Teams can use this to streamline reporting and dashboard workflows; Have a single source of truth for big data insights without exports that can get out of date and cause errors; Democratize analysis. The Sheets interface can bring data to wider, less technical teams with a familiar spreadsheet interface and tools like “Explore” and macro recorder; Increase collaboration. Sheets makes it easy for teams to comment, discuss, and share insights as they analyze and use the data.