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.
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.
JWT- Dynamic Data Connection
Dynamic data connection is good when connecting users to different projects but using one data model.
The main use case for dynamic connections is combining it with embedded analytics.
To serve OEM solutions.
Setting up a dynamic data connection is similar to setting up a JWT connection.
Follow these steps:
Create a new BigQuery connection (check the use dynamic connection checkbox)
Paste the JWT key
Select the default project (this will be the default project to build the data model and define measures and dimensions)
Select the dataset to use. This part is not dynamic, and for all users, the connection will use the same dataset for all users.
Give the data connection a name.
Click next
Add more users (users need to be part of the Astrato tenant) to the connection settings.
Define the key to authenticate and the project to use in the connection for each user.
Click next
Define who has the right to use the connection.
Click connect
Known Limitation
Only users that use the same JWT key and project as the defaults will be able to edit and see the data in the Data View Editor
The dynamic data connection is only used in published workbooks.
Users that aren't defined in the dynamic connection table won't be able to see data in the workbook.
Next steps > Using the Data View Editor ...