# BigQuery

Connect your Google BigQuery data warehouse with Humanic to easily manage and analyze your data.

### Prerequisites

Before starting the integration, ensure you have the following:

* A Google Cloud Platform (GCP) account with the BigQuery API enabled
* A service account JSON key file with the necessary permissions to access the BigQuery dataset
* The Project ID of your GCP project containing the BigQuery datasets you want to connect
* The Dataset ID of the specific BigQuery dataset you'd like to integrate with Humanic

{% hint style="warning" %}
For detailed instructions on locating the Project ID, Dataset ID, and creating a service account JSON key file, refer to the [Find your BigQuery Credentials](/humanic/guides/find-your-bigquery-credentials.md) guide.
{% endhint %}

### Access Data Integrations

1. In the [Humanic Dashboard](https://dashboard.humanic.ai), click on the left sidebar link labeled `Data Management` to open the [Data Integrations](https://dashboard.humanic.ai/dashboard/my-accounts/?tab=connect-data) page

### Select BigQuery from Supported Data Warehouses

1. On the [Data Integrations](https://dashboard.humanic.ai/dashboard/my-accounts/?tab=connect-data) page, you'll see various data integrations supported by Humanic
2. Look for the "Data Warehouse" category and click on it
3. From the list of supported data warehouses, select "BigQuery" by clicking on its card

### Provide Connection Details

After clicking the BigQuery card, you'll be prompted to enter the following information:

* **Service Account JSON:** This is a JSON key file that authenticates your BigQuery connection.
* **Project ID**: Enter the ID of your Google Cloud project containing the BigQuery datasets you want to connect.
* **Dataset ID**: Enter the specific dataset within your project that you'd like to integrate with Humanic.

<figure><img src="/files/tZAxyZqTblDeYtGfUg8f" alt=""><figcaption></figcaption></figure>

### **Complete the Integration**

1. Double-check that all the provided details are correct
2. Click on the **CONNECT** button to initiate the integration process

{% hint style="info" %}
Hovering over each connected integration's card will show you the last time the data was synced.
{% endhint %}

### Next Steps

{% hint style="info" %}
Humanic will notify you via email once the initial data sync is complete.
{% endhint %}

Once the connection is established:

* **Access Data:** You can view and manage your synced BigQuery data via Humanic [Data Management](https://dashboard.humanic.ai/dashboard/my-accounts).
* **Create Milestones:** Use the synced data to create and track [milestones](/humanic/cohorts/how-to-create-a-milestone.md).
* **Regular Syncing:** Humanic ensures your data is always up-to-date through regular syncing.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://humanic.gitbook.io/humanic/integrations/bigquery.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.