Datagrip athena how to#

Since the driver is now configured, you can go to the “+” sign at the top left of the Data Sources and Drivers window and select “ Athena” as a driver. Click on the “+” button under the URL templates section and add a new entry named default with the value:

In order for the IDE to connect to Athena, we can also define a connection URL template. In the Dialect drop-down, select Generic SQL. New options should now be available under the Class drop-down, select “ 42.Driver” from it. Once you downloaded the driver, go back to the IDE, and in the Additional files section, click on “+” and add the file we’ve just downloaded. As our IDEs work on JDK 8, you can download the corresponding jar file, at the time of writing is “ AthenaJDBC42-2.0.2.jar”. Here you can import custom JDBC drivers to expand the IDE connectivity capabilities.ĪWS provides a JDBC driver for use with Java, which you can download from this page.

You will notice that there is a section called Driver files. Start by changing the name of the configuration to “ Athena”. Head towards the Database Tool Window, then select Data Source Properties, click on the “+” button and then, at the bottom of the list you’ll see an entry named Driver, click on this. To do this, we’ll first need to do some configuration to connect the IDE with Athena.

Datagrip athena how to#

So how to access this data straight from the IDE? Amazon offers Athena, a service built on Presto, and allows you to query this S3 data using ANSI SQL syntax.

If you use the AWS cloud, then you probably store data on their S3 platform, either for your application data or in the form of logs from services like the AWS Elastic Load Balancing.