How do I use Athena drivers to troubleshoot Tableau connectivity?

3 minute read
0

I want to use Amazon Athena drivers to troubleshoot Tableau connectivity.

Resolution

Troubleshoot Tableau connectivity based on the following scenarios:

Driver related issues

If you have driver-related issues, then you might receive the following error or similar:

"The drivers required to connect to the data source are not installed. No Suitable driver Installed. Error code: AA76601F"

This error occurs when you don't use a suitable Athena JDBC driver with the correct location. To resolve this, put the driver at the correct location. To do so, complete the following steps:

  1. Download the latest version of Athena JDBC driver JAR with bundled AWS Software Development Kit (AWS SDK).
  2. Put the Athena JDBC driver in the correct Tableau driver location:
    For Windows, save the Athena JDBC .jar file in the C:\Program Files\Tableau\Drivers location.
    For macOS, save the Athena JDBC .jar file in the ~/Library/Tableau/Drivers location.
    Note: Make sure that you use the correct location for your OS. Also, make sure that you don't add multiple .jar files. Adding multiple .jar files can cause driver-related issues.
  3. Restart Tableau, and then connect to Athena.

Connection timeout issues

If you have connection timeout issues, then you might receive the following error or similar:

"com/amazonaws/ClientConfiguration Unable to connect to the Amazon Athena server athena.us-east-1.amazonaws.com. Check that the server is running and that you have access privileges to the requested database."

This error occurs when there's no connection between the driver on the installed host and Athena. To resolve this, check the following:

  • Make sure that ports 443 and 444 are open. Athena uses port 443 to connect to the host, and Athena's streaming API uses port 444 to stream query results.
  • Make sure that there's endpoint connectivity between the driver on the installed host and Athena. Use the following command to test connectivity to ports 443 and 444 from the host machine of the driver:
    For Windows:
    Note: Replace example-region with the required AWS Region.
    telnet athena.example-region.amazonaws.com 443
    telnet athena.example-region.amazonaws.com 444
    For macOS:
    Note: Replace example-region with the required Region.
    nc -v athena.example-region.amazonaws.com 443
    
    nc -v athena.example-region.amazonaws.com 444
    Note: For the preceding commands, if you use an Amazon Virtual Private Cloud (Amazon VPC) endpoint for private DNS, then add vpce-name to the endpoint. Make sure that you add vpce-name to the beginning of the endpoint.
  • Make sure that you use the correct AWS Identity and Access Management (IAM) user access key ID and secret access key. Also, make sure that you have the required permissions for Amazon Simple Storage Service (Amazon S3), Athena, and AWS Glue.

Debugging query and connection related issues

To turn on Athena JDBC driver logs for Tableau, complete the following steps:

  1. Create the file athena.properties at the location My Tableau Repository/Datasources with the following contents:

    LogLevel=6
    LogPath=D:\\test\
    UseAwsLogger=1
  2. Save the file, and then close Tableau.

  3. Connect to Athena. Log files AthenaJDBC_connection and AthenaJDBC_Driver are located inside the provided location.

AWS OFFICIAL
AWS OFFICIALUpdated 18 days ago