This article contains the release notes for the Snowflake .NET 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.
Note: As of September 2023, .NET 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 2.1.1 (August 23, 2023)
New Features and Updates
Bug Fixes
- Fixed an issue where test connections were not reused when created successfully.
- Fixed an issue where the * and ? wildcards did not work correctly in file paths.
- Fixed an issue where the driver incorrectly required a username and password for external browser authentication.
Version 2.1.0 (July 27, 2023)
BCR (Behavior Change Release) Change
Fixed an issue where, under certain conditions, the .NET driver could retry HTTP requests indefinitely.
Previously, during an outage the .NET driver would retry the failed HTTP call continuously until the request succeeds or until someone force kills the operation.
With this change, disables infinite HTTP retries originating from execute and executeQuery calls. Now, the .NET 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 .NET driver infinitely retrying failed HTTP calls.
New Features and Updates
- Improved handling of remote paths containing a subdirectory in a GET command.
Bug Fixes
- Fixed an issue with connection pools that could occur when a dirty connection is closed and the BeginTransaction method is called explicitly.
- Fixed an issue with UseProxy in HTTPClientHander.
- Added the BROWSER_RESPONSE_TIMEOUT connection parameter to fix an issue with authentication in an external browser. The default is 120 seconds.
- Fixed an issue with connection pool timeouts during daylight saving time transitions.
Version 2.0.25 (June 16, 2023)
New Features and Updates
Bug Fixes
- Fixed an issue where the proxy password could be visible in the Snowflake log file.
- Fixed an issue where
SnowflakeDbDataReader.HasRows() always returned true for some query types (e.g. SELECT) regardless whether there are valid rows in query result. - Fixed an intermittent "Authentication token has expired" or "Session no longer exists" issue when connection pooling enabled.
- Removed use of WinHttpHandler.
- Fixed an issue where retries on chunk downloading would occasionally fail, such as when a network error occurred after the data was partially downloaded.
- Fixed problem in chunk retry downloading process and improved testing of those retries.
Version 2.0.24 (May 23, 2023)
New Features and Updates
- Added session ID logging to get better tracking of the activity for each session in cases where multiple connections are used in parallel.
Bug Fixes
- Fixed an issue where a .NET application throw an unauthorized error when connection pooling was enabled.
- Fixed an issue with 401 errors caused by empty session tokens.
Version 2.0.23 (April 19, 2023)
New Features and Updates
- Changed the legacy supported version to version 4.7.1.
Bug Fixes
- Fixed an issue where a .NET application would terminate for an unhandled exception when client_session_keep_alive=true.
- Fixed an issue where a COMMIT could be interrupted by an unnecessary rollback.
- Fixed an issue where a connection could not terminate a session when connection pooling is enabled.
- Fixed an issue where calling Close() before Dispose() resulted in duplication connections in a pool.
- Fixed an issue where errors were thrown then a mandatory USER property was not provided.
- Fixed the WinHttpHandler PlatformNotSupportedException; the .NET driver now uses WinHttpHandler only for .NET framework applications.
- Fixed an issue where an error incorrectly occurred when passing an empty USER property in the connection string for SSO logins.
- Fixed an issue where database names that contained spaces that were enclosed in double quotes (e.g. "My DB") were not treated properly.
Version 2.0.22 (March 22, 2023)
New Features and Updates
Bug Fixes
- Fixed an issue that caused applications that set CLIENT_SESSION_KEEP_ALIVE=true to hang when it closed the connection.
- Fixed an issue where query execution would intermittently fail after a timeout occurred.
- Fixed an issue where the .NET driver would fail to execute PUT commands in an FIPS-enabled deployment.
- Fixed the .NET connector throwing error: System.Net.Http.WinHttpException (80072EE2, 12002): Error 12002 calling WINHTTP_CALLBACK_STATUS_REQUEST_ERROR”.
- Started adding the https: prefix to AWS endpoints that do not include the prefix.
- Updated the Specify an unencrypted private key (read from a file) example in the README.md file to remove the Replace() function call.
Version 2.0.21 (February 22, 2023)
New Features and Updates
- Added support for using GCS access tokens for PUT and GET queries (#585).
Bug Fixes
- Improved exception handling to preserve stack traces (#439).
Version 2.0.20 (January 24, 2023)
New Features and Updates
- Added support for the new Okta OIE.
- Improved error logging for JSON parsing by including the queryid in the log message.
Bug Fixes
- Fixed issue with PUT/GET not determining the correct compression type of files to be uploaded.
- Fixed issue with PUT/GET result values not being mapped to the appropriate field.
- Fixed an out of bounds issue when trimming SQL queries that contained a closing comment.
- Fixed an issue where using Okta authentication failed when receiving an HTTP 429 error.
- Fixed an issue with session timeouts by adding the DEFAULT_TIMEOUT_IN_SECOND session parameter.
Version 2.0.19 (November 16, 2022)
New Features
- Updated the System.Text.RegularExpressions library to version 4.3.1.
Version 2.0.18 (November 02, 2022)
BCR (Behavior Change Release) Change
Caution: Version 2.0.18 of the Snowflake .NET driver changed the way it handles escaping the equal sign (=) in connection strings to match the .NET specification. Specifically, if a password contained an equal sign, you had to escape the character by using double equal signs (==). If your projects are affected by breaking changes related specifically to special characters, Snowflake recommends that you do not install this version into a production environment before testing.
New Features
- Improved PUT and GET command queries:
- Query strings are case-insensitive.
- White space is allowed at the start and end of query strings.
- White space is permitted in file paths for PUT queries.
- Added the CLIENT_SESSION_KEEP_ALIVE configuration property to prevent a session from timing out.
- Added ability to execute a batch of SQL statements (multi-statement support).
- Added support for connecting to proxy servers.
Bug Fixes
- Changed special character handling in connection strings to match the Microsoft .NET specifications.
Version 2.0.17 (October 3, 2022)
Bug Fixes
- Added the SetPooling() function to enable and disable connection pooling.
Version 2.0.16 (August 24, 2022)
BCR Change
Caution: Version 2.0.16 of the Snowflake .NET driver includes an update that replaces targeting .NET Standard 2.0 with .NET 6.0. If your projects are affected by breaking changes related specifically to .NET 6.0, you must update your framework or project to use the new version. Snowflake recommends that you do not install this version into a production environment before testing.
Bug Fixes
- Fixed an issue where unicode characters appended an extra "u" for large streams (e.g "/u007f" becomes "/u007fu").
Version 2.0.15 (July 19, 2022)
Bug Fixes
- Updated the exception thrown for incorrect private key.
Version 2.0.14 (June 23, 2022)
New Features
- Updated SnowflakeDbException.ToString to include more error details.
- Added support for bulk array binding.
- Added support for connection pools.
Version 2.0.13 (May 18, 2022)
New Features
- Added option to disable automatically retrying to connect when a connection fails or drops.
- Added byte encryption bytes to read and write chunks for the PUT command.
Bug Fixes
- Resolved an issue where DEL characters displayed incorrectly.
Version 2.0.12 (May 06, 2022)
New Feature
- Added support for the GET command.
Version 2.0.11 (Mar 15, 2022)
New Feature
- Added support for the PUT command.
Version 2.0.10 (Feb 16, 2022)
Bug Fixes
- Resolved issues with asynchronous warning messages returned by the Snowflake ChunkDownloader.
Version 2.0.9 / 1.2.9 (Jan 18, 2022)
Bug Fixes
- Fixed an issue with external browser authentication on non-Windows platforms.
- Returned TIMESTAMP values now defaults to DateTimeKind.Unspecified instead of DateTimeKind.Utc
- Made the chunk downloader's parser run asynchronously.
