1 ATHENA

============================================================================== Simba Athena ODBC Driver with SQL Connector Release Notes ==============================================================================

The release notes provide details of enhancements, features, known issues, and workflow changes in Simba Athena ODBC Driver 1.1.8, as well as the version history.

1.1.8 ========================================================================

Released 2021-02-18

Enhancements & New Features

  • [AO-407] SAML authentication using PingFederate

The driver can now retrieve and use credentials from the PingFederate credential provider. For more information, see the Installation and Configuration Guide.

  • [AO-425] Updated metadata retrieval

The driver now retrieves only the required table and schema metadata from the datasource when the exact names of the table and database are provided.

  • [AO-416] Configure Metadata Retrieval Method on Windows

On Windows, you can now configure the Metadata Retrieval Method by using the ODBC Administrator. For more information, see the Installation and Configuration Guide.

Resolved Issues The following issues have been resolved in Simba Athena ODBC Driver 1.1.8.

  • [AO-423] In some cases, when running a prepare call, the driver includes a semi-colon ( ; ) in the query.

  • [AO-426] In some cases, the driver does not parse multi-line and single-line comments from the query.

Workflow Changes =============================================================

The following changes may disrupt established workflows for the driver.

1.1.7 ------------------------------------------------------------------------

  • [AO-291][AO-340] Removed support for earlier versions of operating systems

Beginning with this release, the driver no longer supports the following operating systems: - macOS 10.9, 10.10, 10.11, and 10.12 - CentOS 6 - Red Hat Enterprise Linux (RHEL) 6

For information about supported operating systems, see the Installation and Configuration Guide.

1.1.2 ------------------------------------------------------------------------

  • [AO-362] Updated MetadataRetrievalMethod property

The default value for the MetadataRetrievalMethod property has been changed to Auto. Previously, the default value was ProxyAPI. For more information, see the Installation and Configuration Guide.

1.0.3 ------------------------------------------------------------------------

  • Result set streaming support

Starting with version 1.0.3, the driver uses the result set streaming API to improve the performance of fetching query results. To take advantage of this feature you must include and allow the athena:GetQueryResultsStream action in your IAM policy statement. For details on managing Athena IAM policies, see https://docs.aws.amazon.com/athena/latest/ug/access.html.

Version History ==============================================================

1.1.7 ------------------------------------------------------------------------

Released 2020-12-31

Enhancements & New Features

  • [AO-410] SAML authentication using Azure

The driver can now retrieve and use credentials from an Azure AD or Browser Azure AD credential provider. For more information, see the Installation and Configuration Guide.

Resolved Issues The following issue has been resolved in Simba Athena ODBC Driver 1.1.7.

  • [AO-355] When the key-value pair of a required setting is missing in odbc.ini, iodbctest terminates unexpectedly.

This issue has been resolved. The driver nows returns a "missing settings" error message.

1.1.6 ------------------------------------------------------------------------

Released 2020-11-20

Enhancements & New Features

  • [AO-305][AO-306][AO-307] New authentication methods

The driver now supports the following authentication methods at the account level: - Okta MFA Verify - SMS Authentication - Google Authenticator

For more information, see the Installation and Configuration Guide.

  • [AO-394] Updated external credential service authentication

The LakeFormationEnabled flag is now supported for external credential service authentication.

Resolved Issues The following issues have been resolved in Simba Athena ODBC Driver 1.1.6.

  • [AO-390] When authenticating through an external credential service, the driver opens multiple windows.

  • [AO-391] When retrieving the schema list, the driver terminates unexpectedly.

1.1.5 ------------------------------------------------------------------------

Released 2020-10-23

Enhancements & New Features

  • [AO-370] Updated logging configurations

You can now configure logging for the current connection by setting the logging configuration properties in the DSN or in a connection string. For more information, see the Installation and Configuration Guide.

  • [AO-377] Updated authentication support

The driver now supports using the credential_process setting in the AWS configuration file for authentication.

  • [AO-383] Preferred role support

You can now configure the preferred role when authenticating with an external credential provider. To do this, type the role in the Preferred Role field (specify the role with the Preferred_Role connection property). For more information, see the Installation and Configuration Guide.

  • [AO-386] Updated metadata support

The driver now retrieves only the required table and schema metadata from the datasource when the exact names of the table and database are provided.

  • [AO-387] Updated OpenSSL support

