How to use BigQuery as a source
Google BigQuery is a powerful, fully-managed data warehouse that allows you to run super-fast SQL queries on large datasets. Integrating BigQuery with Sheetgo enables you to build automations that integrate your database directly into a spreadsheet.
This article will guide you through the steps to set up and use BigQuery as a source in your Sheetgo workflows.
Start by creating a new Blank workflow, and selecting the BigQuery option on the source step.
Sheetgo will ask you to grant permission to access your BigQuery account, to do this you just need to click on the Grant permission button and follow the steps that will appear on the Google pop-up window.
After you give Sheetgo access to your BigQuery a new box will appear where you will be able to select which project you want to work on.
After you select the right project Sheetgo will show you the available datasets and the tables that are inside each dataset. You will need to choose one dataset and one table to work on, when you are done selecting these you can filter the information on the Query Editor, by selecting one or all columns and using SQL syntax to further refine your data selection.
Keep in mind: Before going to the next step you can use the Validate query button to check if the query you are using is giving a valid response.
When you are satisfied with the source setup you just need to click on the next step where you will be able to select a data processor or the destination of your information.
Using BigQuery as a source in Sheetgo allows you to leverage the power of BigQuery's data warehousing capabilities while automating your data workflows. By following these steps, you can easily set up and manage data transfers from BigQuery to your preferred destinations, ensuring efficient and up-to-date data processes.
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.