Service account JSON

Connect BigQuery to Paradime by uploading a service account JSON key file. Set Target to match the environment you are configuring (dev, prod, or dinoai).

Available in: Code IDE, Bolt, and Agent environments.

Field access levels apply only to the Code IDE environment: an Admin sets workspace-level fields, and each developer sets their own user-level fields. In the Bolt and Agent environments, an Admin sets all fields.

Create a service account

Uploading a service account JSON key file is the quickest and most accurate way to configure a connection to BigQuery and authenticate your development credentials. To create a service account in BigQuery, follow the detailed steps in Google Cloud’s Creating and managing service account keys. Grant the service account the following permissions so Paradime can read from and create tables and views in your BigQuery project:

BigQuery Data Editor
BigQuery User

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 connection. See more here.	`dev`
Dataset Location	The location of BigQuery datasets, configured using the location configuration in a BigQuery profile. Location can be either 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 this service user.	`service_account_user.json`
Execution Project ID (Optional)	You can specify an Execution Project ID to bill for query execution, instead of the project where you materialize your resources. See more here.	(Optional) `analytics-global-project`
Dataset	The default dataset used to build dbt™ objects at runtime.	`dbt_john`
Threads	The number of threads used in this connection. See more here.	`8`

​Create a service account

​Field details

Create a service account

Field details