Here we are going to explain how to connect Google BigQuery and have your data sent there.
Getting your data to Google BigQuery is an easy task with Dataddo. If you already have your BigQuery account connect to Dataddo, and you only need instructions on how to connect it to a Data Flow, you can skip Step 1 and start from Step 2 right away.
STEP 1 - Adding a Google BigQuery Destination
First, navigate to Destinations at the top of the Dataddo app.
Then click on New destination in the top right corner.
From the list of data storages destinations, choose the Google BigQuery connector.
Once you select your Destination, you will be requested to give Dataddo authorization to connect with your BigQuery account.
After you authorize the connection to your BigQuery account you will be asked to configure it. If you have more than one Google BigQuery account connected to Dataddo, you can select the one you need. You will also be asked to select which Project and Dataset you want to send the collected data to. After that, you can either choose to Create Flow or Exit the page.
STEP 2 - Connecting a Data Flow a Google Big Query destination
You need to create a new Data Flow. You can do this either by navigating to Sources, picking the Source that you want to use, and clicking on Add to flow.
OR by navigating to Data Flows
and clicking on New flow
and adding the required source by clicking on Add Source.
Next, you click on Add Destination and look for the Destination you set up previously.
On the next page, you will have to configure the Flow. Insert the Data Flow Label, Database Table, and Snapshotting Settings.
Lastly, you will see instructions to set up your Google BigQuey table. After that, your data flow ready to go.