---
schema_version: "1"
id: 5d7561b6d14844c948e7d050d170508114a2a82cea0e51bba7d90aec8acca519
title: Google BigQuery JDBC
collection: tableau
version: next
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/next/en-gb/pro/desktop/examples_googlebigquery_jdbc.md
canonical_url: https://help.tableau.com/v0.0/pro/desktop/en-gb/examples_googlebigquery_jdbc.htm
source_site: help.tableau.com
content_type: documentation
content_hash: a1d952740725e16ad6cdcf2c133edcb8ab4542128e542c04dae94293e574a216
description: Connect Tableau Desktop and Tableau Cloud to Google BigQuery using the JDBC connector.
---
[Skip to main content](#main-content)

# Google BigQuery JDBC

This article describes how to connect Tableau Desktop and Tableau Cloud to Google BigQuery (JDBC).

## Before you begin

Before you begin, gather this connection information.

- Google BigQuery billing project ID (Case Sensitive).
- Google BigQuery Permissions:
    - If you are using storage API to improve performance, the user account must have `bigquery.readsessions.getData` permission.
    - If you are querying large tables (10 GB, for example), the user account must have `bigquery.readsessions.create` permission.

## Driver required

This connector requires a driver to talk to the database. If the driver isn’t installed on your computer, Tableau displays a message in the connection dialog box with a link to the [Driver Download](https://www.tableau.com/en-gb/support/drivers?_ga=2.201087918.1238604288.1679430176-92598674.1667837264) (Link opens in a new window) page where you can find driver links and installation instructions.

## Make the connection in Tableau Desktop

In Tableau Desktop, you can use 2 authentication methods with the Google BigQuery connector. You can sign in using a Service Account or using OAuth.

#### Complete the following steps to sign in using a service account.

1. Start Tableau and under **Connect**, select **Google BigQuery JDBC**.
2. Enter the **Billing Project ID**. Ensure that you’re using the Google Cloud billing project ID, not the billing project name.
3. In **Authentication**, select **Sign In using Service Account (JSON) file**.
4. Enter the file path or use the **Browse** button to search for it.
5. (Optional) Go to the **Advanced** tab.
6. On the **Advanced** tab, select **Use Storage API**, to get faster extracts.
7. Unselect the **Enumerate All Projects** option to help increase processing times.
8. After you make changes, choose **Sign In.**
9. Enter your password to continue.
10. Select **Accept** to allow Tableau to access your Google BigQuery data. You’re then prompted to close the browser. After authentication, Tableau creates a workbook using the Billing Project ID you provided.

#### Complete the following steps to sign in using OAuth.

1. Start **Tableau** and under **Connect**, select **Google BigQuery JDBC**.
2. Enter the Billing Project ID. Ensure that you’re using the Google Cloud billing project ID, not the billing project name.
3. In **Authentication**, select **Sign in using OAuth**.
4. (Optional) Go to the **Advanced** tab.
5. On the **Advanced** tab, select **Use Storage API**, to get faster extracts.
6. Unselect the **Enumerate All Projects** option to help increase processing times.
7. Choose **Sign In**.
8. Select the account with your data in it.
9. Select **Continue** to allow Tableau to access your Google BigQuery data. After authentication, Tableau creates a workbook using the Billing Project ID you provided.

## Make the connection in Tableau Cloud

In Tableau Cloud, you can use OAuth authentication methods with the Google BigQuery connector.

1. Start Tableau and under **Connect**, select **Google BigQuery JDBC**.
2. Enter the Billing Project ID. Ensure that you’re using the Google Cloud billing project ID, not the billing project name.
3. In **Authentication**, select Sign in using OAuth.
4. (Optional) Go to the **Advanced** tab.
5. On the **Advanced** tab, select **Use Storage API**, to get faster extracts.
6. Unselect the **Enumerate All Projects** option to help increase processing times.
7. Choose **Sign In**.
8. Select the account with your data in it.
9. Select **Continue** to allow Tableau to access your Google BigQuery data. After authentication, Tableau creates a workbook using the Billing Project ID you provided.

## Migrating existing workbooks

To migrate workbooks from the Google BigQuery API connector to the JDBC connector you must manually change the data source to Google BigQuery (JDBC) and republish it.