Configuring Amazon Athena ODBC 2.x connections
You can use an ODBC connection to connect to Amazon Athena from many third-party SQL client tools and applications. You set up the ODBC connection on your client computer.
Considerations and limitations
-
For information on migrating from the Athena ODBC 1.x driver to the Athena 2.x ODBC driver, see Migrating to the ODBC 2.x driver.
-
When using the S3 fetcher with the
CSE_KMSencryption option, the Amazon S3 client can't decrypt the result stored in the Amazon S3 bucket. As a workaround, use the Athena streaming API option to fetch the result set.
ODBC 2.x driver download
To download the Amazon Athena 2.x ODBC driver, visit the links on this page.
Important
When you use the ODBC 2.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:GetQueryResultsStreampolicy 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 Amazon managed policy: AWSQuicksightAthenaAccess.
Linux
| Driver version | Download link |
|---|---|
| ODBC 2.0.3.0 for Linux 64-bit |
Linux 64 bit ODBC driver 2.0.3.0 |
macOS (ARM)
| Driver version | Download link |
|---|---|
| ODBC 2.0.3.0 for macOS 64-bit (ARM) |
macOS 64 bit ODBC driver 2.0.3.0 (ARM) |
macOS (Intel)
| Driver version | Download link |
|---|---|
| ODBC 2.0.3.0 for macOS 64-bit (Intel) |
macOS 64 bit ODBC driver 2.0.3.0 (Intel) |
Windows
| Driver version | Download link |
|---|---|
| ODBC 2.0.3.0 for Windows 64-bit |
Windows 64 bit ODBC driver 2.0.3.0 |