Google BigQuery is a powerful, fully-managed data warehouse that allows you to run fast SQL queries. Integrating BigQuery with Sheetgo lets you bring information from a database to spreadsheets.
This article will guide you through the steps to set up and use BigQuery as a source in your Sheetgo workflows.
Note: To use BigQuery as a destination, you must have read permissions for the desired resource. Learn how to get permissions for BigQuery.
First, create a new Blank workflow. Under Select source, select BigQuery.
Sheetgo needs permission to access your BigQuery account. To do this, click Grant permission and follow the steps that appear on the Google pop-up.
After giving Sheetgo access to your BigQuery a new box will appear where you can select which project you want to work with.
After selecting a project, Sheetgo will show you available datasets and their corresponding tables. You need to choose a dataset and a table to work with. Next, introduce a query on the Query Editor to select table columns or further refine your data selection.
Keep in mind: You can use the Validate query button to check if the query you are using is giving a valid response.
Once the source is setup, just click Next step to select a data processor and the destination for the information.
In Sheetgo, using BigQuery as a source lets you leverage its power and data warehousing capabilities while automating your data Workflows. By following these steps, you can set up and manage data transfers from BigQuery to your preferred destinations.
Need more help?
Contact us via chat, on our email ([email protected]), or send us a ticket!
Visit our Community for help, tips, tricks, and feedback for Sheetgo.