How to setup Athena connection using s3 connection

[abdoulaye]

Hello, i've already setup an s3 connection which is working perfectly. I'd like to use it to setup Athena connection. My s3 connection use sts-assume-role type.

Iuse dataikucloudstacj (aws) Can you tell me why thing do not work? do I need specific policies in roles of s3 and intances profile?

I've this error in screenshots. 

[Turribeach]

There are no screen shots attached to your post. Have you reviewed the Dataiku Athena documentation?

https://doc.dataiku.com/dss/latest/connecting/sql/athena.html

[abdoulaye]

Updated: i use an s3 connection which have athena full access for test. The s3 connection work correctly also and is used.

[abdoulaye · Accepted solution]

The solution

Thanks @Clément_Stenac for support.

Please upgrade to AthenaJDBC42-2.1.5.1001.jar driver (the 1000 is not working).
Very important: please put the jar in a *subfolder* of lib/jdbc, not directly in lib/jdbc, as that would prevent DSS from restarting:

1/ Remove /data/dataiku/dss_data/lib/jdbc/athenaJDBC42-2.1.5.1000.jar
2/ mkdir /data/dataiku/dss_data/lib/jdbc/athena/​
3/ Download the 1001 driver into  /data/dataiku/dss_data/lib/jdbc/athena/
4/ Restart DSS
5/ In the connection, use "lib/jdbc/athena" as the "Jars directory"

Best regards

Link to download: https://downloads.athena.us-east-1.amazonaws.com/drivers/JDBC/SimbaAthenaJDBC-2.1.5.1001/AthenaJDBC4...