Amazon Athena
User Guide

Using Athena with the JDBC Driver

You can use a JDBC connection to connect Athena to business intelligence tools and other applications, such as SQL Workbench. To do this, download, install, and configure the Athena JDBC driver, using the following links on Amazon S3.

Links for Downloading the JDBC Driver

The JDBC driver version 2.0.5 complies with the JDBC API 4.1 and 4.2 data standards. Before downloading the driver, check which version of Java Runtime Environment (JRE) you use. The JRE version depends on the version of the JDBC API you are using with the driver. If you are not sure, download the latest version of the driver.

Download the driver that matches your version of the JDK and the JDBC data standards:

JDBC Driver Release Notes, License Agreement, and Notices

After you download the version you need, read the release notes, and review the License Agreement and Notices.

Now you are ready to migrate from the previous version and install and configure this version of the JDBC driver.

JDBC Driver Documentation

Download the following documentation for the driver:

Migration from Previous Version of the JDBC Driver

The current JDBC driver version 2.0.5 is a drop-in replacement of the previous version of the JDBC driver version 2.0.2, and is backwards compatible with the JDBC driver version 2.0.2, with the following step that you must perform to ensure the driver runs.

Important

To ensure that you can use the JDBC driver version 2.0.5, add the athena:GetQueryResultsStream policy action to the list of policies for Athena. This policy action is not exposed directly with the API and is only used with the JDBC driver, as part of streaming results support. For an example policy, see AWSQuicksightAthenaAccess Managed Policy. For more information about upgrading to version 2.0.5 from version 2.0.2, see the JDBC Driver Migration Guide. Additionally, ensure that port 444 is open to outbound traffic.

For more information about the previous versions of the JDBC driver, see Using the Previous Version of the JDBC Driver.

If you are migrating from a 1.x driver to a 2.x driver, you will need to migrate your existing configurations to the new configuration. We highly recommend that you migrate to the driver version 2.x. For information, see the JDBC Driver Migration Guide.