KNOWLEDGE BASE

Tableau Server on Linux cannot connect to AWS Athena


Published: 28 Jan 2022
Last Modified Date: 30 Jan 2022

Issue

Unable to connect to Amazon Athena on Linux host OS.

If you download and use the JDBC Driver without SDK you will not be able to connect successfully.
There are multiple errors, but you will most likely encounter:
 
'com.tableausoftware.jdbc.SQLExceptionWithDriverInfo: [Simba][AthenaJDBC](100211) Missing credentials error: Either UID/PWD or AwsCredentialsProviderClass must be provided.'

Environment

  • Tableau Server 2021.x.x+
  • Ubuntu 18.04 LTS
  • Amazon Athena

Resolution

Download and use the JDBC Driver with SDK.

Cause

Currently, it is required to use the JDBC Driver with SDK available on the Amazon AWS Help Documentation. (Link below).
Did this article resolve the issue?