1. Support Center
  2. Data Streams
  3. Linking your Data Destinations

How to Link your Google BigQuery credential in Data Streams

Creating a service account in Google BigQuery, downloading your JSON key, and uploading it in Data Streams to link your BigQuery credentials

1. Create a service account for your Google BigQuery project.

After selecting your Google BigQuery project in your Google Cloud Console, go to ‘IAM & admin’ in the navigation menu, then select ‘Service accounts.’

2018-12-13_0825

Click the ‘+ CREATE SERVICE ACCOUNT’ button.

2018-12-13_0825_001

Name your service account.

2018-12-13_0826

Choose a Project role by clicking the ‘Select a role’ button.

2018-12-13_0826_001

Choose ‘BigQuery,’ then choose the ‘BigQuery Admin’ role.

2018-12-13_0826_002

Make sure you check the ‘Furnish a new private key’ box, and select the JSON format. 

2018-12-13_0826_003

Hit ‘SAVE’ in order to download your JSON file. This will be saved in the folder selected in your browser settings.

2018-12-13_0827

2. Upload your JSON file in Data Streams

In Data Streams, click the ‘Data Extract Source’ box

2018-12-13_0827_001

Choose ‘New Connection’, select ‘Google BigQuery’ from the Data Connector drop-down and click the ‘Link’ button.

2018-12-13_0827_002

Open the folder where your JSON file was downloaded and drag it in the box. 

2018-12-13_0827_003

Once you’ve dragged your file, you’ll receive a message confirming your credentials are valid. To complete the linking process, click ‘Submit.’

2018-12-13_0827_004

Your credentials are now linked!