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.
Best Answer
-
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 regardsLink to download: https://downloads.athena.us-east-1.amazonaws.com/drivers/JDBC/SimbaAthenaJDBC-2.1.5.1001/AthenaJDBC42-2.1.5.1001.jar
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,418 NeuronThere 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
-
Updated: i use an s3 connection which have athena full access for test. The s3 connection work correctly also and is used.
-
Tanguy Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron, Dataiku DSS Adv Designer, Registered, Dataiku DSS Developer, Neuron 2023 Posts: 135 Neuronhi @Abdoulaye, for which version of DSS were you encountering this issue?
-
Hello, I've solved this bymy self. Thanks
-
If I remember 12.5 or 12.6.