Connecting to Amazon Athena with ODBC - Amazon Athena

Connecting to Amazon Athena with ODBC

Use the links on this page to download the Amazon Athena 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 Access through JDBC and ODBC connections.

Important

When you use the ODBC 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.1.17 for Windows 32-bit Windows 32 bit ODBC driver 1.1.17
ODBC 1.1.17 for Windows 64-bit Windows 64 bit ODBC driver 1.1.17

Linux

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

OSX

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

Documentation

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

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.