13 SNOWFLAKE

============================================================================== Simba Snowflake ODBC Data Connector Release Notes ==============================================================================

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

Simba Snowflake ODBC Connector 3.9.1 is based on Snowflake ODBC Driver 3.9.0. For information about additional changes, see the Snowflake ODBC Driver release notes: https://docs.snowflake.com/en/release-notes/clients-drivers/odbc.

3.9.1 ========================================================================

Enhancements & New Features

  • [SNOW-2787] Added support for private key base64.

  • [SNOW-2842] Added support virtual-style domains.

  • [SNOW-2754] Added support for regional Google Cloud Storage endpoints.

  • [SNOW-2340] Added a connectivity diagnostics mode.

  • [SNOW-1871] Improved error messages for network errors.

  • [SNOW-2556] Added support for passing private key file content through SQLSetConnectAttr when using key-pair authentication.

  • [SNOW-2842] Added support for different top-level domains, such as .cn in China.

  • [SNOW-2290] Increased the maximum allowable LOB (large object) size.

  • Added the LOCAL_APPLICATION default for the oauth_client_id and oauth_client_secret OAUTH parameters

  • Extended the Windows UI of the ODBC driver with key-pair authentication parameters PRIV_KEY_FILE and PRIV_KEY_FILE_PWD.

  • Added the DriverManagerOverride configuration parameter, which allows specifying the driver manager on Linux and MacOS.

  • Added support for PAT (Programmatic Access Token), OAuth 2.0 Authorization Code Flow, OAuth 2.0 Client Credentials Flow, and OAuth Token caching.

  • [SNOW-2705] Updated third-party libraries

    The connector has been updated to use the following libraries:

    • ICU 74.2 (previously 71.1)

  • [SNOW-2705] Updated platform support

    The connector now supports the following platform versions:

    • Windows Server 2025
    • Ubuntu 24.04

    For a list of supported platform versions, see the Installation and Configuration Guide.

Resolved Issues The following issues have been resolved in Simba Snowflake ODBC Connector 3.9.1.

  • [SNOW-2850] Fixed the incorrect error thrown by fetching the cancellation request.

  • [SNOW-2844] Fixed the issue triggered by using bulk fetching first (retrieve multiple rows per fetch call), then switching to single row mode.

  • [SNOW-2862] Fixed the issue when handling easy-logging configuration could break the connection.

  • [SNOW-2813] Enabled the Address Space Layout Randomization (ASLR) security compiler option for Windows.

  • [SNOW-2805] Fixed an issue with certain code paths logging the entire SQL query text using the INFO level.

  • [SNOW-2759] Fixed an issue with the driver crashing when basic_string::_M_construct is null or not valid or when a segmentation fault because the HOME environment variable is unset.

  • [SNOW-2782] Fixed issues with lowercasing URL when using OKTA authentication.

  • [SNOW-1078] Fixed an issue where unsupported usage of SQL_DEFAULT_PARAM is not handled correctly.

  • [SNOW-2602] Fixed an issue where an error is returned when calling a SQL procedure that returns NULL.

  • [SNOW-2562] Fixed an issue where multi-statement queries returned incorrect query results when the multi-statement query had more than one USE command.

  • [SNOW-2597] Fixed an issue with memory leaks when reading environment variables.

  • [SNOW-2627] Fixed an issue where proxy settings in environment variables is not honored on Windows.

  • Fixed an OCSP validation issue on session resuming that could lead to out of memory problem.

  • Fixed an issue with the MacOS Secure Storage helper.

  • Fixed a logging issue with the test button.

  • Fixed an issue when a query response omits its length.

  • Fixed an issue with the HTTP Date header format depending on the locale.

  • Fixed an issue of introducing delays in some cases when running put/get command.

  • Fixed an issue that caused the driver to become unresponsive in some cases when logging.

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

The following changes may disrupt established workflows for the connector.

3.9.1 ————————————————————————

  • [SNOW-2768] Removed support for Ubuntu 20.04

    Beginning with this release, the connector no longer supports Ubuntu version 20.04. For a list of supported Linux versions, see the Installation and Configuration Guide.

3.3.4 ========================================================================

  • [SNOW-2717] Driver client version fix

  • [SNOW-2861] Updated third-party libraries

    The connector has been updated to use the following libraries:

    • libcurl 8.12.1 (previously 8.7.1)
    • Expat 2.7.1 (previously 2.6.3)

3.3.3 ========================================================================

Released 2024-11-08

Enhancements & New Features

  • [SNOW-2041] Log setting support

    The connector now supports log settings in a logging configuration file.

  • [SNOW-2325][SNOW-2327][SNOW-2490] Updated third-party libraries

    The connector has been updated to use the following libraries:

    • AWS SDK 1.11.283 (previously 1.3.50)
    • Arrow 15.0.0 (previously 0.17.1)
    • libcurl 8.7.1 (previously 8.6.0)
    • Expat 2.6.3 (previously 2.6.2)
    • Openssl 3.0.15 (previously 3.0.13)

  • [SNOW-2515] disableSamlUrlCheck support

    The connector can now disable the verification for SAML URLs. To do this, set the disableSamlURLCheck property to true. For more information, see the Installation and Configuration Guide.

