Survey banner
Switching to Dataiku - a new area to help users who are transitioning from other tools and diving into Dataiku! CHECK IT OUT

How to setup Athena connection using s3 connection

Solved!
abdoulaye
Level 3
How to setup Athena connection using s3 connection

 

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. 

Screenshot 2024-05-06 at 16.36.52.png

0 Kudos
1 Solution
abdoulaye
Level 3
Author
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... 

 

View solution in original post

0 Kudos
3 Replies
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

 

0 Kudos
abdoulaye
Level 3
Author

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

0 Kudos
abdoulaye
Level 3
Author
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... 

 

0 Kudos

Labels

?
Labels (1)

Setup info

?
A banner prompting to get Dataiku