Skip to main content
Google BigQuery is a fully managed, serverless data warehouse that enables scalable analysis over petabytes of data. As a development environment in Paradime, BigQuery enables dbt™ development from Paradime’s Code IDE.
IP RESTRICTIONSMake sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.👉 See also: Paradime IP addresses.
Suggested permissions:The following permissions will enable users in Paradime to run dbt™ from Paradime in your BigQuery project:
  • BigQuery Data Editor
  • BigQuery User

Initial Setup Instructions

  1. Click Settings in the top menu bar of the Paradime interface to access Account Settings
  2. Click “Connections” in the left sidebar
  3. Click “Add New” next to Code IDE Environment
  4. Select “BigQuery
Next, choose your preferred authentification method to proceed:
  1. Using BigQuery OAuth
  2. Using BigQuery Service Account JSON

Using BigQuery OAuth

Follow our BigQuery OAuth setup guide to configure OAuth authentication. Each user will need to approve the required scopes when connecting.

Fields Details

Below are list of fields and example to create a connection.
Field access levels:
  • 🏢 Workspace level fields are set by the the workspace Admin and not configurable for by user
  • 👥 User level fields are set by each user (Admin/Developer) when setting the Development connection.

Using BigQuery Service Account JSON

Uploading a service account JSON key file is the quickly and accurately way to configure a connection to BigQuery and authenticate each user’s development credentials. To create a service account in BigQuery, follow the detailed steps in Google Cloud’s Creating and managing service account keys.

Field Details

Below are list of fields and example to create a connection.
Field access levels:
  • 🏢 Workspace level fields are set by the the workspace Admin and not configurable for by user
  • 👥 User level fields are set by each user (Admin/Developer) when setting the Development connection.