Resolved Issues The following issues have been resolved in Simba Snowflake ODBC Connector 3.3.3.

  • [SNOW-2474] SQLProcedures() does not list stored procedures that return a table without a column definition.

  • [SNOW-2536] The connector displays incorrect information in the log file.

  • [SNOW-2553] In some cases of scripting, the connector does not return accurate query results.

  • [SNOW-2554] When dealing with boolean types, the connector does not handle conversion information from SQLGetInfo() leading to errors in the PowerBI slicer.

  • [SNOW-2559] In some cases, when a script contains several USE statements, the connector fails to return query results correctly.

  • [SNOW-2564] When connector connects to server using Entra, the environment variables for proxy settings are not recognized.

  • [SNOW-2570] When selecting the S3 regional URL domain with the region name, the connector returns an error.

  • [SNOW-2581] For custom SQL data types, SQLColAttribute(SQL_DESC_TYPE_NAME) does not return type names.

  • [SNOW-2641] In PowerBI, the connector’s incorrect return of conversion information from SQLGetInfo() leads to a timestamp-related issue.

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

The following changes may disrupt established workflows for the connector.

3.3.3 ————————————————————————

  • Removed support for earlier versions of platform

    Beginning with this release, the connector no longer supports the following versions of platform:

    • CentOS 7
    • Debian 10
    • Red Hat® Enterprise Linux® (RHEL) 7

    For a list of supported platform versions, see the Installation and Configuration Guide.

3.2.2 ————————————————————————

  • [SNOW-2328] Removed support for CRT functions

    Beginning with this release, the banned CRT functions have been removed for security reasons.

  • [SNOW-2103] Updated LOGIN_TIMEOUT property

    The default value of the LOGIN_TIMEOUT property is now 300. Previously, the default value was 60. For more information, see the Installation and Configuration Guide.

3.0.0 ————————————————————————

  • Removed support for macOS universal bitness

    Beginning with this release, the connector no longer supports universal bitness for macOS. Support for macOS versions 10.14 and 10.15 has been removed. For a list of supported macOS versions, see the Installation and Configuration Guide.

2.25.8 ———————————————————————–

  • Removed support for earlier versions of Windows

    Beginning with this release, the connector no longer supports the following versions of Windows:

    • Windows 8.1
    • Windows 7 SP1
    • Windows Server 2008 R2 SP1

    For a list of supported Windows versions, see the Installation and Configuration Guide.

  • Removed support for earlier versions of Linux distributions

    Beginning with this release, the connector no longer supports the following versions of Linux distributions:

    • Debian 8 and 9
    • Ubuntu 16.04

    For a list of supported Linux versions, see the Installation and Configuration Guide.

2.23.2 ———————————————————————–

  • Removed support for macOS 10.13

    Beginning with this release, support for macOS 10.13 has been removed. For a list of supported macOS versions, see the Installation and Configuration Guide.

1.4.0 ————————————————————————

  • Removed support for CentOS 6 and RHEL 6

    Beginning with this release, support for CentOS 6 and RHEL 6 have been removed. For a list of supported Linux versions, see the Installation and Configuration Guide.

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

3.2.2.1005 ——————————————————————-

Released 2024-03-26

Enhancements & New Features

  • [SNOW-2480] Security enhancement

    Several security improvements have been added.

3.2.2 ————————————————————————

Released 2024-02-29

Enhancements & New Features

  • [SNOW-2103] Connection re-attempt support

    The connector can now manage the frequency of retries for unsuccessful connection requests.

  • [SNOW-2105] Multiple SAML Integrations Support

    The connector now supports multiple SAML integrations.

  • [SNOW-2239] Performance improvement

    The SQLGetData() function has been enhanced for results retrieval.

  • [SNOW-2329] Security enhancement

    On Windows, the security has been enhanced by adding compile flags.

  • [SNOW-2348][SNOW-2402][SNOW-2433] Updated third-party libraries

    The connector has been updated to use the following libraries:

    • libcurl 8.6.0 (previously 8.4.0)
    • OpenSSL 3.0.13 (previously 3.0.11)
    • zlib 1.3.1 (previously 1.2.13)

  • [SNOW-2011] BROWSER_RESPONSE_TIMEOUT support

    In an external browser, you can now specify the waiting time for an authentication to respond. To do this, set the time for BROWSER_RESPONSE_TIMEOUT in seconds. For more information, see the Installation and Configuration Guide.

  • [SNOW-2267] allowEmptyProxy support

    The connector can now allow ignore empty values for the proxy and non-proxy connection parameters. To do this, set the allowEmptyProxy property to true. For more information, see the Installation and Configuration Guide.

