Athena ODBC 1.x driver - Amazon Athena
WindowsLinuxOSXDocumentationODBC driver notes

Athena ODBC 1.x driver

You can use an ODBC connection to connect to Athena from third-party SQL client tools and applications. Use the links on this page to download the Amazon Athena 1.x ODBC driver License Agreement, ODBC drivers, and ODBC documentation. For information about the ODBC connection string, see the ODBC Driver Installation and Configuration Guide PDF file, downloadable from this page. For permissions information, see Control access through JDBC and ODBC connections.

Important

When you use the ODBC 1.x driver, be sure to note the following requirements:

  • Open port 444 – 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.

  • athena:GetQueryResultsStream policy – Add the athena:GetQueryResultsStream policy action to the IAM principals that use the ODBC driver. This policy action is not exposed directly with the API. It is used only with the ODBC and JDBC drivers as part of streaming results support. For an example policy, see AWS managed policy: AWSQuicksightAthenaAccess.

Windows

Driver version Download link
ODBC 1.2.3.1000 for Windows 32-bit Windows 32 bit ODBC driver 1.2.3.1000
ODBC 1.2.3.1000 for Windows 64-bit Windows 64 bit ODBC driver 1.2.3.1000

Linux

Driver version Download link
ODBC 1.2.3.1000 for Linux 32-bit Linux 32 bit ODBC driver 1.2.3.1000
ODBC 1.2.3.1000 for Linux 64-bit Linux 64 bit ODBC driver 1.2.3.1000

OSX

Driver version Download link
ODBC 1.2.3.1000 for OSX OSX ODBC driver 1.2.3.1000

Documentation

Content Documentation link
Amazon Athena ODBC driver license agreement License agreement
Documentation for ODBC 1.2.3.1000 ODBC driver installation and configuration guide version 1.2.3.1000
Release Notes for ODBC 1.2.3.1000 ODBC driver release notes version 1.2.3.1000

ODBC driver notes

Connecting Without Using a Proxy

If you want to specify certain hosts that the driver connects to without using a proxy, you can use the optional NonProxyHost property in your ODBC connection string.

The NonProxyHost property specifies a comma-separated list of hosts that the connector can access without going through the proxy server when a proxy connection is enabled, as in the following example:

.amazonaws.com,localhost,.example.net,.example.com

The NonProxyHost connection parameter is passed to the CURLOPT_NOPROXY curl option. For information about the CURLOPT_NOPROXY format, see CURLOPT_NOPROXY in the curl documentation.