About Amazon Athena ODBC Driver
Use an ODBC connection to connect to Athena from third-party SQL client tools and applications.
Athena ODBC 2.x driver
Use an ODBC connection to connect to Athena from third-party SQL client tools and applications.
This release includes changes made since version 2.2.0.1.
Fixes
- Fixed an issue that caused SQLTables and SQLColumns to omit tables at approximately position 200 and later within a schema. This happened when the driver received two consecutive empty pages while paginating metadata results.
- Fixed an issue that caused empty string filter patterns from ADO.NET applications such as Power BI to return zero rows instead of all rows. The driver now treats an empty string pattern as no restriction, which matches all values.
- Fixed an issue that caused SQLColumns to fail on column types that the driver does not recognize, such as uuid or json. These columns are now reported with the SQL type VARCHAR. The TYPE_NAME column continues to report the Athena type name.
- Fixed an issue that caused connections that use the SageMakerBrowserIdc authentication plugin to stop responding until the identity provider response timeout elapsed when the SSOOIDCEndpointOverride parameter was set.
- Fixed an issue that caused the driver to ignore the SSOEndpointOverride parameter for connections that use the BrowserSSOOIDC authentication plugin.
- Fixed an issue that caused connections through a proxy server to fail with Domain Name System (DNS) resolution errors when the proxy performs DNS resolution. HTTP clients that the AWS SDK creates internally now use the driver's configured proxy settings.
- Fixed an issue that caused Transport Layer Security (TLS) certificate verification to fail on Linux when the TrustedCerts parameter was not set. The driver now locates the CA bundle at runtime and honors the CURL_CA_BUNDLE and SSL_CERT_FILE environment variables. The resolved CA bundle is also applied to HTTP clients that the AWS SDK creates internally.
- Fixed an issue that prevented the Linux driver from installing on distributions with glibc 2.28, including Red Hat Enterprise Linux 8 and Rocky Linux 8. The Linux driver now builds against a glibc 2.28 baseline and requires glibc 2.28 or later. On SUSE Linux Enterprise Server 15, use SP3 or later, which provides a compatible glibc version.
- Fixed an issue that could cause the Linux driver to crash when a host application that had already loaded a different OpenSSL library, such as an R environment, loaded the driver. The driver now restricts its exported symbols to the ODBC API so that its bundled cryptography library is not affected by the host application's OpenSSL. …
| Publisher | Amazon.com Services LLC |
|---|---|
| Author | Amazon Web Services, Inc |
| Version | 2.4.0.0 |
| Release date | 2026-09-28 |
| License | Proprietary |
| Installer type | wix |
| Architecture | x64 |
| Package ID | Amazon.AthenaODBCDriver.2 |
| Install scope | All users |
winget install --id=Amazon.AthenaODBCDriver.2 -ewinget upgrade --id=Amazon.AthenaODBCDriver.2 -ewinget uninstall --id=Amazon.AthenaODBCDriver.2 -emsiexec /i "AmazonAthenaODBC-2.4.0.0-windows-amd64.msi" /quiet /norestartmsiexec /x {F1C0FD8F-4D89-4492-ADE1-18A0D92DB01C} /quietFixes
Note
On Windows, the driver now verifies SSL certificates against the Windows system certificate store and does not use the TrustedCerts parameter.
- Fixed an issue that caused TLS certificate verification to fail on some Linux distributions when the TrustedCerts parameter was not set. The driver now locates the CA bundle at runtime and honors the CURL_CA_BUNDLE and SSL_CERT_FILE environment variables.
- Fixed an issue that caused the driver to send requests to identity providers without a User-Agent header.
Important …
Fixes
- Fixed an issue that caused some browser-based authentication requests to fail because of a missing Content-Length header.
- Fixed an issue that caused query parameters to be truncated when you use SQL_C_WCHAR bindings.
- The license file now includes a reference to the AWS Service Terms.
To download the new ODBC v2 driver, see ODBC 2.x driver download. For connection information, see Amazon Athena ODBC 2.x.
Improvements
- SageMaker authentication – Added support for the SageMaker authentication plugins SageMakerBrowserIdc and SageMakerIam. You can now connect to your SageMaker projects and work with the data from your preferred third-party tool. For more information, see SageMaker Browser IDC and SageMaker IAM.
- Multi-catalog browsing – Added multi-catalog browsing support for lakehouse features. The driver can now discover and connect to all catalogs in federated catalog environments, enabling use of S3 Tables and catalog federation through Amazon Athena.
- macOS universal installer – The macOS driver is now distributed as a single universal binary that supports both ARM and Intel architectures, simplifying installation across all Mac hardware.
- HTTP client migration – Removed the libcurl dependency from ODBC binaries by migrating to the AWS SDK CRT HTTP client. The CRT client uses the platform's native TLS stack and system trust store, improving connection reliability and eliminating transitive dependencies on OpenSSL and zlib.
Fixes
- Added ExternalId support for STS AssumeRole for cross-account role assumption. The ExternalId is read from the AWS profile configuration.
To download the new ODBC v2 driver, see ODBC 2.x driver download. For connection information, see Amazon Athena ODBC 2.x. On Windows, uninstall the previous version before upgrading to 2.2.0.0.
Amazon Athena ODBC Driver is proprietary software from Amazon.com Services LLC. Check the publisher's license terms for pricing and usage rights.
The latest version is 2.4.0.0, released on Sep 28, 2026.
The download button links to the official installer published on aws-analytics-downloads-us-east-1.s3.us-east-1.amazonaws.com, the same file Windows Package Manager installs. You can verify the downloaded file by comparing its SHA-256 checksum with bc23a47c6035d4c06d83c3facb0095add556c6b72be4cf42f01b31b78407dbdc.
Amazon Athena ODBC Driver runs on Windows and is available for 64-bit (x64) systems.
Run the offline installer with msiexec /i "AmazonAthenaODBC-2.4.0.0-windows-amd64.msi" /quiet /norestart, or install it with Windows Package Manager: winget install --id=Amazon.AthenaODBCDriver.2 -e --silent.
Open Settings › Apps › Installed apps, find Amazon Athena ODBC Driver and select Uninstall. From the command line, run winget uninstall --id=Amazon.AthenaODBCDriver.2 -e.