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.
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.
If the user account authentication is successful, Astrato displays the message that permissions are granted. Click OK to continue.
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.
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.
Next steps > Using the Data View Editor ...