All Collections
Data
Data Connections
Connecting to Google BigQuery
Connecting to Google BigQuery
Piers Batchelor avatar
Written by Piers Batchelor
Updated over a week ago

Introduction

In this article, we're going to show you how to connect your Astrato workspace to a data source in Google BigQuery.



Data connection details required

Before you can set up your data connection, you'll need the following:

  • Data source: data source name, project, and dataset.

  • User account: enter your username and password when asked, or if using a Google account, when you log in, Google will ask you to consent to Astrato being able to access your Google workspace (Sheets and Drive).

  • If using a JWT Token, you'll need the token you've created. If you'd prefer to use Google console to create the token, please

Creating a data connection to Google BigQuery

  • Select Data in the Astrato sidebar and click on Create Data to open the Create New Data Source.

  • Click the Google BigQuery icon to start.

create new data source in Astrato
  • Select either OAuth or JWT Token for access.

Select either OAuth or JWT Token for access.

OAuth - Allow Astrato permission to access external data

Astrato checks if you already have an integration with Google BigQuery, if not, the message displays that permission is required.

  • Click Confirm to continue.

  • The Google authentication page displays, select the account you want to use, review the permissions required, and click Allow to continue.

Google authentication page displays, select the account you want to use to access the dataset
  • If the user account authentication is successful, Astrato displays the message that permissions are granted. Click OK to continue.

Google BigQuery permissions have been granted.

OAuth - Enter data connection and project details

  • Enter the details (project, dataset, data source name) and click Connect. This completes the data connection process. The Data View Editor in Astrato displays once the connection is complete.

Enter the project, dataset and data source name in Google BigQuery.

JWT - Enter data connection details

  • Once you've picked the data connection, slide the toggle to the right to select the option for JWT Token.

  • Enter the details (JSON key, dataset, data connection name) and click Connect.

  • The Data View Editor in Astrato displays once the connection is complete.

Did this answer your question?