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.

Abdoulaye

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/AthenaJDBC42-2.1.5.1001.jar

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.