---
title: Connect your BigQuery warehouse to Optimizely Analytics
slug: analytics/docs/connect-your-bigquery-warehouse-to-optimizely-analytics
docTags: 
createdAt: 2026-07-20T15:44:20.380Z
---

Connecting your BigQuery warehouse to Optimizely Analytics lets you seamlessly access and analyze vast amounts of data stored in BigQuery, letting you derive actionable insights and make data-driven decisions.

1. Click **Data > Connections** **> +New Connection** **> BigQuery**.
2. Configure the following fields:
   - **Project ID** – The ID of the project you want to connect. Use the same project in which the service account and the role were created. You can also find this information in the [BigQuery JSON file](docId\:qDEt1Hu7bvl9VTNgMFPKE). Open the file and copy the value in the **project\_id** field.
   - **Service Account Email** – The service account's email address. You can also find this information in the [BigQuery JSON file](docId\:qDEt1Hu7bvl9VTNgMFPKE) downloaded in the previous step. Open the file and copy the value in the **client\_email** field.
   - **Service Account Key JSON** – The JSON file containing the credentials and details for the service account. Copy all the content of the [BigQuery JSON file](docId\:qDEt1Hu7bvl9VTNgMFPKE) and paste it into the field provided.
3. Click **refresh** to test the connection's configuration. If your configuration is successful, the icon turns green.
4. Click **+** under **Parameters** in the **Advanced options** section to add non-essential or custom properties as key-value pairs beyond the main configuration parameters. Here, you can define **AdditionalProjectID** as a comma-separated list of project IDs (for example, project2, project3, etc.) to access and navigate metadata from other projects within the application, beyond your primary project.
5. Click **Save**.

![bq-new-1.png](https://api.archbee.com/api/optimize/BrbvVORKJ5iIeSMZye5kI/GtL7bPMgXptVmf7g7xhiE-20260720-144830.png)

## Sample credentials

The following examples show the required fields to create a BigQuery connection in Analytics:

- **Project ID** – Paste the value corresponding to the **Project ID** field in your JSON file.
  - **Example** – *stately-lodge-3613456*
- **Service Account Email** – Paste the email address in your JSON file from the **Service Account Email** field.
  - **Example** – [netspring-byow@stately-lodge-3613456.iam.gserviceaccount.com](mailto\:netspring-byow@stately-lodge-3613456.iam.gserviceaccount.com)
- **Service Account Key JSON** – Paste the content from the **Private Key** field into your JSON file. For example:

```auto
{
"type": "service_account",
"project_id": "stately-lodge-3613456",
"private_key_id": "6ae1360e16775af76163aa3891ccaffc08706d02",
"private_key": "-----BEGIN PRIVATE KEY-----\\nMIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQCo9zZ+kDmFbnS+\\n0qHf6nb3M6JryOlrag7QKhkSYTuC0AkuqSGRiUcWDEMW33WhVtJshK3T9PacU6fB\\np5cH75aKydBblOJgNT0t8DDDOviVGFhJs0o8ITZAjI4odVr0UWbYmehPb7tjMNV5\\nlfz3RYFiCITLyTAS/Pt1FFvXkcwreQtARwqpixVNEqviHPFiUk5XuQPVNnZZsQzX\\n4TJQxz1QycMoeMxm2D0OsfugF8DsdKc2ms0JUZ9lbMhmZKaCY1cVLi38JRkE+vfl\\n4ZpxyUR31h9hNO2tSLRPJKdS1WcdI5XfekrfgU7WgPmaXVqcvll\\nDYUyqOiFAgMBAAECggEAAIHWy8JZoBL3FU2Nx2TJ1do8qL3Vl8Idr5m4v+DDZT7Z\\nZYpK+8fMNcXJwuCmD7AyaytOHvBeIrHhz9zyFmQtcQGLE7wv88UzXPqo+7NDVol0\\nq7jaVJTgRfr+6ullDBwkcWOrjAO3yjlEIschM8LQCgAENnl/LtWhdSgC/QIqTo/C\\n67dvj03Qbc0kiBJUPOGITi9fGuZypM+L0SSPkoQNaIefQX0KGCbEJPf1Iibh0k/Z\\nCYxs0IRZvw3AJa6jcafLSb6vKqK6fFEtlTowWj0rEOay0AYDfKNIGs37YoXHnFHH\\nc2IVRdZF17aeS5536DxSm0YUiCvNYlCMgcUEiOGSTwKBgQDnSKeqbk5N4XcjPjvX\\nT2yrZOhsxqbp/cXw10XoZFFT6Ug7AejSnoZsSMF1vtiWRtiHe9djt8SEecH4zwAx\\n8iJi37I2J3N/Vs1gnzl1B9grb/xv0FMS2GqQZ3XZ0zmLlUe3u0xzVTuTmAGDYsko\\nTParajsksA30fxLeCPM/fwca2wKBgQC7BbCoEh7VqCuxR+IlJqTC6NMatzsMoxmA\\ndvgywvHs/AjcFkXowu8uKcrL3VKTlcYI8lXqqL3+/opgtF9yhKpvWb2VYZcy9fjM\\n5e6/bQYHOlSHFJ1ghszVyQ+mTuJRPno0r3EMLkPoPXMMe7GZt7IjeCuhy5M+i08h\\n9UQGW4J4HwKBgQCWkwOtfrD2HUK+LCczbx8VmtWC8/X5QuGagdyehqk4ExmWaRDW\\nBqUHXHqvGLfTZn5T/nllD2Aey1JQlRvQaI6ghnh0r0yPa8i8Dg2PNrMy3G6hsSRU\\nkZcXOnRMgyrkyCRv5r3IHIZz+bOKgUbrOOgjAz9MDF6Zfh2fdn4/KYlLnwKBgFmo\\nPqo0FagjuN6CMX3R6satyxZRpPNH9V/KqO3c2xHbOXwZCWaunO8qhdf5wC6UbJ25\\nX0rhnkPyTvBRSDikNPiwstw8Lrn1hVLlH/GRGIS6h+9CCLhPpz8N5ny58HE2XGuJ\\nd855F4DshI0Fd3zTvYiXgYNNDse7DTKgW/4YPJHNAoGAKa84YsiJC7DfgBNVPwyB\\nyckawDHwo/UUe/YWTSkgqBOvY5DqAh+HiDASN5NbSSzBu4iRBc9rBB1j6Rng32IK\\nPVZC6tJgWDJ5ly1SHd0rGsUAGjvqHN9x59MRR28o0ahaOzroV6wT68+bxdtDlcT9\\nd2u6XTSBHCkVtK/tgsEJNEk=\\n-----END PRIVATE KEY-----\\n",
"client_email": "netspring-byow@stately-lodge-363318.iam.gserviceaccount.com",
"client_id": "110408766655969317177",
"auth_uri": "https://accounts.google.com/o/oauth2/auth",
"token_uri": "https://oauth2.googleapis.com/token",
"auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
"client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/netspring-byow%40stately-lodge-363318.iam.gserviceaccount.com"
}
```