> ## Documentation Index
> Fetch the complete documentation index at: https://docs.hunch.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# BigQuery

> Connect your BigQuery account to Hunch

This guide will help you securely connect your BigQuery account to Hunch using Google Cloud Platform Service Account in just a few minutes.

***

## ✅ What You'll Need

* **Google Account** with access to BigQuery
* **Google Project ID**

***

## 1️⃣ Prepare Your Google Account

1. Make sure you have a Google account with access to BigQuery

2. Ensure you have the necessary permissions to access BigQuery data

3. Create a Google Service Account:

   * Go to **Google Cloud Platform Console** > **IAM & Admin** > **Service Accounts**
   * Click **+ CREATE SERVICE ACCOUNT**

   {" "}

   <img src="https://mintcdn.com/hunch-ac9ddd82/8-JWcEs7ZydEJuN2/public/images/shared/gcp-create-sa-button.png?fit=max&auto=format&n=8-JWcEs7ZydEJuN2&q=85&s=88d7f70c955bcd22d1543ab39815b4f5" alt="GCP Create Service Account Button" className="w-full rounded-lg shadow-lg my-4" width="1698" height="904" data-path="public/images/shared/gcp-create-sa-button.png" />

   * Enter a name for your service account (e.g., "hunch-integration")
   * Click **CREATE AND CONTINUE**

   {" "}

   <img src="https://mintcdn.com/hunch-ac9ddd82/8-JWcEs7ZydEJuN2/public/images/shared/gcp-sa-name.png?fit=max&auto=format&n=8-JWcEs7ZydEJuN2&q=85&s=b0e3f506b721398b9c9c15b241b082de" alt="GCP Service Account Name" className="w-full rounded-lg shadow-lg my-4" width="2154" height="1318" data-path="public/images/shared/gcp-sa-name.png" />

   * Click the **Select a role** dropdown
   * In the search box, type "BigQuery Data Viewer" > Select **BigQuery Data Viewer**
   * Click **ADD ANOTHER ROLE**
   * Click the **Select a role** dropdown again
   * In the search box, type "BigQuery Job User" > Select **BigQuery Job User**
   * Click **CONTINUE** and then **DONE**

   {" "}

   <img src="https://mintcdn.com/hunch-ac9ddd82/HjVSL8mgxMQv8Txo/public/images/bigquery-integration/bigquery-gcp-sa-role.png?fit=max&auto=format&n=HjVSL8mgxMQv8Txo&q=85&s=9d77e1fa900daed07a423709b951a0b6" alt="GCP Service Account BigQuery Roles" className="w-full rounded-lg shadow-lg my-4" width="2154" height="1446" data-path="public/images/bigquery-integration/bigquery-gcp-sa-role.png" />

4. Generate and download the service account key:

   * Find your new service account in the list
   * Click the three dots menu (⋮) > **Manage keys**

   {" "}

   <img src="https://mintcdn.com/hunch-ac9ddd82/8-JWcEs7ZydEJuN2/public/images/shared/gcp-sa-manage-keys.png?fit=max&auto=format&n=8-JWcEs7ZydEJuN2&q=85&s=e3d6aae18ff81b8a2239ef6a2ae14720" alt="GCP Service Account Manage Keys" className="w-full rounded-lg shadow-lg my-4" width="3458" height="1382" data-path="public/images/shared/gcp-sa-manage-keys.png" />

   * Click **ADD KEY** > **Create new key**
   * Choose **JSON** format
   * Click **CREATE** to download the key file
   * Keep this file secure - you'll need it for the next steps

   {" "}

   <img src="https://mintcdn.com/hunch-ac9ddd82/8-JWcEs7ZydEJuN2/public/images/shared/gcp-sa-create-key.png?fit=max&auto=format&n=8-JWcEs7ZydEJuN2&q=85&s=4b3c7e18090d1e58d1b4070a6bd3e589" alt="GCP Service Account Create Key" className="w-full rounded-lg shadow-lg my-4" width="3496" height="1382" data-path="public/images/shared/gcp-sa-create-key.png" />

[For more details, see Google Cloud Platform documentation -->](https://cloud.google.com/iam/docs/service-accounts-create#console)

***

## 2️⃣ Connect BigQuery to Hunch

1. Log into [Hunch.dev](https://app.hunch.dev/login)
2. Click on your organization name > **Connect Data**

<img src="https://mintcdn.com/hunch-ac9ddd82/8-JWcEs7ZydEJuN2/public/images/shared/platform-connect-data.png?fit=max&auto=format&n=8-JWcEs7ZydEJuN2&q=85&s=b99e941c687a6833d004f27f16613f71" alt="Platform Settings" className="w-full rounded-lg shadow-lg my-4" width="2856" height="1354" data-path="public/images/shared/platform-connect-data.png" />

3. Click **Configure** on the BigQuery row

<img src="https://mintcdn.com/hunch-ac9ddd82/HjVSL8mgxMQv8Txo/public/images/bigquery-integration/bigquery-platform-integration.png?fit=max&auto=format&n=HjVSL8mgxMQv8Txo&q=85&s=218258fcf9007fdb57b5f4aab9ebc44a" alt="BigQuery Integration" className="w-full rounded-lg shadow-lg my-4" width="3592" height="2070" data-path="public/images/bigquery-integration/bigquery-platform-integration.png" />

4. Open the Service Account key file from step 1.4, copy its content and paste it under the **BigQuery Service Account JSON key** field

<img src="https://mintcdn.com/hunch-ac9ddd82/HjVSL8mgxMQv8Txo/public/images/bigquery-integration/bigquery-platform-form.png?fit=max&auto=format&n=HjVSL8mgxMQv8Txo&q=85&s=f15b65dcf77ed5ee8ae29ca95f67d37f" alt="BigQuery Credentials Form" className="w-full rounded-lg shadow-lg my-4" width="3592" height="2070" data-path="public/images/bigquery-integration/bigquery-platform-form.png" />

5. Click **Submit**

***

## 🎉 Done! You're now connected

Need help? Ping us at [support@hunch.dev](mailto:support@hunch.dev)

***

## 🔒 Security Note

> Hunch uses Google Service Account keys for secure access to your BigQuery data. Your credentials are encrypted and stored securely, and we only request the minimum permissions needed to access your BigQuery data (BigQuery Data Viewer and BigQuery Job User roles).