13 SNOWFLAKE

============================================================================== Magnitude 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 2.25.5, as well as the version history.

Simba Snowflake ODBC Connector 2.25.5 is based on Snowflake ODBC Driver 2.25.5. For information about additional changes, see the Snowflake ODBC Driver release notes: https://docs.snowflake.com/en/release-notes/client-change-log-odbc.html.

2.25.5 =======================================================================

Released 2022-09-09

Enhancements & New Features

  • [SNOW-557] Set secondary roles

    You can now set secondary roles. To do this, set the SecondaryRoles property to ALL. For more information, see the Installation and Configuration Guide.

  • [SNOW-646] Set file size threshold

    You can now set the file size threshold. To do this, set the GET_FILESIZE_THRESHOLD property to the file size in MB. For more information, see the Installation and Configuration Guide.

  • [SNOW-571] Improvements to parameter array binding

    The connector’s performance has been improved on parameter array binding.

  • [SNOW-1541][SNOW-1535] Updated third-party libraries

    The connector has been updated to use the following libraries:

    • libcURL version 7.84.0 (previously 7.78.0)
    • OpenSSL 1.1.1q (previously 1.1.1n)

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

  • [SNOW-613] When using ValidateSessionParam and the database name has special characters, such as a hyphen ( - ), the connector fails.

  • [SNOW-653] When using the PUT command to upload files larger than 2GB, the connector fails.

  • [SNOW-536] In some cases, when catalog functions, such as SQLTables or SQLColumns, contain database or schema names with double quotation marks ( ” ), the connector returns an empty result.

  • [SNOW-588] When querying parameter bindings, and the binding data is larger than 100MB, the connector fails.

  • [SNOW-589] When querying parameter array bindings and the TIMESTAMP_INPUT_FORMAT session parameter is changed from the default value of AUTO, the connector fails.

  • [SNOW-612] When changing log settings, such as set LogLevel or LogPath, from the connection string, the connector terminates unexpectedly.

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

  • [SNOW-646] When using the GET command to download large files with multi-parts, the connector returns corrupt files.

    This is an known issue in AWS SDK. As a workaround, set the GET_FILESIZE_THRESHOLD property to a value larger than the file size to be downloaded. This disables multi-parts downloading.

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

The following changes may disrupt established workflows for the connector.

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 ==============================================================

2.25.1 ———————————————————————–

Released 2022-04-29

Enhancements & New Features

  • [SNOW-532] Updated OpenSSL library

    The connector has been updated to use version 1.1.1n of the OpenSSL library. Previously, the connector used version 1.1.1l.

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

  • [SNOW-530] When calling SQLSetConnectAttr(SQL_ATTR_CURRENT_CATALOG) with a database name that includes lowercase characters, the connector returns an error.

  • [SNOW-539] In some cases, the proxy settings in one connection impact other connections in the same application or process.

  • [SNOW-555] When the PUT_TEMPDIR connection property is used in a connection string, it is vulnerable to command injection.

2.24.6 ———————————————————————–

Released 2022-03-25

Enhancements & New Features

  • [SNOW-432] Validate connection settings

    You can now validate the database, schema, and warehouse settings of a connection. To do this, set the ValidateSessionParam property to true. For more information, see the Installation and Configuration Guide.

  • [SNOW-436] Improvements to data type performance

    On Windows, the connector’s performance has been improved when retrieving TIMESTAMP_LTZ/TZ data types.

  • [SNOW-483] Support for server-side encryption

    The connector now supports server-side encryption for PUT/GET commands.

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

  • [SNOW-307] In some cases, when result chunk is retrieved with a network retry, bad data is included, causing various errors in data conversion.

  • [SNOW-441] In some cases, when authenticating with JWT and the token times out before the login, all connection retries are unsuccessful.

    This issue has been resolved. Now, the JWT token renews as needed during the retry.

  • [SNOW-445] When the connector does not recognize a key in the DSN registry, and a test is run via the Snowflake Configuration Dialog, the connector terminates unexpectedly.

  • [SNOW-446] The connector does not use cached OCSP certificates and instead downloads the certificate for each connection.

  • [SNOW-463] When parameters include non-ASCII characters, catalog functions return an error.

  • [SNOW-464] The connector ignores the setting of CLIENT_TELEMETRY_ENABLED and always sends telemetry.

  • [SNOW-503] When using PUT/GET commands with CLIENT_ENCRYPTION_KEY_SIZE set to 256, PUT does not encrypt the file correctly and GET causes the connector to terminate unexpectedly.

  • [SNOW-505] SQLGetData() does not correctly retrieve binary data in parts with arrow format.

  • [SNOW-508] When executing INSERT queries containing a large amount of parameter bindings, the bulk parameter binding does not behave as expected, and falls back to regular binding.

2.24.3 ———————————————————————–

Released 2021-11-30

