Loading

Error "[Simba][JDBC](11640) Required Connection Key(s): AwsRegion" When Connecting to Amazon Athena

Julkaisupäivä: Jan 29, 2025
Kuvaus

Issue

When connecting to Amazon Athena from Tableau Desktop, the following error may occur:

 

An error occurred while communicating with Amazon Athena.

Invalid username or password.

['java.sql.SQLNonTransientConnectionException: [Simba][JDBC](10100) Connection Refused: [Simba][JDBC](11640) Required Connection Key(s): AwsRegion; [Simba][JDBC](11480) Optional Connection Key(s): AwsCredentialsProviderArguments, AwsCredentialsProviderClass, BinaryColumnLength, ComplexTypeColumnLength, ConnectTimeout, MaxCatalogNameLength, MaxColumnNameLength, MaxErrorRetry, MaxSchemaNameLength, MaxStreamErrorRetry, MaxTableNameLength, ProxyHost, ProxyPort, ProxyPWD, ProxyUID, RowsToFetchPerBlock, S3OutputEncOption, S3OutputLocation, Schema, SocketTimeout, StringColumnLength, UseArraySupport, UseAwsLogger, UseResultsetStreaming, Workgroup', 'Invalid username or password.']

 

Cause

The server name was not in the correct format. 

 

Ratkaisu

Ensure that you are using the full and correct server name. The server should be specified as follows: 

athena.[region].amazonaws.com.

 

For example:

athena.us-east-1.amazonaws.com

 

Knowledge-artikkelin numero

001472179

 
Ladataan
Salesforce Help | Article