KNOWLEDGE BASE

Error "An error occurred while communicating with Amazon Athena. Invalid username or password." When Connecting to Amazon Athena


Published: 05 Jan 2018
Last Modified Date: 18 Sep 2018

Issue

When connecting to Amazon Athena from Tableau Desktop, the following error might occur:
 
An error occurred while communicating with Amazon Athena. Invalid username or password

throw DataSourceException (type=BadPassword): com.tableausoftware.jdbc.TableauJDBCException: Exception while connecting to server.
[Simba][JDBC](10100) Connection Refused: [Simba][JDBC](11640) Required Connection Key(s): AwsRegion, S3OutputLocation; [Simba][JDBC](11480) Optional Connection Key(s): AwsCredentialsProviderArguments, AwsCredentialsProviderClass, BinaryColumnLength, ComplexTypeColumnLength, ConnectTimeout, MaxCatalogNameLength, MaxColumnNameLength, MaxErrorRetry, MaxSchemaNameLength, MaxTableNameLength, ProxyHost, ProxyPort, ProxyPWD, ProxyUID, S3OutputEncOption, Schema, SocketTimeout, StringColumnLength, UseAwsLogger

There was a Java error.

Invalid username or password.

 
 

Environment

  • Tableau Desktop 10.3 and later
  • Tableau Server
  • Amazon Athena

Resolution

Downgrade the Amazon Athena JDBC driver to a previous version.

  1. Go to the "Using Athena with the Previous Version of the JDBC Driver" page on the Amazon website.
  2. Download AthenaJDBC41-1.0.1.jar.
  3. Save the driver at the following locations:
Windows: Save the Amazon Athena JDBC jar in the C:\Program Files\Tableau\Drivers location.
Mac: Save the Amazon Athena JDBC jar in the ~/Library/Tableau/Drivers location.

Cause

The latest Amazon Athena JDBC driver (1.0.1.1001) changes the connect string, preventing Tableau from making the connection to Amazon Athena.
Did this article resolve the issue?