This article contains the release notes for the Node.js 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, Node.js 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 1.8.0 (Aug 28, 2023)
New Features and Updates
- Added support for Node.js version 18.
- Added a new rowMode configuration option to specify how to return results sets that contain duplicate column names, including as an:
- array
- object
- object_with_reanamed_duplicate_columns
- Upgraded a minor urllib version and deleted the vm2 exclusion.
Bug Fixes
- Fixed an issue where the moment.js library incorrectly populated the millisecond position for times in the log messages.
- Fixed an issue with getting files from stages in Windows and Azure environments.
- Fixed an issue where external browser authentication incorrectly required a username and password.
Version 1.7.0 (July 28, 2023)
New Features and Updates
- Added support for initializing the JSON parser and XmlParser with a custom configuration.
Bug Fixes
- Excluded a vulnerable vm2 transitive dependency.
- Added the browserActionTimeout connection parameter to fix an issue with authentication in an external browser.
- Fixed an issue with private keys that contained new lines at the end of the key.
- Fixed an issue related to importing a uuid library.
- Removed an unused qs dependency.
- Fixed a retry issue in a LargeResultSet.
- Replaced the better-eval package with vm.
- Removed requirement for a username for OAuth connections.
Version 1.6.23 (June 14, 2023)
New Features and Updates
- Added the
connection.isValidAsync() function to determine whether a connection is up and usable.
Bug Fixes
- Fixed an issue where some stage files were not downloaded correctly during a multi-file download.
- Modified the the
fetchAsString error message to include 'Buffer' as an accepted type. - Fixed a performance issue with stage bindings.
- Fixed issue that where
connection.execute() did not return a Statement in bind mode. - Fixed the
connection.heartbeatAsync() to use the same endpoint as connection.heartbeat() function is using instead of querying with Select 1.
Version 1.6.22 (May 24, 2023)
New Features and Updates
Bug Fixes
- Added the missing bn and https-proxy-agent dependencies.
- Fixed an issue where econnreset and etimedout error codes would not retry the connection.
- Fixed the error message that was returned when calling connection.execute() with a requestId failed.
- Fixed the error message that was returned for calling connect() failed when using OKTA or an external browser authenticator.
- Fixed the maskedtxt variable undefined error.
- Fixed an issue that occurred for multiple connections when using a OAuth authenticator.
- Fixed an issue where calling connection.execute() with extra whitespace in sqltext caused errors.
- Fixed an issue where retrying a connection failed due to using the wrong value in the sleep timer.
Version 1.6.21 (April 18, 2023)
New Features and Updates
- Added support for GCS access token for PUT/GET.
- Added support for Okta Identity Engine (OIE) logins.
- Improved security when parsing JSON strings with the eval function.
Bug Fixes
- Fixed a parsing issue with XML data loaded from VARIANT columns.
- Fixed an issue where the OCSP cache was not refreshed when it expired.
- Fixed an issue where using a full table path on array binding could crash the application.
- To resolve a deprecation warning issue related to the Buffer() deprecation, please reinstall snowflake-sdk. Reinstalling updates the formstream library to the latest version, i.e. formstream 1.2.0, and resolves the issue.
Version 1.6.20 (March 23, 2023)
New Features and Updates
Bug Fixes
- The Node.js driver now supports retrying on an HTTP 429 error code.
- Fixed an issue where the Node.js driver would not sent OCSP requests through proxies.
- Fixed an issue where errors occurred when the amount of data submitted using array binding exceeded the array binding threshold. The driver now produces output for ingest instead of failing the SQL statement.
- Fixed an issue that incorrectly generated "Bind variable ? not set" error messages after upgrading from version 1.6.13 to a higher version.
Version 1.6.19 (February 27, 2023)
New Features and Updates
Bug Fixes
- Fixed an issue where an insert query failed intermittently when trying to insert large amounts of data with array binding (#419).
Version 1.6.18 (January 31, 2023)
New Features and Updates
- Added the ability to execute a batch of SQL statements (multi-statement support).
- Updated the jsonwebtoken library to version 9.0.0.
Bug Fixes
- Improved performance by sending heartbeat messages instead of select calls to verify endpoint connections.
- Added error details to the log messages for OCSP open failures and changed the log level from info to warning.
- Added a check to verify that the OCSP cache is initialized before setting the cache entry.
Version 1.6.17 (December 14, 2022)
New Features
- Fixed an issue where supplying an incorrect password could cause an infinite loop when attempting to log into a connection pool.
- Added the arrayBindingThreshold connection parameter for array binding, which directs the Node.js Driver to write an array to a file and upload it to the server when the number of binds exceeds the threshold.
Version 1.6.16 (November 18, 2022)
New Features
- Added a noProxy configuration parameter to support bypassing the proxy server when needed.
- Updated the moment library to version 2.29.4.
Version 1.6.15 (October 28, 2022)
New Features
- Removed the requirement to provide the original SQL query in addition to the requestId when resubmitting requests.
- Updated mocha to version 10.1.0.
Version 1.6.14 (September 21, 2022)
New Features
- Added support for array binding.
Version 1.6.13 (August 23, 2022)
Updates
- Added the ability to resubmit SQL statements with a request ID.
Version 1.6.12 (June 25, 2022)
Updates
- Added the readme.md file to the npm project description.
- Set the default timeout for HTTP requests to 360 seconds.
Bug Fixes
- Fixed an issue regarding inaccurate encryption material IDs for numbers exceeding the maximum safe integer.
Version 1.6.11 (June 23, 2022)
Bug Fixes
- Fixed an issue for proxy connection not working.
Version 1.6.10 (May 25, 2022)
Bug Fixes
- Fixed an issue where the application configuration parameter was not being recognized.
- Fixed an issue where the PUT command did not overwrite data when the OVERWRITE argument was set to TRUE.
- Fixed an issue where the OKTA authenticator threw an error when the closing slash ("/") was missing; now it authenticates whether or not the slash in provided.
- Fixed an issue where the OKTA authenticator failed to authenticate accounts that included a region in the connection string.
Version 1.6.8 (Mar 17, 2022)
Bug Fixes
- Updated "npm test" to run all unit tests.
- Added a confirmation message when a connection is authenticated.
- Update agent-base and https-proxy-agent to latest version.
Version 1.6.7 (Feb 16, 2022)
Bug Fixes
- Updated the required version of the follow-redirect package to 1.14.18.
- Updated the version of the mocha test framework to 9.2.0.