The driver now uses OpenSSL 1.1.1g for encryption of data. Previously, the driver used OpenSSL 1.1.1d.

Resolved Issues The following issue was resolved in Simba Athena ODBC Driver 1.1.5.

  • [AO-384] When connecting to Athena using a session token generated through the aws-azure-login tool, the driver returns an error.

1.1.3 ------------------------------------------------------------------------

Released 2020-09-25

Enhancements & New Features

  • [AO-354] Retrieving SAML Credentials from Lake Formation service

The driver can now retrieve SAML credentials from Lake Formation service. To do this, set the new LakeFormationEnabled property to true. For more information, see the Installation and Configuration Guide.

1.1.2 ------------------------------------------------------------------------

Released 2020-09-18

Enhancements & New Features

  • [AO-223] External credentials service for Windows

On Windows, you can now authenticate connections using any SAML-based credential provider plugin. For more information, see the Installation and Configuration Guide.

  • [AO-330] Updated AWS library

The driver now uses AWS C++ SDK version 1.7.345. Previously, the driver used AWS C++ SDK version 1.7.230.

Resolved Issues The following issues were resolved in Simba Athena ODBC Driver 1.1.2.

  • [AO-219] The driver does not support moving the cursor by an offset.

This issue has been resolved. The driver now supports the ResultSet.absolute(offset) function in cases where the offset value
moves the cursor. Note that the offset only moves the cursor forward; moving the cursor backwards is not supported. Also, negative values for the offset are not supported.

  • [AO-309] When running SQLPrepare and SQLExecute statements, the driver does not execute DESCRIBE queries.

1.1.1 ------------------------------------------------------------------------

Released 2020-03-31

Enhancements & New Features

  • [AO-268] Custom connector for Power BI

The driver package now includes a custom connector that supports direct querying in Power BI.

  • [AO-294] The driver terminates unexpectedly when both of the following occur:
  • Multiple database drivers are loaded to the same process.
  • One driver unloads and calls ICU's u_cleanup() function, while another driver continues to run and tries to access the memory space that has been cleaned up.

  • [AO-275][AO-293] Updated third-party libraries

The driver now uses the following third-party libraries: - AWS C++ SDK 1.7.230 (previously 1.4.85) - Expat 2.2.9 (previously 2.2.0)

  • [AO-288] Code-signed driver

The Windows and macOS versions of the driver are now code-signed.

Resolved Issues The following issues were resolved in Simba Athena ODBC Driver 1.1.1.

  • [AO-252] On macOS, the driver does not resolve the ODBCInstLib property that is used in the simba.athenaodbc.ini configuration file.

  • [AO-257] On Windows, using the 64-bit version of the driver, you cannot authenticate the connection for IAM profile using AssumeRole credentials.

1.1.0 ------------------------------------------------------------------------

Released 2019-12-18

Enhancements & New Features

  • [AO-242] Updated catalog support

The driver is now able to return metadata from any catalog that is available in the Athena server. Previously, the driver only supported the AwsDataCatalog catalog.

By default, if your query statement does not specify a catalog, the driver queries the data under AwsDataCatalog. You can specify a different default catalog for your queries by setting the new Catalog connection property. For more information, see the Installation and Configuration Guide.

  • [AO-241] Updated configuration options for query polling

When a query is being executed, the driver polls the Athena server for the query results at a decreasingly frequent rate. In addition to configuring the maximum time interval between polls, you can now configure the minimum time interval between polls as well as the multiplier by which the interval increases after each polling attempt. To do this, set the new MinQueryExecutionPollingInterval and QueryExecutionPollingIntervalMultiplier connection properties.

Additionally, the default value of the MaxQueryExecutionPollingInterval property has been updated.

For more information, see the Installation and Configuration Guide.

  • [AO-245] Upgraded libcurl version

The driver now uses libcurl version 7.66.0. Previously, the driver used libcurl version 7.60.0.

  • [AO-254] Support for notarization

The driver now supports notarization on macOS systems, allowing it to be run on macOS 10.14.6 and higher.

  • [AO-255] Upgrade to OpenSSL 1.1.1d

The driver now uses OpenSSL 1.1.1d for encryption of data. Previously the driver used OpenSSL 1.1.0j.

==============================================================================

Installation and Configuration Guide