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.

gefragt vor 2 Jahren520 Aufrufe
1 Antwort
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
beantwortet vor 2 Jahren
  • 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.

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen