BigQuery

BigQuery Sync allows you to export Optibase experiment and analytics data directly to your Google BigQuery warehouse. This enables deeper analysis, custom reporting, and integration with your workflow

Prerequisites

Before setting up the integration, make sure you have:

• A Google Cloud Platform (GCP) account

• A BigQuery project and dataset

• Permissions to create service accounts and keys in Google Cloud

• Access to your Optibase workspace settings

---

Step 1: Create a BigQuery Dataset

1. Go to Google Cloud Console

2. Navigate to BigQuery

3. Select your Project

4. Click Create Dataset

5. Enter the following details:

Field	Value
Dataset ID	Choose a name (e.g. optibase_data)
Data location	Choose your preferred region

1. Click Create dataset

---

Step 2: Create a Service Account

1. Open Google Cloud Console

2. Navigate to IAM & Admin

3. Click Service Accounts

4. Click Create Service Account

Fill in:

Field	Value
Service account name	optibase-bigquery-sync
Description	Service account used for Optibase BigQuery export

Click Create and Continue

---

Step 3: Grant Required Permissions

Assign the following role to the service account:

• BigQuery Data Editor

This allows Optibase to write experiment data into your dataset.

Click Continue, then Done.

---

Step 4: Create and Download the Service Account Key

1. Go to the Service Account you just created

2. Open the Keys tab

3. Click Add Key

4. Select Create new key

5. Choose JSON

6. Click Create

A JSON key file will be downloaded to your computer.

You will use this file to authenticate Optibase with BigQuery.

---

Step 5: Configure BigQuery Sync in Optibase

1. Log in to Optibase

2. Navigate to:

Workspace Settings → Integrations → BigQuery

1. Click Connect BigQuery

Fill in the following fields:

Field	Description
Project ID	Your Google Cloud project ID
Dataset ID	The dataset you created earlier
Service Account JSON	Upload the downloaded JSON key file

1. Click Save

---

Step 6: Verify the Connection

After saving the integration:

1. Optibase will validate the credentials

2. If successful, the BigQuery connection will be activated

3. Data exports will begin automatically based on your workspace configuration

New experiment and analytics data will start appearing inside your BigQuery dataset tables.

---

Data Available in BigQuery

The BigQuery export includes:

• Experiment impressions

• Experiment conversions

• Visitor identifiers

• Variant assignments

• Event timestamps

• Experiment metadata

This allows you to combine Optibase data with your internal analytics and BI tools.

---

Troubleshooting

Permission errors

Make sure the service account has:

BigQuery Data Editor

access to the dataset.

Dataset not found

Verify that the Dataset ID and Project ID are correct.

Invalid JSON key

Ensure you upload the original JSON key file generated in Google Cloud.