Google BigQuery JDBC

Applies to: Tableau Cloud, Tableau Desktop, Tableau Prep, Tableau Server

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).

Tip: If you're using storage API to improve performance, the user account must have bigquery.readsessions.getData in their permissions.

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 (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.

Back to top
Thanks for your feedback!Your feedback has been successfully submitted. Thank you!