Amazon Athena ODBC 2.x release notes

Added MFA support for the Okta authentication plugin on Linux and Mac platforms.

Both the athena-odbc.dll library and the AmazonAthenaODBC-2.x.x.x.msi installer for Windows are now signed.

Updated the CA certificate cacert.pem file that is installed with the driver.

Improved the time required to list tables under Lambda catalogs. For LAMBDA catalog types, the ODBC driver can now submit a SHOW TABLES query to get a list of available tables. For more information, see Use query to list tables.

Introduced the UseWCharForStringTypes connection parameter to report string data types using SQL_WCHAR and SQL_WVARCHAR. For more information, see Use WCHAR for string types.

Fixed a registry corruption warning that occurred when the Get-OdbcDsn PowerShell tool was used.

Updated the parsing logic to handle comments at the start of query strings.

Date and timestamp data types now allow zero in the year field.

Added two connection parameters, StringColumnLength and ComplexTypeColumnLength, that you can use to change the default column length for string and complex data types. For more information, see String column length and Complex type column length.

Support has been added for the Linux and macOS (Intel and ARM) operating systems. For more information, see Linux and macOS.

AWS-SDK-CPP has been updated to the 1.11.245 tag version.

The curl library has been updated to the 8.6.0 version.

Resolved an issue that cause incorrect values to be reported in result-set metadata for string-like data types in the precision column.

Improved ODBC driver thread safety for all interfaces.

When logging is enabled, datetime values are now recorded with millisecond precision.

During authentication with the Browser SSO OIDC plugin, the terminal now opens to display the device code to the user.

Resolved a memory release issue that occurred when parsing results from the streaming API.

Requests for the interfaces SQLTablePrivileges(), SQLSpecialColumns(), SQLProcedureColumns(), and SQLProcedures() now return empty result sets.

File cache feature added for the Browser Azure AD, Browser SSO OIDC, and Okta browser-based authentication plugins.

BI Tools like Power BI and browser-based plugins use multiple browser windows. The new file cache connection parameter enables temporary credentials to be cached and reused between the multiple processes opened by BI applications.

Applications can now query information about the result set after a statement is prepared.

Default connection and request timeouts have been increased for use with slower client networks. For more information, see Connection timeout and Request timeout.

Endpoint overrides have been added for SSO and SSO OIDC. For more information, see Endpoint overrides.

Added a connection parameter to pass a URI argument for an authentication request to Ping. You can use this parameter to bypass the Lake Formation single role limitation. For more information, see Ping URI param.

Fixed an integer overflow issue that occurred when using the row-based binding mechanism.

Removed timeout from the list of required connection parameters for the Browser SSO OIDC authentication plugin.

Added missing interfaces for SQLStatistics(), SQLPrimaryKeys(), SQLForeignKeys(), and SQLColumnPrivileges(), and added the ability to return empty result sets upon request.

Added URI logging to the Okta authentication plugin.

Added the preferred role parameter to the external credentials provider plugin.

Adding handling for the profile prefix in the profile name of Amazon configuration file.

Corrected a Amazon Web Services Region use issue that occurred when working with Lake Formation and Amazon STS clients.

Restored missing partition keys to the list of table columns.

Added the missing BrowserSSOOIDC authentication type to the Amazon profile.