Skip to main content
BigQuery is a fully managed, serverless data warehouse that enables scalable analysis over petabytes of data. Connect it to Paradime to run dbt™ from the Code IDE, deploy production jobs with Bolt, and let the DinoAI background agent work against your warehouse.
IP restrictionsAllow traffic from one of the Paradime IPs in your firewall, depending on the data location selected.See also: Paradime IP addresses.

​
Connection environments

Paradime connects to BigQuery separately for each environment. You configure one connection per environment in Workspace Settings > Environments. The connection fields are the same across environments. What differs is the BigQuery permissions you grant: the Code IDE connection typically reuses a developer’s access, while the Bolt and Agent environments should each use a dedicated service account with the minimum permissions required.

​
Suggested permissions

This set of permissions lets users read from your BigQuery project and create tables and views when running dbt™ from the Paradime terminal. Grant them to the account you connect in Paradime.

​
Add a connection

  1. Click Settings in the top menu bar of the Paradime interface to access Workspace Settings.
  2. In the left sidebar, click Environments.
  3. Click Add New next to the section for the environment you are configuring:
    • Code IDE for the Code IDE connection
    • Bolt for the Bolt connection
    • Agent for the Agent connection
  4. Select BigQuery and choose an authentication method.

​
Authentication methods

Service account JSON

Connect with a service account JSON key file. Available in all environments.

BigQuery OAuth

Let each user authenticate through BigQuery OAuth. Code IDE only.

Optional connection attributes

Set additional profiles.yml attributes for this connection.

Related topics

BigQueryDinoAI ToolsBigQuery ToolsBigQuery AlertsBigQuery cost connection