Connecting to Amazon Athena with ODBC - Amazon Athena

Connecting to Amazon Athena with ODBC

Download the Amazon Athena ODBC driver License Agreement, ODBC drivers, and ODBC documentation using the following links. For permissions information, see Access through JDBC and ODBC Connections.

Amazon Athena ODBC Driver License Agreement

License Agreement

Windows

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

Linux

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

OSX

Driver Version Download Link
ODBC 1.1.9.1001 for OSX OSX ODBC Driver 1.1.9.1001

Documentation

Driver Version Download Link
Documentation for ODBC 1.1.9.1001 ODBC Driver Installation and Configuration Guide version 1.1.9.1001
Release Notes for ODBC 1.1.9.1001 ODBC Driver Release Notes version 1.1.9.1001

Migration from the Previous Version of the ODBC Driver

The current ODBC driver version 1.1.9.1001 is a drop-in replacement of the previous version of the ODBC driver version 1.0.5. It is also backward compatible with the ODBC driver version 1.0.3, if you use the following required steps to make sure that the driver runs.

Important

To use the ODBC driver versions 1.0.3 and greater, follow these requirements:

  • Keep port 444, which Athena uses to stream query results, open to outbound traffic. When you use a PrivateLink endpoint to connect to Athena, ensure that the security group attached to the PrivateLink endpoint is open to inbound traffic on port 444.

  • Add the athena:GetQueryResultsStream policy action to the list of policies for Athena. This policy action is not exposed directly with the API operation, and is used only 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 1.0.5 Download Link
ODBC 1.0.5 for Windows 32-bit Windows 32 bit ODBC Driver 1.0.5
ODBC 1.0.5 for Windows 64-bit Windows 64 bit ODBC Driver 1.0.5
ODBC 1.0.5 for Linux 32-bit Linux 32 bit ODBC Driver 1.0.5
ODBC 1.0.5 for Linux 64-bit Linux 64 bit ODBC Driver 1.0.5
ODBC 1.0.5 for OSX OSX ODBC Driver 1.0.5
Documentation for ODBC 1.0.5 ODBC Driver Installation and Configuration Guide version 1.0.5
Driver Version 1.0.4 Download Link
ODBC 1.0.4 for Windows 32-bit Windows 32 bit ODBC Driver 1.0.4
ODBC 1.0.4 for Windows 64-bit Windows 64 bit ODBC Driver 1.0.4
ODBC 1.0.4 for Linux 32-bit Linux 32 bit ODBC Driver 1.0.4
ODBC 1.0.4 for Linux 64-bit Linux 64 bit ODBC Driver 1.0.4
ODBC 1.0.4 for OSX OSX ODBC Driver 1.0.4
Documentation for ODBC 1.0.4 ODBC Driver Installation and Configuration Guide version 1.0.4
Driver Version 1.0.3 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
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
ODBC 1.0.3 for OSX OSX ODBC Driver 1.0
Documentation for ODBC 1.0.3 ODBC Driver Installation and Configuration Guide version 1.0.3
Driver Version 1.0.2 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