============================================================================== 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.0 (Preview), as well as the version history. 1.1.0 (Preview) ============================================================== 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. Workflow Changes ============================================================= This section describes changes that may disrupt established workflows for the driver. 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.0.7 ------------------------------------------------------------------------ Released 2019-09-30 Enhancements & New Features * [AO-227] Updated driver version information in Linux binary You can now check the Linux driver's version from the driver binary file. To do this, open the .so file in a text editor, and search for the text "$driver_version_sb$:". The driver's version number is listed after this text. * [AO-230] Support for VPC endpoints The driver now supports connections to VPC endpoints. This is configured using a set of endpoint override connection properties. For more information, see the Installation and Configuration Guide. * [AO-233] S3OutputLocation no longer mandatory You no longer need to define the S3OutputLocaiton connection property, provided a location is defined as part of the Athena Workgroup configuration. * [AO-215] Support for Okta credentials provider The driver now supports the use of the Okta service for authentication. For more information, see the Installation and Configuration Guide. 1.0.6 ------------------------------------------------------------------------ Released 2019-07-19 Enhancements & New Features * General availability of the Simba Athena ODBC Driver This version marks the general release of the driver. The driver now requires a license file to be used. For more information about how to use the driver, see the Installation and Configuration Guide available in the driver package. Visit www.simba.com/resources/drivers/documentation for the most recent documentation for your driver. 1.0.5 ------------------------------------------------------------------------ Released 2019-02-07 Enhancements & New Features * [AO-205] Updated ICU support. The driver has been updated to use ICU 58.2.x. * [AO-183] Support for CTAS statements The driver now provides support for CTAS statements, consistent with the Athena API. As part of this update, the driver now reports the correct update count when a CTAS query is executed. * [AO-200] Support for workgroups A new connection property has been added that allows you to specify a workgroup when authenticating into the data source. To do this, specify the Workgroup connection property. For details, see the Installation and Configuration Guide. 1.0.4 ------------------------------------------------------------------------ Released 2018-11-14 Enhancements & New Features * [AO-169] SAML authentication using AD FS The driver now supports SAML authentication, and can retrieve and use credentials from an AD FS (Active Directory Federation Services) credentialprovider. For more information, see the Installation and Configuration Guide. * [AO-194] Optimized polling intervals for query results When a query is being executed, the driver now polls the Athena server for the results at an exponentially changing rate. This change in polling behavior reduces the number of API calls sent to the server, and minimizes the chances of reaching the API call limit. * [AO-195] More informative error messages for invalid port configurations The driver now provides more detailed error messages when an invalid value is specified for any of the following configuration options: - Proxy Port (the ProxyPort property) - IdP Port (the IdP_Port property) * [AO-201] Proxy connection options now available through the Windows UI When using the driver on Windows, you can now access and configure the proxy connection options through the HTTP Proxy Options dialog box. For more information, see the Installation and Configuration Guide. * [AO-202] Standardized key names for "maximum length" connection properties The key names of the connection properties that specify the maximum lengths of catalog, schema, table, and column names have been updated as follows: - MaxCatalogNameLength has been renamed to MaxCatalogNameLen - MaxSchemaNameLength has been renamed to MaxSchemaNameLen - MaxTableNameLength has been renamed to MaxTableNameLen - MaxColumnNameLength has been renamed to MaxColumnNameLen The previous key names continue to be supported for backwards compatibility. * [AO-203] Updated request timeout settings The driver now times out any requests that take longer than 15 seconds to complete. Before, the driver timed out any requests that took longer than 3 seconds. Resolved Issues The following issues were resolved in Simba Athena ODBC Driver 1.0.4. * [AO-196] When the driver is installed on a machine that uses Turkish locale settings, if you try to connect using a connection string where one or more of the property names contains a lower-case "i" character, the driver fails to parse the string and does not connect to the server. * [AO-198] When connection pooling is enabled and the connection is reset, driver-wide configurations (such as settings for logging) are lost. * [AO-199] Driver does not return non-English column names correctly. 1.0.3 ------------------------------------------------------------------------ Released 2018-08-29 Enhancements & New Features * [AO-177] Standardized log file names When logging is enabled, the driver now produces the following log files: - A simbaathenaodbcdriver.log file that logs driver activity that is not specific to a connection. - A simbaathenaodbcdriver_connection_[Number].log for each connection made to the database, where [Number] is a number that identifies each log file. This file logs driver activity that is specific to the connection. * [AO-171] Updated third-party dependencies The driver now uses libcURL 7.60.0 and zlib 1.2.11. As a result, several security features in the driver have been improved. * [AO-167] Updated AWS SDK support The driver now uses AWS C++ SDK version 1.4.85. * [AO-165] Support for result set streaming API The driver now supports the AWS result set streaming API. This can be toggled on or off with the Use Result Set Streaming option (UseResultSetStreaming property). For more information, see the Installation and Configuration Guide. * [AO-160] Configurable complex column length You can now specify the maximum data length of complex data types that are cast to SQL_VARCHAR, such as ARRAY, MAP, and STRUCT. To do this, set the Max Complex Type Column Length field (ComplexTypeColumnLength property) to the maximum length. For more information, see the Installation and Configuration Guide. * [AO-157] Improved AWS Glue workflow AWS Glue availability detection logic now calls an API in Glue to speed up detection logic. If the API fails, the driver falls back to the original method. * [AO-155][AO-146] New data type support The driver now supports FLOAT and CHAR data types. For details, see the Installation and Configuration Guide. Resolved Issues The following issues were resolved in Simba Athena ODBC Driver 1.0.3. * [AO-178] When returning the results of a SQLColumns, the driver does not return partition column names. * [AO-164] The driver does not return the VIRTUAL_VIEW table type, and as a result some applications cannot query tables of this type. This has been resolved. The driver now returns these table types by default: - TABLE - VIEW - EXTERNAL_TABLE - MANAGED_TABLE - VIRTUAL_VIEW - SYSTEM TABLE * [AO-153] When the driver executes a query containing Common Table Expression (CTE) syntax, it incorrectly returns a row-count result set. 1.0.2 ------------------------------------------------------------------------ Released 2018-07-03 Enhancements & New Features * Query string is logged at DEBUG level instead of INFO level When logging is enabled, the driver now records the query string when the logging level is set to DEBUG or 5. Previously, the query string was recorded when the logging level was set to INFO or 4. * Prefixes for log file names You can now configure the driver to add a prefix to log file names. The prefix includes the user name associated with the connection and the process ID of the application through which the connection is made. To enable this feature, set the UseLogPrefix connection property to 1. For more information, see the Installation and Configuration Guide. 1.0.1 ------------------------------------------------------------------------ Released 2017-10-03 Enhancements & New Features * Metadata retrieval improvement Driver is now able to retrieve catalog metadata from regions that support AWS Glue as well as from regions that don't support AWS Glue. * Reporting the maximum length of database fields You can now specify the maximum character length that the driver reports for the names of catalogs, columns, schemas, and tables. To do this, set the following new advanced options: - Max Catalog Name Length (the MaxCatalogNameLength property) - Max Column Name Length (the MaxColumnNameLength property) - Max Schema Name Length (the MaxSchemaNameLength property) - Max Table Name Length (the MaxTableNameLength property) For more information, see the Installation and Configuration Guide. 1.0.0 ------------------------------------------------------------------------ Released 2017-09-11 * Version 1.0.0 was the initial release of the Simba Athena ODBC Driver. ==============================================================================