Connect Tableau to Amazon Redshift

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

You may send an Apache Parquet, Apache Avro, CSV, or JSON file from Amperity to Amazon S3, load that data to Amazom Redshift, and then connect to that data from Tableau.

What is Amazon Redshift?

Amazon RedShift is a data warehouse located within Amazon Web Services that can handle massive sets of column-oriented data.

Add workflow

Amperity can be configured to send data to Amazon S3, after which Amazon Redshift is configured to load that data from Amazon S3. Tableau can be configured to connect to Amazon Redshift, and use Amperity as a source for data visualizations.

You may use the Amazon S3 bucket that comes with your Amperity tenant for the intermediate step (if your Amperity tenant is running on Amazon AWS). Or you may configure Amperity to send data to an Amazon S3 bucket that your organization manages directly.

Connect Tableau to Amazon Redshift.

To connect Tableau to Amazon Redshift

The steps required to configure Amperity to send data that is accessible to Tableau from Amazon Redshift 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 Amazon S3 from Amperity.

Step 3.

Load data from Amazon S3 to Amazon Redshift.

Step 4.

Connect Tableau to Amazon Redshift , and then access the data sent from Amperity.

Step 5.

Validate the workflow within Amperity and the data within Databricks.

Step 6.

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