I have the driver from https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html and am able to connect via pycharm without a problem.
I tried setting up a generic jdbc connection, but am not sure where to put connection parameters such as:
Hello,This is the way that I connected to Athena using a generic jdbc connection.
Here is an example of the url that I used. jdbc:awsathena://AwsRegion=us-east-2;User=TOMUSER;Password=TOMPASSWORD;S3OutputLocation=s3://toms3location/external/Give that a try.Thanks,Tom
Hi, I have found that the method above does trigger an Athena query and does write out the results to the S3OutputLocation but does not return those results to Aquafold Data Studio. The Aquafold query window simply spins until a timeout condition is reached.
I am not that familiar with Athena since we don't support it yet. In the AWS console, I had to add a result set bucket in s3 to hold query results and so maybe the same is true for you. Perhaps that is why it is just spinning. That suggests that ADS Generic JDBC has some limitations with Athena.
Powered by IDERA