BigQuery

circle-exclamation
circle-info

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 keysarrow-up-right.

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 herearrow-up-right.

dbt-bigquery

Target

The target name used to identify the DinoAI agent environment connection. See more herearrow-up-right.

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 herearrow-up-right.

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 herearrow-up-right.

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 herearrow-up-right.

8

Last updated

Was this helpful?