How To Migrate Data From BigQuery To Google Sheets

Transcript:

This is BigQuery, a data warehouse that helps you manage and analyze your data with built-in features like:

• Business Intelligence
• Geospatial Analysis
• Machine Learning

Thanks to GURUS’ built-in connector, BigQuery is now hosting our daily synchronized data from NetSuite.

In this video we're using a demo project, called Gill Demo 2, that includes a dataset, “NetSuite Production”, in which we stored all of our NetSuite data in tables and views.

In order to push the data from the data warehouse to Google Spreadsheet we're opening a new spreadsheet in this window, and the steps are simple from here:

• Go to: Data > Data Connectors > Connect to BigQuery
• Select the project Gill Demo 2 and the dataset “NetSuite Production”.

Note: You'll have access to the full GURUS NetSuite data model, which stores all data coming from NetSuite.

Now, choose one of the tables or views to perform your analysis in the spreadsheet. For example, we’re selecting the customer view and clicking on Connect.

The spreadsheet now connects to Google BigQuery and retrieves the customer data we selected.

Once the connection is successful, the customer view data is available for analysis in Google Sheets.

From here, you can create a new chart, Pivot Table, add formulas, or calculated columns to enhance your analysis.

You can also edit the connection to switch to another table or view — for example, the employee view.

After clicking Connect, the table will refresh with the employee data. You can also modify refresh settings to synchronize data periodically.

Benefits of Using GURUS Connector

• Simplifies data migration from BigQuery to Google Sheets
• Eliminates manual exporting and formatting
• Enables real-time analysis with automated refresh
• Compatible with all NetSuite data models

Talk to a GURUS Solutions Expert Today