Enhancements & New Features

  • [SNOW-397] Use current catalog

    You can now specifiy the connector behavior of catalog functions using the UseCurrentCatalog property. For more information, see the Installation and Configuration Guide.

  • [SNOW-411] Map string data to SQL_LONGVARCHAR

    You can now set the connector to map string data to SQL_LONGVARCHAR instead of SQL_CHAR or SQL_VARCHAR. To do this, set the MapToLongVarchar property to a positive value. For more information, see the Installation and Configuration Guide.

  • [SNOW-263] Test connections

    On Windows, you can now test the connection via the Snowflake Configuration dialog. For more information, see the Installation and Configuration Guide.

  • [SNOW-418][SNOW-420] Updated third-party libraries

    The connector has been updated to use the following libraries:

    • libcURL version 7.78.0 (previously 7.74.0)
    • OpenSSL 1.1.1l (previously 1.1.1k)

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

  • [SNOW-400] When creating a DSN after installing a new version of the connector to a different path, previously-created DSNs cannot be used.

  • [SNOW-402] In some cases, when using the Arrow format, the connector terminates unexpectedly.

  • [SNOW-406] When inserting TIMESTAMP_LTZ data using the stage binding feature (binding large amount of parameters using parameter arrays), the connector returns inconsistent results.

  • [SNOW-412] When a query fails, the connector continuously attempts to retry the connection.

    This issue has been resolved. Now, when the connector receives an HTTP 403 error code, it no longer retries the connection.

  • [SNOW-421] When the connector is retrieving query result sets and retrieves an invalid Arrow chunk, it returns an error.

  • [SNOW-422] In some cases, when using bulk fetching to retrieve result set data, and there and the query includes null data, the returned data length is incorrect.

  • [SNOW-434] When retrieving integer data in Arrow format with the hidden parameter ODBC_TREAT_DECIMAL_AS_INT set on the server side, the connector terminates unexpectedly.

2.24.1 ———————————————————————–

Released 2021-09-24

Enhancements & New Features

  • [SNOW-333] GET_FASTFAIL support

    When using the GET command, you can now stop the connector from downloading if an error occurs. To do this, set the GET_FASTFAIL property to true. For more information, see the Installation and Configuration Guide.

  • [SNOW-333] GET_MAXRETRIES support

    You can now set the maximum number of times that the GET command retries if it fails. To do this, set the GET_MAXRETRIES property to the number of retries. For more information, see the Installation and Configuration Guide.

  • [SNOW-334] Connect functions update

    Connect functions such as SQLConnect and SQLDriverConnect now return SQL_SUCCESS_WITH_INFO when the connection string includes an invalid property.

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

  • [SNOW-358] In some cases, when retrieving a large result set using the Arrow format, the connector terminates unexpectedly.

  • [SNOW-359] When using the Arrow format, the connector terminates unexpectedly.

  • [SNOW-369] When using parameter array binding, the connector terminates unexpectedly.

  • [SNOW-379] When the OCSP check fails during the connection process, the connector terminates unexpectedly.

  • [SNOW-381] When querying multiple statements and a procedure call is the first statement, the connector terminates unexpectedly.

  • [SNOW-390] When bulk retrieving using the Arrow format and the result set has empty binary data, the connector terminates unexpectedly.

2.23.3 ———————————————————————–

Released 2021-07-30

Enhancements & New Features

  • [SNOW-254] Set compression level with PUT

    You can now set the compression level of the PUT command using the PUT_COMPRESSLV property. For more information, see the Installation and Configuration Guide.

  • [SNOW-232] Support for SQL_DATA_AT_EXEC

    The connector now supports SQL_DATA_AT_EXEC in the SQLBindParameter(), SQLParamData(), and SQLPutData() functions. For more information, see the Microsoft documentation: https://docs.microsoft.com/en-us/sql/odbc/reference/develop-app/sending-long-data.

  • [SNOW-320] Support for Windows Server 2019

    The connector now supports Windows Server 2019. For a list of supported Windows versions, see the Installation and Configuration Guide.

  • [SNOW-295] Improvements to parameter array binding

    For DML queries, the connector now supports array binding for parameters in places other than values.

  • [SNOW-118] Performance improvements

    The connector has been updated with minor performance improvements.

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

  • [SNOW-248] When running PUT or GET queries in parallel (multithreading), the connector terminates unexpectedly.

  • [SNOW-287] QLProcedureColumns() does not return the expected argument name.

  • [SNOW-312] The column size, buffer length, and octet length returned from SQLColumns() does not recognize the DEFAULT_VARCHAR_SIZE or DEFAULT_BINARY_SIZE setting.

  • [SNOW-332] In some cases, when retrieving a large result set using the Arrow format, the connector terminates unexpectedly.

  • [SNOW-340] SQLGetInfo does not return the correct binary file name.

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

Released 2021-05-31

Enhancements & New Features

  • Additional connector properties

    The connector has been updated to use the following connector properties, based on Snowflake ODBC Driver 2.23.2:

    • DEFAULT_BINARY_SIZE
    • DEFAULT_VARCHAR_SIZE
    • PUT_FASTFAIL
    • PUT_MAXRETRIES
    • PUT_TEMPDIR

    For more information, see the Installation and Configuration Guide.

  • [SNOW-244] Updated SqlGetInfo

    SQLGetInfo now returns Snowflake ODBC Driver for SQL_DRIVER_NAME and 2.23.2 for SQL_DRIVER_VER.

  • [SNOW-288] Updated third-party libraries

    The connector has been updated to use the following libraries:

    • libcURL version 7.74.0 (previously 7.68.0)
    • OpenSSL 1.1.1k (previously 1.1.1i)

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

Installation and Configuration Guide