Amazon Athena JDBC42 driver issue while running queries from Tableau

1

Hi Folks,

I keep getting the following error when trying to run Athena queries from tableau:

ERROR 33 com.simba.athena.exceptions.ExceptionConverter.toSQLException: Error message not found: GENERAL_ERROR_WITH_STREAM_DETAIL. Can't find bundle for base name com.simba.athena.athena.jdbc42.messages, locale en_US java.sql.SQLException: Error message not found: GENERAL_ERROR_WITH_STREAM_DETAIL. Can't find bundle for base name com.simba.athena.athena.jdbc42.messages, locale en_US

Please note, I am able to connect to Athena using my aws access id and secret access key and able to see databases and corresponding objects. The above error only shows up when I try to execute queries from tableau.

I have followed the following steps so far :

  1. I installed java 8 version on the following location C:\Program Files\Java\jre1.8.0_281

  2. Followed this documentation on Athena and downloaded the JDBC driver with sdk in the tableau drivers directory https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html

  3. I created a new user environment variable and system environment variable on my Windows machine Variable name: JAVA_HOME Variable value: C:\Program Files\Java\jre1.8.0_281

On AWS side:

I created a new user using IAM and gave it the following privileges for testing purposes AmazonS3FullAccess AmazonAthenaFullAccess

Thanks in advance for your help.

asked 3 months ago97 views
1 Answer
0

I am running into the same issue, getting a similar error message:

Error message not found: ATHENA_CLIENT_ERROR. Can't find bundle for base name com.simba.athena.athena.jdbc42.messages, locale en_US
Unable to create extract

Working on a Mac (intel chip), and as thread author, completed the driver installation steps as outlined here (https://help.tableau.com/current/pro/desktop/en-us/examples_amazonathena.htm). Successfully able to connect to Athena and enter my custom query, but receiving the above error when trying to create an extract/executing the query.

Any ideas?

Update:

Spotted my error. Missed giving the AWS user S3 and Lambda access.

Chris
answered 3 months ago
  • Thanks for the update. Verified my access as well and S3 access looks good. However, I am curious about lambda access, why would we need it for tableau? Would you be able to share lambda access you provisioned?

  • I gave AWSLambda_FullAccess to the user as well. However, haven't tested if this made the difference. I think the S3 access was missing for me. I would just give it a test and see if it fixes your issue.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions