How to connect Google BigQuery

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.

Destination_tab

Then click on New destination in the top right corner. 

1.Add new destination

From the list of data storages destinations, choose the Google BigQuery connector.

Connect_destination

Once you select your Destination, you will be requested to give Dataddo authorization to connect with your BigQuery account.

3. Authorization page-1

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.

BigQuery Configuration 

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.

2. Creating flow form source

OR by navigating to Data Flows

1. Data flow button

and clicking on New flow

3. Data Flows Page

and adding the required source by clicking on Add Source.

4. Adding Source for Flow

Next, you click on Add Destination and look for the Destination you set up previously. 

6. Selecting Destination

On the next page, you will have to configure the Flow. Insert the Data Flow Label, Database Table, and Snapshotting Settings.

Data FLow Configuration_Last step

Lastly, you will see instructions to set up your Google BigQuey table. After that, your data flow ready to go.

DB instructions