Skip to main content

Adding BigQuery Connection

Adding a New Database​

Step 1: Generate the Service Account Key (JSON)​

To obtain the required credentials, follow the instructions in the Google Cloud Documentation.

Step 2: Add a New BigQuery Connection​

In the 'Manage Warehouses' section:

  1. Click on Add New, and select the type as BigQuery.
  2. You will see a form. Upload your Service Account Key (JSON) file. The following fields will be auto-filled:
    • Project ID
    • Private Key ID
    • Private Key
    • Client Email
    • Client ID
    • Client Cert URL
  3. The Database Name will automatically be set to your Project ID and cannot be modified.

Step 3: Submit the Connection​

  1. After uploading the JSON file and confirming the details, click Submit.
  2. The connection will be validated, and your BigQuery database will be added.

Multi-Database Connections​

For details on enabling and configuring support for multiple projects (multi-db), see:
Multi-Database Connections Overview