---
title: How to Enable Data via BigQuery to INCRMNTAL
description: This article explains how to enable and onboard raw or aggregated data from Google Cloud BigQuery to INCRMNTAL
---

[Skip to content](https://knowledgebase.incrmntal.com/knowledge/how-to-enable-data-via-bigquery-to-incrmntal#main-content)

![Incrmntal Logo.png\]](https://knowledgebase.incrmntal.com/hs-fs/hubfs/Incrmntal%20Logo.png?height=40&name=Incrmntal%20Logo.png)

Open main navigation

Close main navigation

- Go to incrmntal.com

 Go to incrmntal.com

 Hello. How can we help you?

- There are no suggestions because the search field is empty.

1. [Knowledge Base](https://knowledgebase.incrmntal.com/knowledge?hsLang=en)
2. [Integration](https://knowledgebase.incrmntal.com/knowledge/integration?hsLang=en)

# How to Enable Data via BigQuery to INCRMNTAL

## This article explains how to enable and onboard raw or aggregated data from Google Cloud BigQuery to INCRMNTAL

Integration with BigQuery requires 4 steps:

- [**Create a Service Account for INCRMNTAL**](https://knowledgebase.incrmntal.com/knowledge/how-to-enable-data-via-bigquery-to-incrmntal#Create-a-Service-Account)

- [**Enable BigQuery API**](https://knowledgebase.incrmntal.com/knowledge/how-to-enable-data-via-bigquery-to-incrmntal#Enable-BQ-API)
- [**Choose BigQuery Table for the Service Account**](https://knowledgebase.incrmntal.com/knowledge/how-to-enable-data-via-bigquery-to-incrmntal#BQ-Table-Service-Account)
- [**Choose BigQuery Table on INCRMTNAL's dashboard**](https://knowledgebase.incrmntal.com/knowledge/how-to-enable-data-via-bigquery-to-incrmntal#BQ-Dashboard)

### **Create a Service Account**

1. Sign in to [Google Cloud Platform Console](https://console.cloud.google.com/home)
2. Navigate to [IAM & Admin \> Service Account](https://console.cloud.google.com/iam-admin/serviceaccounts)  
   ![image11](https://knowledgebase.incrmntal.com/hs-fs/hubfs/image11.png?width=507&name=image11.png)
3. Click “ + Create Service Account”  
   ![image8](https://knowledgebase.incrmntal.com/hs-fs/hubfs/image8.png?width=574&name=image8.png)
4. Name the new service account **INCRMNTAL** and click “**Create**”  
   ![image2-1](https://knowledgebase.incrmntal.com/hs-fs/hubfs/image2-1.png?width=576&name=image2-1.png)
   
   This will be used in a later stage to grant permission for the relevant data set.
5. In the 2nd step, set the permission to the service account to “**BigQuery Job User**” and click “**Continue**” to finish the Service Account creation process  
   ![image9](https://knowledgebase.incrmntal.com/hs-fs/hubfs/image9.png?width=572&name=image9.png)
6. Click the   ➕   symbol at the raw and click “**Create Key**”  
   ![image4](https://knowledgebase.incrmntal.com/hs-fs/hubfs/image4.png?width=594&name=image4.png)
7. Choose the **JSON** format and click “**Create**”  
   ![image7](https://knowledgebase.incrmntal.com/hs-fs/hubfs/image7.png?width=512&name=image7.png)

### **Enable BigQuery API**

By default, BigQuery API is enabled. But in case you run into difficulties, you may need to enable this feature.

1. Navigate to [APIs & Services](https://console.cloud.google.com/apis) on the Google Cloud Console menu
2. Click “**+ Enable APIs and Services**”
   
   | ![image5](https://knowledgebase.incrmntal.com/hs-fs/hubfs/image5.png?width=568&name=image5.png) |
   | --- |
3. Search for “**BigQuery API**” \> Select and click “**Enable**”
   
   | ![image6](https://knowledgebase.incrmntal.com/hs-fs/hubfs/image6.png?width=409&name=image6.png) |
   | --- |

### **Choose BigQuery Table for the Service Account**

1. Navigate to [BigQuery product page](https://console.cloud.google.com/bigquery), and choose the relevant table you would like to share with INCRMNTAL

**Note:** This step should be repeated for each table you would like to provide access to INCRMNTAL

   2.  Select the option to “**Share Table**”

| ![image10](https://knowledgebase.incrmntal.com/hs-fs/hubfs/image10.png?width=178&name=image10.png) |
| --- |

   3.  Enable the **INCRMNTAL** *Member* you created in the earlier step ([Create Service Account](https://knowledgebase.incrmntal.com/knowledge/how-to-enable-data-via-bigquery-to-incrmntal#Create-service-account-bigquery)). Set the role as “**BigQuery Data Viewer**”. Click “**Add**”

| ![image3](https://knowledgebase.incrmntal.com/hs-fs/hubfs/image3.png?width=539&name=image3.png) |
| --- |

   4.  Click “**Done**” 

### **Choose BigQuery Table on INCRMTNAL's dashboard**

On your INCRMTNAL dashboard, go to [Configuration \> Integrations](https://dashboard.incrmntal.net/system-settings/integrations-new/my-integrations) with either an existing user or the Config account you received from us.

1. Click "Add Integration" on the right side.
2. Search for BigQuery by using the search bar. Click "Add".  
   ![](https://knowledgebase.incrmntal.com/hubfs/image-png-Sep-04-2023-07-14-53-8927-AM.png)
3. Click the Authentication dropdown. Click **"Add Authentication"  
   ![](https://knowledgebase.incrmntal.com/hubfs/image-png-Sep-04-2023-07-16-10-0951-AM.png)**
4. Upload to the dashboard the JSON file you downloaded from BigQuery, that contains the key to the integrated project and tables.
   
   ![](https://knowledgebase.incrmntal.com/hubfs/image-png-Sep-04-2023-07-16-34-8952-AM.png)
5. Click **"Submit"**.

Your Project ID should be automatically populated, as per the granted permissions to the service account.  
![](https://knowledgebase.incrmntal.com/hubfs/image-png-Sep-04-2023-07-18-29-3680-AM.png)

 

13\. Choose the relevant datasets for the integration with INCRMTNAL by clicking on the dropdown **"Dataset Name".** You can also add a dataset name manually.

![](https://knowledgebase.incrmntal.com/hubfs/image-png-Sep-04-2023-07-20-39-0877-AM.png)

 

14\. Click **"Load Tables".** The relevant tables will appear under **"Table Details"**. Then, enable the relevant tables for us to fetch data from.  
![](https://knowledgebase.incrmntal.com/hubfs/image-png-Sep-04-2023-07-23-07-9523-AM.png)

 

If the created job user doesn't have List permissions, the data will not be populated automatically for Dataset Name and Tables. You can add those manually by clicking "Add Tables", or, update the job user to have List permissions.

 

 

**Note:** To preview the data from the integrated tables, click **"Preview"** on the right side of each table.

 ![](https://knowledgebase.incrmntal.com/hubfs/image-png-Sep-04-2023-07-25-20-0417-AM.png)

**Note:** When integrating partitioned tables, we'll present the partition format in the table's name and in a separate column.

![](https://knowledgebase.incrmntal.com/hubfs/image-png-Sep-04-2023-07-27-14-6316-AM.png)

 

15\. Enable the relevant tables by clicking the toggle "Active" on the left side. You can also manually ad a table you'd like to integrate, by clicking **+Add Table** on the top right of the Table Details section and add its name.

If your manually added table is partitioned, please be sure to add the partition format, under the respectful column and the table name  
e.g.  table name: funnel\_data\_{YYYY}\_{MM}

 

16\. Click **"Save".**

 

Done!  
For any question please contact [onboarding@incrmntal.com](mailto:onboarding@incrmntal.com) , or open a [support Ticket here](https://share.hsforms.com/1E8GuQyooSzO1uP7QP1bLHA50da0)

- [Integration](https://knowledgebase.incrmntal.com/knowledge/integration?hsLang=en)
- [Change Logs & Reporting](https://knowledgebase.incrmntal.com/knowledge/change-logs-reporting?hsLang=en#main-content)

    - [General](https://knowledgebase.incrmntal.com/knowledge/change-logs-reporting?hsLang=en#general)
    - [How to Connect Networks to INCRMNTAL](https://knowledgebase.incrmntal.com/knowledge/change-logs-reporting?hsLang=en#how-to-connect-networks-to-incrmntal)
- [Platform Tutorials](https://knowledgebase.incrmntal.com/knowledge/platform-tutorials?hsLang=en#main-content)

    - [Account Management](https://knowledgebase.incrmntal.com/knowledge/platform-tutorials?hsLang=en#account-management)
    - [Getting Started with INCRMNTAL](https://knowledgebase.incrmntal.com/knowledge/platform-tutorials?hsLang=en#getting-started-with-incrmntal)
    - [Basic Tutorials](https://knowledgebase.incrmntal.com/knowledge/platform-tutorials?hsLang=en#basic-tutorials)
    - [Using the Platform](https://knowledgebase.incrmntal.com/knowledge/platform-tutorials?hsLang=en#using-the-platform)
    - [Measurements (Analyst Dashboard)](https://knowledgebase.incrmntal.com/knowledge/platform-tutorials?hsLang=en#measurements-analyst-dashboard)
    - [Advanced Features](https://knowledgebase.incrmntal.com/knowledge/platform-tutorials?hsLang=en#advanced-features)
    - [Data Exports](https://knowledgebase.incrmntal.com/knowledge/platform-tutorials?hsLang=en#data-exports)
    - [FAQ](https://knowledgebase.incrmntal.com/knowledge/platform-tutorials?hsLang=en#faq)
    - [FAQ - Getting Started](https://knowledgebase.incrmntal.com/knowledge/platform-tutorials?hsLang=en#faq-getting-started)
- [Use-Cases](https://knowledgebase.incrmntal.com/knowledge/use-cases?hsLang=en#main-content)

    - [Additional Data Points](https://knowledgebase.incrmntal.com/knowledge/use-cases?hsLang=en#additional-data-points)
- [FAQ](https://knowledgebase.incrmntal.com/knowledge/faq?hsLang=en)
- [Create a Ticket](https://knowledgebase.incrmntal.com/knowledge/create-a-ticket?hsLang=en)

[![INCRMNTAL](https://knowledgebase.incrmntal.com/hubfs/Incrmntal%20Logo.svg "INCRMNTAL")](https://www.incrmntal.com/)

incrmntal.com Knowledge Base

Copyright © 2026, INCRMNTAL