Download the JDBC driver from AWS and place it in
the DataGrip JDBC driver directory. On Linux this was
File > Data Sources to open the Data Sources panel and click ‘+ > Driver’. Name it AWS Athena. Here’s the confusing bit: skip
down to Additional Files and click
+ and find the location of your driver. Now back up above that select the driver
Okay so you now have the JDBC driver installed, so you need to create a connection to your Athena instance.
File > Data Sources to open the Data Sources panel and click
+ > AWS Athena to create a new connection using the driver.
Enter the access key and secret in the
Password fields respectively.
Set the URL to
jdbc:awsathena://athena.ap-YOURREGION.amazonws.com:443/ with your region string in there.
Advanced and set the two required keys,
S3OutputLocation. The region should be the same
as you used above.
S3OutputLocation is available in the AWS Console for Athena by clicking
Test and you should get Success. You can now use Athena in DataGrip.
Subscribe to this blog via RSS.