Resolved Issues The following issues have been resolved in Simba Snowflake ODBC Connector 3.2.2.

  • [SNOW-1942] When creating a DSN with special characters, the connector returns an incorrect error message.

  • [SNOW-1989] When sending telemetry data, the connector fails.

  • [SNOW-2189] When the connector receives a HTTP 429 error, the Okta authentication fails.

  • [SNOW-2234] When OSCP validation is delayed while retrieving query results, the connector fails.

  • [SNOW-2237] When a file path contains non-ASCII characters, the PUT and GET commands fail.

  • [SNOW-2253] When overwrite is not set to true, the PUT command on GCP overwrites existing files.

  • [SNOW-2255] When the keyfile path contains non-latin characters, the key air authentication fails.

  • [SNOW-2330][SNOW-2331] When error handling, few system resources (usually memory) is lost or wasted needlessly.

3.1.2 ————————————————————————

Released 2023-10-16

Enhancements & New Features

  • [SNOW-2223] Updated third-party libraries

    The connector has been updated to use the following libraries:

    • libcurl 8.4.0 (previously 7.88.1)
    • OpenSSL 3.0.11 (previously 3.0.8)

  • [SNOW-1610] Performance improvement

    To enhance performance, the SQLExecDirect() function validates only the necessary parameter bindings before executing the query.

  • [SNOW-1866] Updated util-linux support

    The connector now supports util-linux version 2.39.0. Previously, the connector supported version 2.36.1.

  • [SNOW-1668][SNOW-1793][SNOW-2161] Enhanced HTAP optimization

    The connector enhances HTAP optimization by removing session parameters and metadata from the query result and on adding retry reason in the retry request and query context caching.

  • [SNOW-2173] Updated cacert

    The connector has been updated with the cacert bundle used for SSL connections.

  • [SNOW-2134] maxHttpRetries support

    You can now set the maximum number of HTTP retries for queries with failed HTTP requests. To do this, set the maxHttpRetries property to the number of retries. For more information, see the Installation and Configuration Guide.

Resolved Issues The following issues have been resolved in Simba Snowflake ODBC Connector 3.1.2.

  • [SNOW-1856] When large requests with huge amount of parameter bindings exceed the logging size, the connector terminates.

  • [SNOW-1880] When using SQLColAttribute() function, the connector returns an incorrect value of SQL_DESC_OCTET_LENGTH on VARCHAR columns.

  • [SNOW-1887] On Windows, in some cases, when the CLIENT_SESSION_KEEP_ALIVE is set to true, the connector terminates unexpectedly.

  • [SNOW-1890] When OCSP validation fails to get OCSP response from the cache server, the connector fails.

  • [SNOW-1921] The connector displays proxy password in the log file.

  • [SNOW-1989] In some cases, when sending telemetry, the connector terminates unexpectedly.

  • [SNOW-2048] When getting a query result for multi-statement queries with new statement types, the connector fails.

  • [SNOW-2085] When performing OCSP validation without using the entire OCSP URL in the certificate, the connection fails.

  • [SNOW-2112] In privatelink environment, the connector fails to download the query results due to out of band telemetry sending timeout.

  • [SNOW-2125] When executing file transfer PUT or GET command, the connector returns an “unknown exception” error.

  • [SNOW-2144] In privatelinks, when using external browser authentication on OCSP validation , the connection fails.

  • [SNOW-2197] When a query is cancelled by the application, the connector continues to retry to download the result.

  • [SNOW-2200] The connector leaks the credentials in the error messages.

  • [SNOW-2194] Using SQLGetData() function to retrieve query result with Arrow result format decreases performance.

3.0.0 ————————————————————————

Released 2023-04-30

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.

  • [SNOW-1802][SNOW-1820] Updated third-party libraries

    The connector has been updated to use the following libraries:

    • Expat 2.50 (previously 2.4.6)
    • ICU 71.1.0 (previously 58.3.0)
    • libcurl 7.88.1 (previously 7.84.0)
    • OpenSSL 3.0.8 (previously 1.1.1q)
    • zlib 1.2.13 (previously 1.2.11)

    For OpenSSL, the existing private key file used for key pair authenication might need to be regenerated since some encryption algorithm are depreacted in OpenSSL 3.

  • [SNOW-1787] GEOMETRY data type support

    The connector now supports the GEOMETRY data type.

  • [SNOW-1859] Updated security support

    The connector has been updated with enhanced security.

  • Updated platform support for Ubuntu

    The connector now supports Ubuntu 22.04. For a list of supported Linux versions, see the Installation and Configuration Guide.

Resolved Issues The following issues have been resolved in Simba Snowflake ODBC Connector 3.0.0.

  • [SNOW-1637] When querying SQLGetInfo, the connector returns incorrect conversion information.

  • [SNOW-1718] When executing a parameterized query, parameter bindings with SQL_DOUBLE data type lose precision.

  • [SNOW-1784] In some cases, timestamp data is incorrectly returned as NULL.

  • [SNOW-1794] When using the ODBC Data Source Administrator to create a file DSN, the connector returns an empty file.

  • [SNOW-1821] When OCSP validation requests include URL reserved characters, the connection fails.

  • [SNOW-1822] When using a proxy that does not have username and password specified, the connection fails.

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

Installation and Configuration Guide