============================================================================== Magnitude Simba Athena JDBC Data Connector Release Notes ============================================================================== The release notes provide details of enhancements, features, known issues, and workflow changes in Simba Athena JDBC Connector 2.0.23, as well as the version history. 2.0.23 ======================================================================= Released 2021-06-10 Enhancements & New Features * [AJ-389] STS and Lake Formation endpoint override The connector now supports STS and Lake Formation endpoint override when retrieving temporary credentials. For more information, see the Installation and Configuration Guide. * [AJ-395] Updated ADFS parameters The connector now removes duplicate username parameters in the ADFS request. * [AJ-395] Updated ADFS support The connector now supports ADFS 2019. Workflow Changes ============================================================= The following changes may disrupt established workflows for the connector. 2.0.23 ----------------------------------------------------------------------- * [AJ-392] Updated Workgroup property The default value for the Workgroup property has been changed to primary. Previously, the default value was null. For more information, see the Installation and Configuration Guide. 2.0.13 ----------------------------------------------------------------------- * [AJ-314] 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. 2.0.2 ------------------------------------------------------------------------ * Removed support for JDBC 4.0 Beginning with this release, the driver no longer supports JDBC 4 (Java 6). For a list of supported JDBC versions, see the Installation and Configuration Guide. For more information about this workflow change, see the "Jackson library updated" release note in the "Enhancements & New Features" section of this 2.0.2 release. 2.0.0 ------------------------------------------------------------------------ * SDK interfaces The following AWS SDK interfaces are no longer shaded in the driver jar, they are included with the original AWS SDK package names. Any custom credential providers that use the old shaded package names for these interfaces must be updated. - com.amazonaws.auth.AWSCredentials - com.amazonaws.auth.AWSCredentialsProvider - com.amazonaws.auth.AWSSessionCredentials - com.amazonaws.auth.AWSSessionCredentialsProvider Version History ============================================================== 2.0.22 ----------------------------------------------------------------------- Released 2021-05-07 Enhancements & New Features * [AJ-373] Support for EXPLAIN The connector now supports the EXPLAIN statement. For more information, see https://docs.aws.amazon.com/athena/latest/ug/athena-explain-statement.html. 2.0.21 ----------------------------------------------------------------------- Released 2021-04-19 Resolved Issues The following issue has been resolved in Simba Athena JDBC Connector 2.0.21. * [AJ-382] When authenticating through Browser Azure AD and client_secret is not set, the connector returns an error. This issue has been resolved. Previously, when authenticating through Browser Azure AD, the connector required client_secret to be set. The client_secret property is now optional. 2.0.20 ----------------------------------------------------------------------- Released 2021-03-19 Enhancements & New Features * [AJ-363] Trimmed semicolon before prepare call The connector now removes the semicolon ( ; ) from the end of the string before a prepare call. * [AJ-366] Improved handling of escaped characters When using SQL Workbench, the connector now escapes the backslash ( \ ) when there is an underscore ( _ ) in the database or table name. For example, previously, if the database name was "lunch\_learn", it was treated as such, but now the connector treats it as "lunch_learn". * [AJ-356][AJ-371] Updated third-party libraries The connector now uses the following versions of these third-party libraries: - Commons Codec 1.15 (previously 1.10) - Commons CSV 1.8 (previously 1.4) - HttpClient 4.5.13 (previously 4.5.3) - HttpCore 4.4.14 (previously 4.4.6) - Joda-Time 2.10.10 (previously 2.9.9) * [AJ-374] Updated Java client SDK library The connector has been updated to use the public aws-java-sdk version 1.11.971 to support parameterized queries. Resolved Issues The following issue has been resolved in Simba Athena JDBC Connector 2.0.20. * [AJ-367] When using GetQueryResultsStream, the connector takes longer than expected to retrieve results. This issue has been resolved. Previously, the connector read data byte by byte. The connector now reads the complete line until the end of a line is reached, improving the performance. 2.0.19 ----------------------------------------------------------------------- Released 2021-02-03 Enhancements & New Features * [AJ-339] Updated query support The driver now supports parametrized queries. 2.0.18 ----------------------------------------------------------------------- Released 2021-01-29 Enhancements & New Features * [AJ-348] 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. * [AJ-355] Updated Jackson library The driver has been updated to use Jackson version 2.12.1. Previously, the driver used version 2.10.1. 2.0.17 ----------------------------------------------------------------------- Released 2020-12-30 Enhancements & New Features * [AJ-326] 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. 2.0.16 ----------------------------------------------------------------------- Released 2020-11-20 Enhancements & New Features * [AJ-253][AJ-254][AJ-255] 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. 2.0.15 ----------------------------------------------------------------------- Released 2020-10-23 Enhancements & New Features * [AJ-239] Use proxy with IdP authentication The driver now supports the use of a proxy server with IdP authentication. To do this, set the new UseProxyForIdP configuration option to True. For more information, see the Installation and Configuration Guide. * [AJ-313] Updated authentication support The driver now supports using the credential_process setting in the AWS configuration file for authentication. * [AJ-328] 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. 2.0.14 ----------------------------------------------------------------------- Released 2020-09-25 Enhancements & New Features * [AJ-308] 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. Resolved Issues The following issue has been resolved in Simba Athena JDBC Driver 2.0.14. * [AJ-304] The driver detects an XML External Entity (XXE) security threat. 2.0.13 ----------------------------------------------------------------------- Released 2020-09-02 Enhancements & New Features * [AJ-245] Updated Java client SDK library The driver has been updated to use the public aws-java-sdk version 1.11.793. 2.0.12 ----------------------------------------------------------------------- Released 2020-03-02 Enhancements & New Features * [AJ-261] Retrieve virtual views as views The driver can now retrieve virtual views as views. When you set the new MapAllViewTypeToView property to 1, the driver returns all table types whose name contains VIEW, such as VIRTUAL VIEW, as views. For more information, see the Installation and Configuration Guide. * [AJ-245] Updated Java client SDK library The driver has been updated to use the public aws-java-sdk version 1.11.652. Resolved Issues The following issue has been resolved in Simba Athena JDBC Driver 2.0.12. * [AJ-180] If the driver uses the result set streaming API and port 444 is closed, no data is sent and no error message is displayed. This issue has been resolved. Now, in this situation the driver displays an error message indicating that port 444 must be open to use the result set streaming API. ==============================================================================