1 ATHENA

============================================================================== Magnitude Simba Athena ODBC Data Connector Release Notes ==============================================================================

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

1.2.1.1000 ===================================================================

Released 2023-11-03

Enhancements & New Features

  • [AO-536] Updated RStudio support

    On macOS, the connector now supports RStudio.

  • [AO-1326] Use Single Catalog And Schema support

    The connector can now return only single catalog and schema that is specified under connection parameters. To do this, select the Use Single Catalog And Schema checkbox (set the UseSingleCatalogAndSchema property to 1). For more information, see the Installation and Configuration Guide.

Resolved Issues The following issues have been resolved in Simba Athena ODBC Connector 1.2.1.

  • [AO-1285] When the prepared statements with array of parameters using column-wise schema are run, the connector returns an incorrect query result.

  • [AO-1346] When the $file_modified_time system column is selected, the connector returns an incorrect column size.

  • [AO-1365] When binding parameters related to SQLPrepare of Select queries, the connector returns an error.

Known Issues The following are known issues that you may encounter due to limitations in the data source, the connector, or an application.

  • [AO-479] The connector does not support the SQLDescribeParam API call.

    This is a limitation of the datasource.

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

The following changes may disrupt established workflows for the connector.

1.1.19 ————————————————————————

  • Updated properties appearing in the UI

    The following properties now appear in the UI:

    • Lakeformation Enabled (LakeformationEnabled)
    • Glue Endpoint Override (GlueEndpointOverride)
    • Use Aws Logger (UseAwsLogger)

    For more information, see the Installation and Configuration Guide.

1.1.13 ————————————————————————

  • Updated GlueEndpointOverride property

    The description of the GlueEndpointOverride property has been updated with new parameters. For more information, see the Installation and Configuration Guide.

  • Updated NonProxyHosts property

    The description of the NonProxyHosts property has been updated with new parameters. For more information, see the Installation and Configuration Guide.

1.1.11 ———————————————————————–

  • [AO-476] Updated Workgroup property

    On Linux, the default value for the Workgroup property has been set to Primary. Previously, the default value was not set. For more information, see the Installation and Configuration Guide.

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.2.0.1000 ——————————————————————-

Released 2023-09-27

Enhancements & New Features

  • Updated macOS support

    On macOS, the connector is now a Universal driver that natively supports Apple Silicon. For security best practices, it is suggested to keep both the connector and OS updated.

  • Updated SEN SDK support

    The connector now uses SEN SDK version 10.2. Previously, the connector used SEN SDK version 10.1.

1.1.20 ———————————————————————–

Released 2023-05-05

Enhancements & New Features

  • [AO-1304] Lake formation Endpoint Override support

    The connector now supports the endpoint for the Lake Formation service when using the assumeDecoratedRoleWithSaml API to retrieve temporary credentials. To do this, in the Lake formation Endpoint Override field, specify the endpoint (set the LakeformationEndpoint Override property). For more information, see the Installation and Configuration Guide.

  • [AO-1307] Updated aws dependencies

    The connector now uses aws 10.2_aws_1.10.5 dependencies for DriverIamSupport.

  • [AO-1289] Login To RP support

    The connector now supports the endpoint for the ADFS auth plugin to use custom Login To RP parameter. To do this, in the Login To RP field specify the endpoint (set the Login To RP property). For more information, see the Installation and Configuration Guide.

Resolved Issues The following issues have been resolved in Simba Athena ODBC Connector 1.1.20.

  • [AO-539] The connector does not deallocate the prepared statement, when SQLPrepare() fail to submit.

  • [AO-544] When binding parameters in prepared statements to convert the C type to SQL type, the connector returns an error.

  • [AO-554] When binding some parameters in prepared statements, the connector does not convert to SQL_REAL type correctly.

  • [AO-541] When executing EXPLAIN and EXPLAIN ANALYZE queries using
    SQLPrepare() and SQLExecute(), the connector does not return data.

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

Installation and Configuration Guide