This article contains the release notes for the Snowflake ODBC Driver, including the following when applicable:
- Behavior changes
- New features
- Customer-facing bug fixes
Note: Beginning with the January 2022 release, all release note information for this connector is published on this page. For release note information for previous versions, see the
Server Release Notes. For change log information for previous releases, see the
ODBC Driver Change Log.
Note: As of September 2023, ODBC Driver release notes are published on the Snowflake documentation site and will no longer appear on this page. Please update any links you might have saved.
Version 3.1.0 (August 23, 2023)
Behavior Change Release (BCR) Changes
- Fixed an issue where, under certain conditions, the driver could retry HTTP requests indefinitely.
Previously, during an outage the driver would retry the failed HTTP call continuously until the request succeeds or until someone force kills the operation.
With this change, the driver disables infinite HTTP retries originating from execute and executeQuery calls. Now, the driver limits HTTP retries to seven, by default. Customers can set the maxHttpRetries connection parameter to customize the maximum number of retries. Customers can set maxHttpRetries=0 to remove the retry limit, but doing so runs the risk of the driver infinitely retrying failed HTTP calls.
- To improve performance, the SQLExecDirect() function no longer unnecessarily validates parameter bindings for a query.
Previously, the driver sent two requests for each SQLExecDirect() call: a describe request and an execute request. To improve the performance describe request is omitted. With this change the driver won't validate the parameter bindings needed by the query. If the parameter bindings from previous query is not cleared using SQLFreeStmt(SQL_RESET_PARAMS) it could be applied to the following query incorrectly and cause issues.
New Features and Updates
- Added the CLIENT_OUT_OF_BAND_TELEMETRY_ENABLED session parameter to enable and disable out-of-band (OOB) telemetry support.
Bug Fixes
- Fixed an issue where the driver might fail when getting a query result for mulit-statement queries that begin with new statement types, such as CALL.
- Fixed an issue that could cause the SQLColAttribute() function to return an incorrect value of SQL_DESC_OCTET_LENGTH on VARCHAR columns, which could truncate data.
- Fixed an issue where the driver failed to download query results by incorrectly sending out-of-band (OOB) telemetry timeouts when using private links.
Version 3.0.2 (July 27, 2023)
New Features and Updates
- Updated the following software libraries:
- util-linux to version 2.39.0.
- curl to version 8.1.2.
- Enhanced hybrid transactional/analytical processing (HTAP).
- Set the LogLevel default to OFF for ODBC clients running on Windows platforms.
Bug Fixes
- Fixed an issue that cause intermittent crashes when sending telemetry.
Version 3.0.1 (July 06, 2023)
BCR (Behavior Change Release) Changes
Starting with version 3.0.1 of the ODBC driver,
- Upgraded from openssl 1.1.1 to openssl 3.0.9. Consequently, private keys generated using the deprecated encryption algorithms in previous openssl library version no longer work. When you update to ODBC 3.0.1, you must regenerate your private key file used for key pair authentication.
- Dropped support for CentOS 6 and MacOS 10.14 and 10.15.
New Features and Updates
- Updated the following software libraries:
- openssl to version 3.0.9.
- icu to version 71.1.0.
- Created a single, unified release package architecture that supports both x86_64 and arm64 Mac systems.
Bug Fixes
- Fixed an issue where the driver crashed intermittently when CLIENT_SESSION_KEEP_ALIVE is set to true on Windows systems.
Version 2.25.12 (June 06, 2023)
New Features and Updates
Bug Fixes
- Fixed an issue where very large requests with large amounts of parameter bindings could crash an application by exceeding the logging size.
- Fixed an issue with OCSP validation.
- Fixed an issue that could inadvertently reveal a proxy password in the Snowflake log file.
Version 2.25.11 (April 20, 2023)
New Features and Updates
- Updated the libcurl library from version 7.87.0 to 7.88.1.
- Updated the zlib library from version 1.2.11 to 1.2.13.
Bug Fixes
- Fixed an invalid URL issue that could occur during OCSP validation when making connections.
- Fixed an issue where connections would fail when credentials were supplied when using proxies that do not need them.
- Remove deprecated openssl function calls.
- Fixed an issue where double type parameter bindings could lose precision.
- Removed unsafe function calls banned by Microsoft.
Version 2.25.10 (March 22, 2023)
New Features and Updates
- Updated the libcurl library from version 7.84.0 to 7.87.0.
Bug Fixes
- Fixed an issue the prevented clients from creating a file DSN (data source name).
- Fixed an issue where the PUT command failed to replicated data.
- Fixed an issue a Macintosh application running an the ARM64 architecture would fail to connect to Snowflake using the native Apple Silicon ODBC driver.
Version 2.25.9 (February 28, 2023)
New Features and Updates
Bug Fixes
- Added support for the GEOMETRY data type in the SnowflakeType enum to fix an issue that occurred when calling the SQLColumns() function to return metadata that included GEOMETRY data.
- Fixed an issue where timestamp data was wrongly returned as NULL in some cases.
Version 2.25.8 (February 8, 2023)
New Features and Updates
Bug Fixes
- Fixed an issue where an array binding INSERT statement failed when the schema is not defined in the session.
- Fixed an issue that occasionally caused the ODBC driver to crash when executing GET and PUT queries.
- Fixed an issue where the ODBC driver sent SIGPIPE signals after the session was idle for around 120 seconds.
- Fixed an issue where using Okta authentication failed when receiving an HTTP 429 error.
Version 2.25.7 (December 13, 2022)
Documentation-only Update
This month's update includes only changes to the ODBC documentation and does not contain any software updates.
Version 2.25.7 (October 28, 2022)
BCR (Behavior Change Release) Change
Caution: Version 2.25.7 of the Snowflake ODBC driver included updates to match functionality described in the
ODBC documentation . Snowflake recommends that you do not install this version into a production environment before testing.
Bug Fixes
- Fixed an issue in which proxy settings in the connection parameters could incorrectly impact other connections.
- Fixed an issue where GET command calls might corrupt files.
Version 2.25.6 (October 12, 2022)
New Features
- Updated supported versions for the following libraries:
- Updated openssl to version 1.1.1q.
- Updated curl to version 7.84.0.
Bug Fixes
- Fixed an issue where a stage binding issue caused the application to crash.
- Fixed an issue with the pathname for the Macintosh arm64 processor installation package.
Version 2.25.5 (August 23, 2022)
New Features
- Added support for the new OKTA Identity Engine (OIE).
Bug Fixes
- Fixed issues for catalog functions with names that contain special characters.
- Fixed an issue with connection failures that occurred when the validateSessionParam configuration parameter is enabled and a database name contains a hyphen.
- Fixed an issue where corrupted files occasionally occurred with GET downloads.
- Fixed upload failures for files larger than 2 GB.
Version 2.25.4 (August 1, 2022)
Bug Fixes
- Improved performance for parameter array binding.
Version 2.25.3 (June 21, 2022)
New Features
- Added support for Arm64 on Linux.
Version 2.25.2 (June 01, 2022)
New Features
- Added support for a new SecondaryRoles parameter.
- Improved parameter binding performance.
Bug Fixes
- Fixed an issue with using user-defined formats for TIMESTAMP_INPUT_FORMAT during stage binding by always using the default format for TIMESTAMP_INPUT_FORMAT for stage binding.
Version 2.25.0 (May 09, 2022)
New Features
- Added Arm64 support for M1 Macintosh systems.
- Upgraded the openssl library from version 1.1.1l to 1.1.1n.
Bug Fixes
- Fixed an issue where stage binding failed with timestamp and date data types.
- Fixed an issue that caused a crash when changing the result format during a query.
- Fixed an issue that caused SQLSetConnectAttr(SQL_ATTR_CURRENT_CATALOG) to fail when the database name used lowercase letters.
Version 2.24.7 (March 17, 2022)
New Features
- Added support for Snowflake server-side encryption.
- Added support for non-ascii characters in the catalog function filters.
Bug Fixes
- Fixed an issue with the SQLGetData() function.
- Removed extraneous XML files from the installation package.
- Fixed an issue with the encryption key size for PUT and GET calls.
- Fixed an invalid database error.
Version 2.24.6 (February 21, 2022)
Bug Fixes
- Improved performance for TIMESTAMP_TZ and TIMESTAMP_LTZ on Windows.
- Enabled support for the undocumented CLIENT_TELEMETRY_ENABLED parameter.
Version 2.24.5 (January 20, 2022)
Bug Fixes
- Fixed an issue where the test button crashed
- Fixed an issue where loading an OCSP cache file always failed.
- Fixed an issue with Invalid arrow chunks when retrying a query.
