How to integrate my Google Bigquery Warehouse with Tableau?

Introduction

Tableau is a business intelligence (BI) tool, that makes data more accessible and understandable, by means of data visualization in the form of dashboards. The interactive dashboards offered by Tableau enable a better comprehension of data, leading to meaningful insights. This helps businesses leverage the power of data for informed decision-making. Thus, Tableau makes it easy for you to create effective and engaging dashboards, using data from a variety of sources.

In order to link your Google BigQuery Data Warehouse to Tableau, you will need to install Tableau desktop.

Steps to Connect Google BigQuery to Tableau

  1. Sign in to Tableau desktop. You will reach the home page of the Tableau User Interface.

    tableau homepage

  2. In order to connect to a data source use the 'Connect' option on the home screen. You may use the Search Box to search for Google BigQuery. Else, select Connect > To a server > More. Locate Google BigQuery in the list and click on it. Use this native connector in Tableau to connect to your data.

    tableau connect big query

  3. In Authentication, select 'Sign In using OAuth'. Click Sign In.

    tableau big query signin option

  4. Choose the account that has access to the required BigQuery data.

    tableau big query choose account

  5. Enter your password and click on Next.

    tableau big query enter password

  6. Click on Allow to allow Tableau to access your Google BigQuery data.

    tableau big query allow

  7. On the data source page, select the billing project (optional), project and dataset that you want to access.

    tableau big query select project

  8. From the list of tables, drag and drop the required tables into the canvas.

    tableau big query tables list

  9. On your screen, you will be able to view the complete table structure. You can choose to set up a live connection to this dataset, or import an extract so that data from BigQuery will be copied to Tableau. Once finished, click on Update Now to load your data.

    tableau big query update now

  10. You will be able to see your data that has been pulled from Google BigQuery to Tableau.

    tableau bigquery table fields

  11. Select the sheet tab to start your analysis.

    tableau big query build viz

  12. You can read more about connecting Google BigQuery to Tableau here.

Finding your DataChannel managed BigQuery Warehouse details

  1. Login to the DataChannel Console.

  2. Access the Data Warehouse page by clicking on the Data Warehouse Tab on the sidebar.

    dc managed bigquery 1

  3. Click on the card of the data warehouse that you want to connect to Tableau.

  4. The following screen would show up. All the required details will be available in the form that opens up.

dc managed bigquery 2

Still have Questions?

We’ll be happy to help you with any questions you might have! Send us an email at info@datachannel.co.

Subscribe to our Newsletter for latest updates at DataChannel.