# Connecting BigQuery

{% stepper %}
{% step %}

### Click +Add under integrations

Click the **Add** button and select BigQuery.

<figure><img src="https://1184501161-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLLMBTNtAM53TC60IKAS%2Fuploads%2Fjz4LZL69d9P8ipycitBt%2FScreenshot%202025-10-27%20at%2011.30.37%E2%80%AFAM.png?alt=media&#x26;token=6f8de1f0-774b-4a0e-b485-eb94c3997f41" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1184501161-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLLMBTNtAM53TC60IKAS%2Fuploads%2F74E0Jrp9CipWZfmHsh7F%2FScreenshot%202025-10-27%20at%2011.29.53%E2%80%AFAM.png?alt=media&#x26;token=da6cdc27-f51f-4b44-84fa-795702753a4b" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

### Create a Google Cloud Service Account <a href="#input-a-connection-name-and-your-snowflake-account-id" id="input-a-connection-name-and-your-snowflake-account-id"></a>

Go to the IAM & Admin section of Google Cloud

<figure><img src="https://1184501161-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLLMBTNtAM53TC60IKAS%2Fuploads%2Fy9zCG6HkPjBCyvr9VK64%2FScreenshot%202025-10-27%20at%2011.35.22%E2%80%AFAM.png?alt=media&#x26;token=82d18520-6737-4614-be22-a2bf9326524f" alt="" width="563"><figcaption></figcaption></figure>

And go to the Service Users sub-section

<figure><img src="https://1184501161-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLLMBTNtAM53TC60IKAS%2Fuploads%2FzCair8LSCTBL4v6Ur5UL%2FScreenshot%202025-10-27%20at%2011.35.07%E2%80%AFAM.png?alt=media&#x26;token=f4f14db2-089f-4c75-b12f-bfb50c7a81d1" alt="" width="243"><figcaption></figcaption></figure>

Create a new Service Account

<figure><img src="https://1184501161-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLLMBTNtAM53TC60IKAS%2Fuploads%2FhDKMxDv7sTMcagEHIYNX%2FScreenshot%202025-10-27%20at%2011.38.30%E2%80%AFAM.png?alt=media&#x26;token=b6731afd-0a8c-4dac-97fb-41cac2bd600c" alt="" width="563"><figcaption></figcaption></figure>

Add a name that will tell you later what it is and click "Done"

<figure><img src="https://1184501161-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLLMBTNtAM53TC60IKAS%2Fuploads%2FV8EaYK4k8v8e2IjicYwy%2FScreenshot%202025-10-27%20at%2011.45.53%E2%80%AFAM.png?alt=media&#x26;token=76eb8dcd-ce7f-4edd-b189-fd9b08aecf6e" alt="" width="563"><figcaption></figcaption></figure>

Add Permissions

<figure><img src="https://1184501161-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLLMBTNtAM53TC60IKAS%2Fuploads%2FAeTnnGozaZhezxKDqBiZ%2FScreenshot%202025-10-27%20at%2011.36.50%E2%80%AFAM.png?alt=media&#x26;token=81f5e132-9584-4903-ad9a-efecaf476af5" alt="" width="563"><figcaption></figcaption></figure>

And create and download a JSON key

<figure><img src="https://1184501161-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLLMBTNtAM53TC60IKAS%2Fuploads%2Fo5NWWctKZpHG9dPLg059%2FScreenshot%202025-10-27%20at%2011.37.46%E2%80%AFAM.png?alt=media&#x26;token=d147c4cb-e058-4a93-8fbc-9cef04ff75b6" alt="" width="375"><figcaption></figcaption></figure>
{% endstep %}

{% step %}

### Gather BigQuery DataSet Information <a href="#input-a-connection-name-and-your-snowflake-account-id" id="input-a-connection-name-and-your-snowflake-account-id"></a>

Go to the BigQuery Console

<figure><img src="https://1184501161-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLLMBTNtAM53TC60IKAS%2Fuploads%2FOrayBmH0YYCn86RGhEtf%2FScreenshot%202025-10-27%20at%2011.49.05%E2%80%AFAM.png?alt=media&#x26;token=92aefd66-d947-4ec2-b910-a7f41899e5a9" alt="" width="375"><figcaption></figcaption></figure>

Select your DataSet and copy the ID of it

<figure><img src="https://1184501161-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLLMBTNtAM53TC60IKAS%2Fuploads%2FOB6VjWLLqGDQuRKojYfy%2FScreenshot%202025-10-27%20at%2011.50.22%E2%80%AFAM.png?alt=media&#x26;token=f89aafb4-ece1-4721-afa9-abc03e92d513" alt="" width="375"><figcaption></figcaption></figure>

The ID is in the format of \[PROJECT\_ID].\[DATASET\_ID]
{% endstep %}

{% step %}

### Add Information to Alkemi <a href="#input-a-connection-name-and-your-snowflake-account-id" id="input-a-connection-name-and-your-snowflake-account-id"></a>

Use the first part of the DataSet ID, separated by a dot, as the Project ID. The second part is the Dataset ID. And copy in the contents of the JSON file for the secret key.

<figure><img src="https://1184501161-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FyLLMBTNtAM53TC60IKAS%2Fuploads%2FBvp4tOsAMVABTRNlUmSE%2FScreenshot%202025-10-27%20at%2011.53.17%E2%80%AFAM.png?alt=media&#x26;token=ee55e971-37de-4023-808a-4771c717aa03" alt="" width="375"><figcaption></figcaption></figure>
{% endstep %}

{% step %}

### Test and Save your connection <a href="#test-and-save-your-connection" id="test-and-save-your-connection"></a>

Click Test Connection and resolve any issues before clicking Save Connection
{% endstep %}

{% step %}

### Start creating data products! <a href="#start-creating-data-products" id="start-creating-data-products"></a>

Explore the creation of data products in DataLab for generating text-to-SQL queries on your BigQuery datasets. Enable MCP connections to integrate your data with chat clients like Claude, Cursor, and ChatGPT. For further information, refer to "Creating a Data Product.
{% endstep %}
{% endstepper %}

[<br>](https://open-2v.gitbook.com/url/preview/site_ybgqm/documentation/~/revisions/qNEJ8ULA5Br3aoLGqIDl/getting-started/connect-your-data/connecting-databricks)<br>