In your community

1. In your community, login to Control and navigate to Integrations > Apps > BI Tools Connector
2. Go to the Installation tab to get your Amazon Web Services (AWS) access keys (access key ID and secret access key) that you will need to set up the connection
3. Click on the Install button 

   The secret access key will not be shown again after you leave that page. Make sure you copy and store the secret access key. Keep your credentials secure. Publicly exposing your credentials can result in your account being compromised.

Tableau Online App

1. Go and log into your Tableau online app
2. Click on explore on the left sidebar
3. Click on New and select Project:
4. Add a title and a description then click on Create:
5. Once the project is created, click on it:
6. Click New, and select New virtual connection:
7. Then search for Amazon Athena and select it:
8. You will get to the connection setup page:

9. Provide the following inputs: 

   • Server: athena.{REGION}.amazonaws.com:443;Workgroup={COMMUNITY_ID};MetadataRetrievalMethod=Query;S3OutputEncOption=SSE_S3;

   • Port: 443

   • S3 Staging Directory:  s3://production-bi-connector-query-results-{REGION}/{COMMUNITY_ID}/

   • Authentication: Username and Password

     • Access Key ID: Access Key ID that you got when Installing BI connector

     • Secret Access Key: The secret Access Key that you got when Installing BI connector

       Note, REGION can be eu-west-1 or us-west-2 depending on the region of your community.

10. Then click on Sign-in.

11. Select AwsDataCatalog as Database, and select and add all tables. You should see them on the right panel, without success to display the data: 

12. To be able to preview data you need then to edit your connection:

13. Change the server value to this one:

• athena.{REGION}.amazonaws.com:443;Workgroup={COMMUNITY_ID};MetadataRetrievalMethod=ProxyApi;S3OutputEncOption=SSE_S3;

and Sign in:

Now you are setup to visualize the data: