Tableau

DataCamp Data Connector makes it easy to analyze your data in Tableau. All you need to do is set up a connection using the Tableau Athena Connector and configure it using configure it using the credentials you can retrieve in the Groups tab.

Complete these two steps to view your learning data in Power BI.

  1. Install the ODBC driver

  2. Set up the Athena connector in Tableau

Install the ODBC driver

Download and install the Tableau Amazon Athena driver. You can download the official driver from the Tableau website: https://www.tableau.com/support/drivers

If you are having trouble getting the driver installed as described on the Tableau website, try placing the .jar file in the ~Users/{yourusername}/Library/Tableau/Drivers where {yourusername} is the name of your profile on your workstation.

Set up the Athena connector in Tableau

Step 1: Quit and re-open Tableau

Step 2: Set up the connection in Tableau

First, make sure you have collected your credentials.

Under Connect, select Amazon Athena and enter the following data:

  1. Server name: athena.us-east-1.amazonaws.com

  2. Port: 443

  3. S3 Staging directory: s3://{bucketname}/tmp-tableau → replace {bucketname} with the S3 Bucket Name from your credentials

  4. AWS access Key ID: the AWS Access Key ID from your credentials

  5. AWS secret access key: the AWS Secret Access Key from your credentials

You can leave the Initial SQL tab untouched

Click the Sign in button

Resources

PreviousMicrosoft Power BINextLooker

Last updated