> For the complete documentation index, see [llms.txt](https://docs.alkemi.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.alkemi.ai/documentation/getting-started/connect-your-data/connecting-bigquery.md).

# Connecting BigQuery

Learn how to connect your Google BigQuery Dataset to the Alkemi platform. Once connected, you can create and manage Data Products within Alkemi using your Google BigQuery Dataset as the data source.

{% 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&amp;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&amp;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&amp;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&amp;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&amp;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&amp;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&amp;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&amp;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&amp;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&amp;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&amp;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>