Connect Tableau to Google BigQuery

Some organizations choose to store their visualization source data in Google BigQuery, and then connect to Google BigQuery from Tableau.

You may send an Apache Parquet, Apache Avro, CSV, or JSON file from Amperity to Google Cloud Storage, load that data to Google BigQuery, and then connect to that data from Tableau.

What is Google BigQuery?

Google BigQuery is a fully-managed data warehouse that provides scalable, cost-effective, serverless software that can perform fast analysis over petabytes of data and querying using ANSI SQL.

Add workflow

Amperity can be configured to send data to Google Cloud Storage, after which the data can be transferred to Google BigQuery. Tableau can be configured to connect to Google BigQuery and use the Amperity output as a data source.

You must configure Amperity to send data to a Google Cloud Storage bucket that your organization manages directly.

Connect Tableau to Google BigQuery.

To connect Tableau to Google BigQuery

The steps required to configure Amperity to send data that is accessible to Tableau from Google BigQuery requires completion of a series of short workflows, some of which must be done outside of Amperity.

Step 1.

Use a query return the data you want to make available to Tableau for use with data visualizations.
Step 2.

Send an Apache Parquet, Apache Avro, CSV, or JSON file to Google Cloud Storage from Amperity.
Step 3.

Transfer data from Cloud Storage to Google BigQuery.
Step 4.

Connect Tableau to Google BigQuery , and then access the data sent from Amperity.
Step 5.

Validate the workflow within Amperity and the data within Tableau.
Step 6.

Configure Amperity to automate this workflow for a regular (daily) refresh of data.