To add a Bigquery data source to Latitude, you need to get the Project ID and upload the JSON Key File of the project that contains the data you want to add.
To add a new data source go to Settings > Data Sources > Add new data source and select Bigquery. Remember only admins can access worksapce settings. Let’s see how to make the connection:
Fill in all the required fields.
- Alias → (Required) The name you'll see for this source in Latitude. This doesn't affect anything in your database.
- Project ID → The identifier of the Bigquery project that contains your data. Check the next section to find out how to get the Project ID.
- JSON Key File → The file that contains all the information to connect to Bigquery. Check the next section to know how to get JSON Key File.
Click on Add Data Source to save the configuration.
Now, it's time to check that everything was set up correctly. Go to a project, add an Athena data source and check that you get results.
If your data source has a firewall, you can whitelist our static IPs: 126.96.36.199 and 188.8.131.52
Get the Project ID
Make sure you are in the correct organization
Click on Select a project
Click on Select from and if you are in another organization select the correct one
Check the Google Project that contains the data you want to sync. If you don't have any project check how to create a new Google Cloud Project
The Project ID will appear under the name
Get the JSON Key File
Go to the Service Accounts table inside your project. In case you don't have any Service Accounts table check how to create and configure a Google Service Account
Click on the Actions column to see the options
Click on Manage Keys
You will see the list of Keys
Click on Add Key
Select JSON and click on Create
Done! A download will start, this .json file is the one required to make the connection
Create a new Google Cloud project
Go to the Service account list.
Click on your organization or click directly on Create project
If you are accessing through the organization click on New Project
Fill in the fields and click on create
Done! Your new project will appear on the list.
Create and configure a Google Service Account
Click on the project
Click on Create Service Account
Fill in the fields and continue
- Service account name → A name to identify easily your account
- Service account ID → This field will is auto-populated based on your account name
- Service account description → A description to better understand the purpose of your account
Add the following roles to grant access to the project
- BigQuery Data Viewer
- BigQuery Metadata Viewer
- BigQuery Read Session User
- BigQuery Job User
We can skip the next step Grant users access to this service account, it’s not required.
Done! Google Service Account created