> For the complete documentation index, see [llms.txt](https://docs.plock.io/plock-overview/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.plock.io/plock-overview/guides/connect-your-data-sources/google-bigquery.md).

# Google BigQuery

This page describes detailed instructions on how to set up and connect plock.io with your BigQuery

To set up BigQuery as a source, first follow these steps:

1. Go to the Google Cloud Console, select the project containing your database and navigate to the **IAM & Admin** tab.
2. Go to the **Service Accounts** menu.
3. Click **+ CREATE SERVICE ACCOUNT**.
4. Choose a name and ID for your service account and click **CREATE AND CONTINUE**.

<figure><img src="https://957064540-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmqcvOUj7ltrnOhtw7UFd%2Fuploads%2F9hV6oMqeN4zwo8zF4odp%2FScreenshot%202024-05-07%20at%2013.11.51.png?alt=media&amp;token=3353b97c-846e-4264-9605-f15f457c856d" alt=""><figcaption></figcaption></figure>

5. Add the two roles **BigQuery Data Viewer** and **BigQuery Job User**:

<figure><img src="https://957064540-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FmqcvOUj7ltrnOhtw7UFd%2Fuploads%2F99EQAJoGqRCbG2Ytv1eI%2FScreenshot%202024-05-07%20at%2013.10.40.png?alt=media&amp;token=24cc8041-e3b4-4a84-a9c2-6ccf1ddafc14" alt=""><figcaption></figcaption></figure>

6. Click **DONE** to set up the Service Account.
7. Click your newly created Service Account, got to the **Keys** tab and click **Add Key** and choose **Create new key**. Choose **JSON** and click **Create**.