BigQuery

IP RESTRICTIONS

Make sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.

👉 See also: Paradime IP addresses.

We recommend creating a dedicated BigQuery service account for the DinoAI agent environment, with the minimum permissions required to create tables and views in your BigQuery project.

Create a service account

To create a service account in BigQuery, follow the detailed steps in Google Cloud's Creating and managing service account keys.

Required permissions

This set of permissions will enable DinoAI to read from and create tables and views during background agent sessions in your BigQuery project.

BigQuery Data Editor
BigQuery User

Add the DinoAI agent environment connection

To add the BigQuery DinoAI agent environment connection, follow these instructions:

1. Click Settings in the top menu bar of the Paradime interface to access Account Settings

2. In the left sidebar, click Connections

3. Click Add New next to the DinoAI Background Agent Environment section

4. Select BigQuery

Field details

Field	Description	Example
Profile Name	The profile name set in your dbt_project.yaml. See more here.	dbt-bigquery
Target	The target name used to identify the DinoAI agent environment connection. See more here.	dinoai
Dataset Location	The location of BigQuery datasets. Can be a multi-regional location (e.g. EU, US) or a regional location (e.g. europe-west2). See more here.	US
Service Account JSON	The service account JSON file created for the DinoAI agent service user.	service_account_dinoai.json
Execution Project ID (Optional)	Specify an execution project to bill for query execution, instead of the project where you materialise your resources. See more here.	analytics-global-project
Dataset	The default dataset used to build dbt™ objects during DinoAI background agent sessions.	dbt_dinoai
Threads	The number of threads used in this connection. See more here.	8