Setting up an AWS Athena datasource in Jetbrains DataGrip

Friday 29 June, 2018 | By: Simon Rumble

Download the JDBC driver from AWS and place it in the DataGrip JDBC driver directory. On Linux this was ~/.DataGrip2018.1/config/jdbc-drivers/.

Install Athena JDBC driver

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 Class com.simba.athena.jdbc.Driver. Click OK.

Okay so you now have the JDBC driver installed, so you need to create a connection to your Athena instance.

Create a connection for Athena 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 User and Password fields respectively.

Set the URL to jdbc:awsathena://athena.ap-YOURREGION.amazonws.com:443/ with your region string in there.

Create a connection for Athena Now click Advanced and set the two required keys, AwsRegion and S3OutputLocation. The region should be the same as you used above.

Create a connection for Athena S3OutputLocation is available in the AWS Console for Athena by clicking Settings.

Now click Test and you should get Success. You can now use Athena in DataGrip.

About

We exist to make organisations better understand their businesses by enabling all decision makers in a company to work with the same version of the truth.

Social Links