# Google BigQuery (Service Account)

*BigQuery (Service User) support is currently **in beta**. Please raise any issues you encounter via the chat bubble in the bottom-right of the site, and we'll be happy to help.*

***

### Overview

Our BigQuery integration allows you to import your data, allowing you to clean and transform your data as well as ask it questions via Chat Explore. 

This connection uses a Google Cloud *service account*. You will need access to IAM within your Google Cloud project.

{% hint style="danger" %}
You must allow network traffic from the public IP address `54.197.189.139` in order to allow Akkio to access your data.
{% endhint %}

### Create a Service Account

Click on this link to go to Google Cloud's service accounts page: <https://console.cloud.google.com/iam-admin/serviceaccounts>

If necessary, click on "CREATE SERVICE ACCOUNT" and set up a user.&#x20;

<figure><img src="/files/61PXxDVjAIIiEPixUZ6o" alt=""><figcaption></figcaption></figure>

You must assign a Role to the user that has at least the following IAM Permissions: **BigQuery Data Editor**, **BigQuery Job User, BigQuery Read Session User**\
\
You may use an existing role or create a new one. For documentation on how to create a Google IAM role, visit <https://cloud.google.com/iam/docs/creating-custom-roles>

### Download Service Account Token

Click on this link to go to Google Cloud's service accounts page: <https://console.cloud.google.com/iam-admin/serviceaccounts>

Click the 3 dots next to your service account and select Manage keys

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

Click the Add Key button and select "Create new key"

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

Choose JSON. Clicking "Create" will download the JSON token

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

### Importing Data into Akkio

To import data, first create a new project.

<figure><img src="/files/0q2MV0wuV2PR99eQLu5v" alt=""><figcaption></figcaption></figure>

Select the Google BigQuery Service Account button.

<figure><img src="/files/sxoCyGi5TQ6UD2lvDbBx" alt="" width="368"><figcaption></figcaption></figure>

Name your connection (like "My BigQuery Connection") and upload the JSON key you downloaded

<figure><img src="/files/1oHHwwPgk33K0q4HcMgZ" alt=""><figcaption></figcaption></figure>

Enter your BigQuery's dataset and table name information

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

Your data will begin to load

<figure><img src="/files/6jS2OR9EXgtB9PhdePzt" alt=""><figcaption></figcaption></figure>

After a dataset is connected, the Flow will look the same as usual; you can merge with another dataset, modify using [Chat Data Prep](https://app.gitbook.com/o/-MUk5bRiktgkKBJI46_9/s/-MUiovvmaDi_ad2DYdZ4/building-a-model/selecting-model-data/chat-data-prep), or make a prediction.


---

# 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://docs.akkio.com/akkio-docs/integrations/google-bigquery-service-account.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.