Amazon Athena
User Guide

Connecting to Amazon Athena with ODBC

Download the ODBC driver, the Amazon Athena ODBC driver License Agreement, and the documentation for the driver using the following links.

Amazon Athena ODBC Driver License Agreement

License Agreement

Windows

Driver Version Download Link
ODBC 1.0.3 for Windows 32-bit Windows 32 bit ODBC Driver 1.0.3
ODBC 1.0.3 for Windows 64-bit Windows 64 bit ODBC Driver 1.0.3

Linux

Driver Version Download Link
ODBC 1.0.3 for Linux 32-bit Linux 32 bit ODBC Driver 1.0.3
ODBC 1.0.3 for Linux 64-bit Linux 64 bit ODBC Driver 1.0.3

OSX

Driver Version Download Link
ODBC 1.0.3 for OSX OSX ODBC Driver 1.0.3

ODBC Driver Documentation

Driver Version Download Link
Documentation for ODBC 1.0.3 ODBC Driver Installation and Configuration Guide version 1.0.3

Migration from the Previous Version of the ODBC Driver

The current ODBC driver version 1.0.3 is a drop-in replacement of the previous version of the ODBC driver version 1.0.2, and is backwards compatible with the ODBC driver version 1.0.2, with the following steps that you must perform to ensure the driver runs.

Important

To use the ODBC driver version 1.0.3, follow these requirements:

  • Keep the port 444 open to outbound traffic.

  • 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 ODBC and JDBC drivers, as part of streaming results support. For an example policy, see AWSQuicksightAthenaAccess Managed Policy.

Previous Versions of the ODBC Driver

Driver Version Download Link
ODBC 1.0.2 for Windows 32-bit Windows 32-bit ODBC Driver 1.0.2
ODBC 1.0.2 for Windows 64-bit Windows 64-bit ODBC Driver 1.0.2
ODBC 1.0.2 for Linux 32-bit Linux 32-bit ODBC Driver 1.0.2
ODBC 1.0.2 for Linux 64-bit Linux 64-bit ODBC Driver 1.0.2
ODBC 1.0 for OSX OSX ODBC Driver 1.0
Documentation for ODBC 1.0.2 ODBC Driver Installation and Configuration Guide version 1.0.2