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
-
Sign in to Tableau desktop. You will reach the home page of the Tableau User Interface.
-
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
. Locate Google BigQuery in the list and click on it. Use this native connector in Tableau to connect to your data.Connect > To a server > More
-
In Authentication, select 'Sign In using OAuth'. Click Sign In.
-
Choose the account that has access to the required BigQuery data.
-
Enter your password and click on Next.
-
Click on Allow to allow Tableau to access your Google BigQuery data.
-
On the data source page, select the billing project (optional), project and dataset that you want to access.
-
From the list of tables, drag and drop the required tables into the canvas.
-
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.
-
You will be able to see your data that has been pulled from Google BigQuery to Tableau.
-
Select the sheet tab to start your analysis.
-
You can read more about connecting Google BigQuery to Tableau here.
Finding your DataChannel managed BigQuery Warehouse details
-
Login to the DataChannel Console.
-
Access the Data Warehouse page by clicking on the Data Warehouse Tab on the sidebar.
-
Click on the card of the data warehouse that you want to connect to Tableau.
-
The following screen would show up. All the required details will be available in the form that opens up.
![dc managed bigquery 2](../_images/dc-managed-bigquery-2.png)
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.