Salesforce

Client Release History

« Go Back

Information

 
Article Body

We regularly update our client software to provide performance, security, and usability improvements, and to fix customer-reported issues. This article lists changes and fixes that may impact your usage of the following Snowflake clients:

  • SnowSQL (CLI)
  • ODBC Driver

In addition, this article lists changes and fixes that may impact your usage of the following Snowflake libraries:

  • Snowpark

For information about the other Snowflake clients, see the change logs and release notes provided in their repositories in snowflakedb (in Github):

For more information about a particular Snowflake release, see Releases.

Back to: Announcements.


Client / Library Releases (by Month)

Within each month, the list is organized by client or library and version. Descriptions are provided only for the changes/fixes made to recent versions of each client. For descriptions of all the changes/fixes made to a particular client, see Client Changes by Version (in the Snowflake Documentation).

For the changes to the JDBC Driver, see the change log for the JDBC Driver in GitHub.

August 2021

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
Snowpark
0.8.009-Aug-2021Improvements
  • Refactored some internal code to remove some dependencies.
Bug Fixes
  • Fixed an issue with BigDecimal literals in cases where scale might be larger than precision.
  • Fixed an issue that could occur when performing multiple set operations (e.g. union, intersect, etc.).
The API reference for this release is available in a .zip or .tar.gz file in the Snowflake Client Repository.
5.30.x

 

July 2021

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
Snowpark
0.7.023-Jul-2021New APIs
  • Introduced the new Session.close() method. Call this method to close the Snowpark session, which cancels all running queries and prevents the subsequent use of this session to execute queries.
  • Introduced the new Updatable class. Updatable extends the DataFrame class and provides additional table-related capabilities (e.g. the ability to update and delete values).
  • The Session.table() method now returns an Updatable object, rather than a DataFrame object.
  • Introduced new signatures for the registerTemporary methods in the UDFRegistration class. These signatures do not have a parameter for the name of the UDF, which means that you can use these to register an anonymous temporary UDF.
API Changes
  • As mentioned in New APIs, the Session.table() method now returns an Updatable object, which extends DataFrame.
  • In the Geography class, removed support for formats other than GeoJSON. Now, Geography only supports the GeoJSON data format.
Improvements
  • Improved the DataFrame.cacheResult() method to reduce the possibility of “object already exists” errors.
  • Improved some error messages.
  • Added a new log message that prints out session information after you log in.
Bug Fixes
  • Fixed an issue in which the DataFrame.show() method did not display binary data correctly.
  • Fixed an error that occurred when getting the version number.
The API reference for this release is available in a .zip or .tar.gz file in the Snowflake Client Repository.
5.29.x
SnowSQL 
1.2.1730-Jul-2021
  • SNOW-378268: Fixed a Python Connector problem that prevented the connector from using AWS S3 regional URLs with the PUT command.
5.29.x
ODBC Driver
2.23.315-Jul-2021
  • SNOW-293206: Added ability to return argument names from SQLProcedureColumns().
  • Added option to set PUT_COMPRESSLV as a connection / configuration parameter.
  • Fixed an issue with the UPDATE/DELETE/INSERT statements where parameter array binding failed in some cases.
  • Fixed an issue where DEFAULT_VARCHAR_SIZE and DEFAULT_BINARY_SIZE did not work with SQLColumn().
  • Added support for streaming values for the bind variables SQLParamData() and SQLPutData().
  • SNOW-355132: Added feature to make CURLOPT_MAXAGE_CONN configurable.
  • Fixed an issue where arrow chunk downloading caused a crash.
  • Upgraded OpenSSL from 1.1.1i to 1.1.1k.
  • SNOW-350996: Changed behavior so that the PUT command does not retry when the file being processed already exists in the stage.
  • Fixed an issue where AWS logging caused a crash when using multiple threads.
5.27.x

 

June 2021

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
SnowSQL
1.2.1621-Jun-2021
  • SNOW-365900: Fix for incorrect JWT token invalidity when an account alias with a dash in it is used for regionless account URL.
5.22.x
1.2.1504-Jun-2021
  • SNOW-303944: Added command-line flags to generate JSON Web Tokens (JWT) in SnowSQL.
5.20.x


May 2021

No SnowSQL or ODBC Driver releases.
 

April 2021

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
ODBC Driver
2.23.229-Apr-2021
  • SNOW-293206: Added support for SQLProcedureColumns.
  • Fixed a bug with SQLColumns() and the GEOGRAPHY data type.
  • SNOW-291407: Added connection / configuration parameters for specifying the default sizes of BINARY and VARCHAR columns when the column size is undetermined.
  • Improved performance when using TRACING=6.
  • Improved the performance of the secret detector.
  • Improvements for log settings.
  • When the ODBC version is 3 or higher, the ODBC Driver now uses SQL_TYPE_DATE, SQL_TYPE_TIME and SQL_TYPE_TIMESTAMP as the data types of date, time and timestamp.
  • SNOW-334403: ODBC now generates regional url for aws us-east-1.
5.15.x
2.23.101-Apr-2021
  • SNOW-249530: Updated the driver to send only supported statements in SQLPrepare (including SELECT, DML, and SHOW statements). Prior to this change, if a statement was not supported in SQLPrepare (e.g. BEGIN, SET, or COMMIT), the driver would send the statement in SQLPrepare, and the server would return an error.
  • SNOW-269456: Fixed a null pointer issue with timestamps.
  • Escaped unsafe characters in parameters in the connection string.
  • Added a configuration / connection parameter for specifying the temporary directory for PUT commands.
  • Captured the use of the session context in the telemetry.
  • SNOW-282587: Without a sqlfetch the query is canceled.
5.10.x

 

March 2021

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
SnowSQL
1.2.1418-Mar-2021
  • SNOW-298813: Fix for Progress percentage computation to handle the case when file size is zero.
5.7.x
1.2.1310-Mar-2021
  • SNOW-270946: Fix a zero division error while computing progress percentage which gets triggered when the size of file to upload/download is 0.
5.7.x
1.2.1202-Mar-2021
  • SNOW-293541: Released Mac package with renewed Developer Installer Certificate.
5.7.x
ODBC Driver
2.23.010-Mar-2021
  • SNOW 194654: Added support for caching MFA tokens.
  • SNOW-239674: Updated the driver to capture escape characters in telemetry.
  • Set a default value for the CA certificate bundle file name.
  • Update the driver to free up memory when downloading chunks of results in Arrow format .
  • SNOW-274791: Updated the driver to prevent overscoping when listing foreign keys.
  • SNOW-295726: Added a secret detector and masking module.
  • SNOW-278585: Added support for using the Arrow data format for transferring data to Snowflake.
5.7.x


February 2021

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
SnowSQL
1.2.1109-Feb-2021
  • SNOW-232777: Added proxy CONNECT headers for connections made over proxies.
5.2.x
JDBC Driver
3.13.018-Feb-2021
  • SNOW-136474: Changed the default value of the multi-part threshold from 64 to 200, and changed the JDBC Driver to read this parameter from the server.
  • SNOW-165204: Fixed a number overflow exception that resulted from calling getObject() on a SQL BIGINT value.
  • SNOW-180954: As previously announced, removed the JNA classes from the Snowflake JDBC Driver JAR file.
  • SNOW-209530: Changed the handling of proxy settings. Proxy parameters in the connection string now override the JVM proxy settings. When connecting to Azure, PUT / GET commands now go through the specified proxy.
  • SNOW-250222: Fixed an exception thrown by the COPY INTO command when the JDBC Driver inserts more than INT_MAX records from a single file.
  • SNOW-251457: Changed the ResultSet.getString() method to return DATE objects in the session time zone (rather than use the offset from the JVM time zone).
  • SNOW-255552: Fixed a null pointer exception in ResultSet.getCharacterStream().
5.2.x
ODBC Driver
2.22.516-Feb-2021
  • SNOW-78018: Updated the driver to return the query ID for a successful ODBC call that executes the PUT / GET command.
  • SNOW-215983: Added support for unicode in folder names in PUT / GET statements.
  • SNOW-219403: Added support for specifying the PUT_FASTFAIL and PUT_MAXRETRIES parameters in the simba.snowflake.ini file.
  • SNOW-269456: Upgraded the version of Arrow to 0.17.0.
  • SNOW-275777: Updated the driver to use JSON format for Win32 applications when exchanging data with Snowflake.
5.2.x

 

January 2021

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
JDBC Driver
3.12.1712-Jan-2021
  • SNOW-174428: Changed bulk array binding to use an input stream to send the data to the server, rather than creating a file on the local machine and upload the file to the server.
  • SNOW-213443: Added a configurable Java system property for the “time to live” for connections to the Snowflake database.
  • SNOW-257198: Updated the version of the Google Guava library from 28.0 to 30.0 to address a vulnerability.
5.0.x
ODBC Driver
2.22.414-Jan-2021
  • SNOW-218025: Driver catches exceptions during the heartbeat sync, which prevents crashes during large (10GB) uploads.
  • SNOW-240901: Added Security Verification for Query Texts.
  • SNOW-218019: Updated the telemetry payloads.
  • SNOW-195691: Added support for the SQLProcedures() function.
5.0.x

 

December 2020

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
JDBC Driver
3.12.1607-Dec-2020
  • SNOW-206907: Added support for downscoping GCS credentials, which can be used instead of pre-signed URLs.
4.41.x
ODBC Driver
2.22.311-Dec-2020
  • SNOW-197194: Improved the error message for ODBC SSL Certificate failures.
  • SNOW-201816: Reverted a change that overwrote proxy configurations that were set in environment variables.
  • SNOW-219403: Added support for configurable parameters to enable fast fail and specify the maximum number of retries for PUT command failures.
4.41.x

 

November 2020

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
JDBC Driver
3.12.1517-Nov-2020
  • SNOW-207061: Fixed a problem with null checking when converting to timestamp values.
4.38.x
ODBC Driver
2.22.209-Nov-2020
  • SNOW-199839: Added inband telemetry when the PUT command fails.
  • SNOW-200183: Added the EnablePidLogFileNames configuration parameter, which causes different processes to generate separate log files.
  • SNOW-201047: Added exceptions for unsupported features to inband telemetry.
  • SNOW-201816: Fixed a problem where the proxy details could not be cleared after being set in the driver.
  • SNOW-204142: When enabled, SQL_DESC_TYPE_NAME returns the GEOGRAPHY type when GEOGRAPHY_OUTPUT_TYPE is GeoJSON (not (E)WKT or (E)WKB).
  • SNOW-209045: Fixed a problem where a crash occurred with concurrent connections.
  • SNOW-213639: Fixed ODBC bulk array binding errors that occurred when parsing data in DATE format.
4.38.x

 

October 2020

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
JDBC Driver
3.12.1427-Oct-2020
  • SNOW-150601: Suppressed a warning about illegal reflective access.
  • SNOW-163265: Fixed an issue when the getDate method passes in a Calendar object.
  • SNOW-201788: Prevented attempts to drop a column that is part of clustering key when generating a temp table.
  • SNOW-204185: Fixed an edge case in which ResultSet.next() can hang when the ResultSet data downloader threads hit unexpected errors.
  • SNOW-208695: Updated the junit version from 4.12 to 4.13.1.
4.36.x
3.12.1306-Oct-2020
  • SNOW-161733: Improved the performance of the setString method.
  • SNOW-174837: Upgraded google-oauth-client from 1.30.4 to 1.31.0 to address a security vulnerability.
  • SNOW-194437: Fixed a problem where performing an INSERT with bind values of the TIME type did not trigger bulk array loading through a stage.
  • SNOW-195989: Fixed issue where driver was unable to connect via Key-Pair authentication if the private key was encrypted and if the key was generated using OpenSSL 1.1.1g on Windows or Ubuntu.
  • SNOW-199080: Updated the GPG key used for package validation.
  • SNOW-201613: Addressed CVE-2019-10172.
4.32.x
ODBC Driver
2.22.112-Oct-2020
  • SNOW-170804: Addressed a security vulnerability finding for util-linux-v2.33.1.
  • SNOW-170805: Addressed a security vulnerability finding for openssl-OpenSSL_1_1_1b.
  • SNOW-177073: Driver now sends inband telemetry objects for metadata API calls.
  • SNOW-178485: Addressed a security vulnerability finding for openssl-1.1.1b-v1.1.1b.
  • SNOW-197540: Added metadata to the telemetry for derived ODBC Show commands.
4.33.x

 

September 2020

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
SnowSQL
1.2.1014-Sep-2020
  • SNOW-170647: Removed an unnecessary dependency.
4.31.x
JDBC Driver
3.12.1214-Sep-2020
  • SNOW-180303: Removed unnecessary log lines from the driver log.
4.31.x
ODBC Driver
2.22.014-Sep-2020
  • SNOW-170120: Added the configuration parameter EnableAutoIpdByDefault to override the default value of SQL_ATTR_ENABLE_AUTO_IPD.
  • SNOW-181235: Addressed a connection issue introduced in version 2.21.8.
  • SNOW-183721: Updated the CACert Bundle in the driver.
  • SNOW-184163: Improved PUT performance by using /dev/urandom as the default device.
  • SNOW-187198: Fixed support for the CLIENT_MEMORY_LIMIT parameter, which is used as a max memory limit for Chunk downloading.
  • SNOW-187534: Masked signatures in GCP URLs in logs.
4.31.x

 

August 2020

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
SnowSQL
1.2.906-Aug-2020
  • SNOW-181011: Fixed missing dependency for keyring package, which caused issues when connecting using authenticator = externalbrowser.
4.27.x
1.2.804-Aug-2020
  • SNOW-123267: Support added for forcing quit by pressing [CTRL]-c twice. Note that, if you use this option, SnowSQL does not verify previously-started queries were successfully canceled.
  • SNOW-159538: Internal improvement for masking logs for sensitive information.
4.27.x
JDBC Driver
3.12.1124-Aug-2020
  • SNOW-176125: When the log level is set to DEBUG, the driver now logs the OOB telemetry entries that are sent to Snowflake.
  • SNOW-182450: Added in-band telemetry metrics for the DatabaseMetaData get methods (e.g. getTables).
4.29.x
3.12.1003-Aug-2020
  • SNOW-136193: Fixed issue where driver adjusted DLS for some values that are towards the DLS switch, resulting in a wrong result.
  • SNOW-164505: Implemented telemetry events where needed.
  • SNOW-170758: Implemented SAML/SSO in driver when using ExternalBrowser.
4.27.x
ODBC Driver
2.21.817-Aug-2020
  • SNOW-160149: Set Min version of the driver to receive Arrow result set.
  • SNOW-170279: Added usage stats of SqlPrepare Defer execution stats to CLIENT_ENVIRONMENT.
  • SNOW-175663: Enabled multi-statement support.
  • SNOW-175667: Increased the PUT threshold value on the server side to 200MB.
  • SNOW-177137: Added new UseURandomDevice parameter that changes the driver to use /dev/urandom instead of /dev/random.
4.29.x

 

July 2020

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
JDBC Driver
3.12.914-Jul-2020
  • SNOW-170944: Security enhancement for improved masking of sensitive data.
  • SNOW-171834: Internal fix.
4.24.x
ODBC Driver
2.21.723-Jul-2020
  • SNOW-101559: Fixed issue where PUT command with slashes did not work as documented.
  • SNOW-156582: Fixed the following error that occurred when uploading a file into AWS S3 internal stage using PUT command: AwsSdk::AWSClient::: No response body. Response code: 404.
  • SNOW-159839: Fixed issue with reading and writing data containing an em-dash when using the latest Snowflake ODBC driver with Informatica Cloud Services.
  • SNOW-162610: Performance improvements for using PUT commands with internal stages.
  • SNOW-163154: Fixed issue where PUT commands failed when no file extension was specified.
  • SNOW-163664: Fixed issue for Private Preview feature.
  • SNOW-165820: Fixed issue where PUT commands did not upload files without returning errors.
  • SNOW-168900: Fixed issue where the driver continued to open connections to localhost when successive PUT commands were issued; this caused excessive TCP connections (in 3rd-party connectors for Attunity and Razorsql).
  • SNOW-169965: Added Logging level to client environment telemetry.
  • SNOW-170115: For Windows, fixed issued where PUT commands failed even when an escape character was provided and delimited using single quotes.
  • SNOW-170233: Fixed issue where PUT / GET commands fail when paths use forward slashes.
4.25.x

 

June 2020

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
SnowSQL
1.2.725-Jun-2020
  • SNOW-150710: Added new custom sql_delimiter variable to enable specifying a character other than a semi-colon as the delimiter for SQL statements.
  • SNOW-170458: Fixed an issue where SnowSQL failed on multi-line queries, which was caused by a regression introduced in the SnowSQL 1.2.6 internal release.
4.22.x
1.2.6Version is not available for download.
JDBC Driver
3.12.822-Jun-2020
  • SNOW-163938: Fixed OOB telemetry response failures.
  • SNOW-163587: Fixed issue where DatabaseMetaData getFunctionColumns(null, "%", "%", "%") threw a SQL compilation error.
  • SNOW-164084: Reverted a fix that broke OOB telemetry for the driver.
  • SNOW-165718: Internal fix.
  • SNOW-169174: Fixed security issues (CVE-2020-14061, CVE-2020-14062, CVE-2020-14060, CVE-2020-14195) by upgrading Jackson Databind to version 2.9.10.5 (or later).
4.22.x
3.12.7Version is not available for download; all fixes were rolled into 2.12.8.
3.12.601-Jun-2020
  • SNOW-146005: Fixed issue where using the Spring Data JDBC SimpleJdbcInsert class to execute a SQL statement threw an exception.
  • SNOW-150921: Fixed issue where the connection was retrying the OCSP endpoint while using insecureMode; updated the driver to use OCSP mode specified in the session config for OOB telemetry.
  • SNOW-152748: Added new connection parameter, stringsQuotedForColumnDef, to support changes to how the DatabaseMetaData.getColumns() and DatabaseMetaData.getProcedureColumns() methods return COLUMN_DEF string values with or without single quotes.
  • SNOW-157758: Internal fix for pending feature.
  • SNOW-163080: Performance improvements for calling Resultset.next() after queries have completed.
4.19.x
ODBC Driver
2.21.622-Jun-2020
  • SNOW-135244: For Windows, fixed issue where externalbrowser authentication was not working properly.
  • SNOW-143536: Added the NoExecuteInSQLPrepare parameter to enable controlling how DDL statements are handled in SQLPrepare and SQLExecute.
  • SNOW-158500: Fixed issue where queries executed with the driver showed failing DESCRIBE_QUERY results; related to the fix for SNOW-143536.
  • SNOW-160829: Fixed performance issue caused by driver not picking up schema/database.
4.22.x
2.21.508-Jun-2020
  • SNOW-45633, SNOW-144591: Support added for bulk array binding.
  • SNOW-75496: For Snowflake accounts hosted on GCP, support added for PUT and GET commands.
  • SNOW-165067: Security fix.
4.20.x
2.21.4Version is not available for download; all fixes were rolled into 2.21.5.

 

May 2020

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
JDBC Driver
3.12.512-May-2020
  • SNOW-115446: For Snowflake accounts on GCP, fixed issue where PUT commands failed due to incorrect filename passed by the compressAndUploadStream method; fix was required to implement GCP support for the Snowflake Connector for Kafka.
  • SNOW-143877: Internal fix for pending feature.
  • SNOW-150593: Fixed issue where Snowflake throws a ConcurrentModificationException error when attempting to close ResultSets (from GitHub #212).
  • SNOW-152637: Internal fix for pending feature.
  • SNOW-153278: Internal fix for pending feature.
  • SNOW-154633: Added required JDBC licenses in preparation for generating javadoc.
  • SNOW-154927: Fixed security issues (CVE-2020-10969, CVE-2020-9546, CVE-2020-11620, CVE-2020-10672) by upgrading Jackson Databind to version 2.9.10.4.
  • SNOW-156092: Fixed Spark/JDBC NullPointerException in getObject().
  • SNOW-155630: Internal fix for pending feature.
  • SNOW-158363: Internal fix for pending feature.
4.16.x
ODBC Driver
2.21.311-May-2020
  • SNOW-136211: Implemented Arrow Bulk fetch.
  • SNOW-157756: Notarized mac package.
4.16.x

 

April 2020

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
JDBC Driver
3.12.421-Apr-2020
  • SNOW-86734: Driver now includes client information, including name, version, language, language version, and OS information, in the USER-AGENT HTTP header.
  • SNOW-136193: Fixed a wrong result issue caused by the driver adjusting DLS (daylight savings) for NTZ timestamp values that are near the time when DLS switches from ST (standard time).
  • SNOW-146005: Fixed issue that occurs in Spring JDBC when using SimpleJdbcInsert.
  • SNOW-153256: Added more verbose error handling to Telemetry Service.
  • SNOW-153485: Internal change for pending feature.
4.13.x
ODBC Driver
2.21.227-Apr-2020
  • SNOW-52894, SNOW-152727, SNOW-152768, SNOW-153310: Fixed issues related to GA of secure SSO ID tokens to support browser-based SSO (for Windows and macOS only).
  • SNOW-140235: Fixed issue where using yum to upgrade the driver to a new version deleted the driver RPM, which caused the upgrade to fail.
  • SNOW-147376: Fixed issue where OOB (Out Of Band) Telemetry did not capture connections if curl code was not set to CURL_OK.
  • SNOW-150687: Fixed the following session expiration error for long running queries: "GS error code=390112, GS error message=Your session has expired. Please login again"
  • SNOW-151169: Upgraded curl to 7.68.0.

Important: This version of the driver implements production-ready support for browser-based SSO with connection caching, which was previously available as a preview feature (Windows and macOS only).

Because this feature requires Snowflake release 4.14, which is currently in progress, you should not upgrade to version 2.21.2 of the driver until you confirm that the release is complete. In particular, if you were participating in the feature preview with an earlier version of the driver (e.g. 2.20.5), you should continue using the earlier version until the release is complete.

4.14.x

 

March 2020

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
JDBC Driver
3.12.330-Mar-2020
  • SNOW-75286: Driver no longer displays sensitive data in logs and exceptions.
  • SNOW-117429: Internal fix.
  • SNOW-144823: Fixed memory leak when the Telemetry Service calls a Shutdown Hook (for PUT commands on short-lived connections).
  • SNOW-147672: For the FIPS-compliant version of the driver, fixed CVE-2020-8840 and CVE-2019-20330 security issues by upgrading com.fasterxml.jackson.core:jackson-databind to version 2.9.10.3 (or later). Similar fix was introduced in version 3.12.2 of the non-FIPS-compliant driver.
4.11.x
3.12.210-Mar-2020
  • SNOW-121867: Fixed issue where SnowflakeConnectionV1.uploadStream() automatically appended @ to correct stage names, which prevented uploads using escaped internal table stages.
  • SNOW-141984: Enhanced the JDBC file transfer API to support proxy for Spark.
  • SNOW-142833: Fixed CVE-2019-20330 and CVE-2020-8840 security issues by upgrading com.fasterxml.jackson.core:jackson-databind to version 2.9.10.3 (or higher).
4.9.x
ODBC Driver
2.21.130-Mar-2020
  • SNOW-139254: Internal enhancement.
  • SNOW-147190: Removed unnecessary {"message":"Limit Exceeded"} error message from displaying in output buffer.
  • SNOW-147420: Fixed issue that caused a driver failure when a property in the connection string was too long.
  • SNOW-148261: Fixed issue with incorrect Heartbeat endpoint that caused the CLIENT_SESSION_KEEP_ALIVE parameter to fail if set to true; this was a regression introduced in version 2.20.5.
4.11.x
2.21.011-Mar-2020
  • SNOW-75961: Set ODBC SQL_ATTR_ENABLE_AUTO_IPD default value to true. This reverts the change introduced in version 2.20.0 of the driver.
  • SNOW-120324: For macOS and Windows, implemented additional updates to support secure SSO ID tokens (preview feature).
  • SNOW-137581: For Linux, implemented guarding of getaddrinfo() with mutex in libcurl; also introduced ForceLockGetaddrinfo parameter in ODBC configuration settings to fix segmentation fault when application is not pthread compatible.
  • SNOW-139281: For Linux, disabled SSO ID token cache.
  • SNOW-141543: Fixed issue with rendering of results for LIST and REMOVE commands.
  • SNOW-141622: Updated SSO ID token secure storage to make it ODBC-specific, rending it inaccessible to other drivers.
4.9.x

 

February 2020

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
SnowSQL CLI
1.2.519-Feb-2020
  • SNOW-135171: Updated the SnowSQL distribution to allow specifying the install location.
  • SNOW-136164: Fixed issue where SnowSQL could not be installed if ~/.snowsql doesn't exist.
4.5.x
JDBC Driver
3.12.118-Feb-2020
  • SNOW-29974: Added binding support for TIMESTAMP_TZ (including timezone).
  • SNOW-128360: Fixed NoSuchMethodError: org.slf4j.helpers.MessageFormatter.arrayFormat issue for MATLAB.
  • SNOW-134689: Increased multi-part upload threshold to 64MB for PUT commands.
4.5.x
3.12.002-Feb-2020
  • SNOW-68471: Added CLIENT_METADATA_USE_SESSION_DATABASE to scope the database for metadata access; default value is false.
  • SNOW-103629: Implemented using the FIPS S3 endpoints for regions in FIPS mode.
  • SNOW-122286: On AWS, when OVERWRITE is false, which is the default value, the file is uploaded if no file with the same name exists in the stage. The previous behavior checked the content signature, but now no longer checks. No change to Azure and GCP, which already implemented this behavior.
  • SNOW-124868: Added new statement types for LIST, GET, PUT, RM commands.
  • SNOW-125221: Fixed issue with getStringFunctions() that does not return all supported string functions.
  • SNOW-128360: Fixed slf4j compatibility issue with MATLAB.
4.3.x
ODBC Driver
2.20.525-Feb-2020
  • SNOW-120324: For macOS and Windows, added support for secure SSO ID tokens; this enables applications to use browser-based SSO while minimizing the number of authentication popups when connecting to Snowflake.
  • SNOW-123641: Added support for multi-threading in the driver to implement thread-safety in snowflake native objects.
  • SNOW-134689: Increased multi-part upload threshold to 64MB for PUT commands.
  • SNOW-139112: Fixed potential security issue due to raw message logging.
4.6.x

 

January 2020

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
SnowSQL CLI
1.2.431-Jan-2020
  • SNOW-126786: On GCP, fixed exception when using PUT to upload a file to a stage with AUTO_COMPRESS=FALSE.
  • SNOW-134305: Increased threshold to 64MB for multi-part upload to S3.
4.2.x
1.2.323-Jan-2020
  • SNOW-93304: Full/main SnowSQL module included in the bootstrap distribution to facilitate offline/hosted installation.
  • SNOW-120329: Added support for OAuth token authentication method.
4.1.x
JDBC Driver
3.11.106-Jan-2020
  • SNOW-121276: Added support for serializing SnowflakeDataSource objects.
  • SNOW-121287: Added CLIENT_ENABLE_LOG_INFO_STATEMENT_PARAMETERS for logging statements and binding data in INFO log level.
  • SNOW-122023: Fixed the order of escapeChars for getTables and getColumns.
  • SNOW-123702: Updated BouncyCastle to 1.60 to fix two high severity issues.
  • SNOW-124928: Fixed precision loss when using getFloat or getDouble for Decimal values that have large scale.
3.56.x
ODBC Driver
2.20.428-Jan-2020
  • SNOW-121054: Reduced unnecessary calls to ALTER SESSION SET AUTOCOMMIT=TRUE.
4.1.x
2.20.307-Jan-2010
  • SNOW-124921: Merged partner code changes to implement partner requests and fix reported issues.
  • SNOW-126811: Changed the behavior of the PUT command that skips file upload if the file exits in the stage and no overwrite option is set.
3.56.x

 

December 2019

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
SnowSQL CLI
1.2.216-Dec-2019
  • SNOW-75495: Internal change for pending feature.
  • SNOW-121787: Pinned the keyring version to 19.2.0.
  • SNOW-122376: Fixed issue with no content cache for downloading newer version of SnowSQL.
  • SNOW-122797: For MacOS Catalina 10.15.1, fixed oscrypto and OpenSSL conflict.
3.55.x
1.2.105-Dec-2019
  • SNOW-106130: Added Cask Installer for SnowSQL 1.2.0.
  • SNOW-110191: Enabled fix_parameter_precedence connection parameter to true for SnowSQL.
  • SNOW-118881: Added .zprofile support to SnowSQL installer.
3.53.x
JDBC Driver
3.11.002-Dec-2019
  • SNOW-70240: Added connection parameter help to the JDBC command line.
  • SNOW-75486: Added support for key pair parameters in JDBC connection string.
  • SNOW-84438: General availability for ARROW format support; to be enabled in the next few weeks.
  • SNOW-98693: Implemented DriverPropertyInfo (related to SNOW-70240).
  • SNOW-105117: Fixed issues with retrieving results on GCP.
  • SNOW-115434: Implemented writeable check on file cache, with support for changing to a temp directory if the cache is not writable (from GitHub #188).
  • SNOW-115735: Fixed performance issue caused by frequent calls to ALTER SESSION; calls reduced by setting and caching AUTOCOMMIT session parameter.
  • SNOW-116121: Fixed issue with result set producing wrong result for date 0200-02-28.
  • SNOW-119059: Improved error message when required proxy parameter is missing.
  • SNOW-119801: Upgraded the Arrow library to 0.15.1.
  • SNOW-120495: Added support for OAuth token to SnowflakeBasicDataSource (from GitHub #194).
3.53.x
ODBC Driver
2.20.202-Dec-2019
  • SNOW-91853: Fixed issue where system locale takes precedence over any locale settings in the driver.
  • SNOW-110240: For Linux, fixed segmentation violation error that occurred when using PUT with SAS for Snowflake accounts on Azure.
  • SNOW-115888: For Windows, fixed issue that occurred with large file uploads when using PUT for Snowflake accounts on Azure.
  • SNOW-121236: Fixed issue where CLIENT_METADATA_REQUEST_USE_CONNECTION_CTX and CLIENT_SESSION_KEEP_ALIVE parameters could not be set in the ODBC connect string.
3.53.x

 

November 2019

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
SnowSQL CLI
1.2.011-Nov-2019
  • SNOW-110647: Moved upgrade repository from S3 to sfc-repo; original S3 repository is still available for earlier versions.
3.51.x
JDBC Driver
3.10.309-Nov-2019
  • SNOW-86551: Internal change for pending feature.
  • SNOW-97749: Enabled proxy support for JDBC ResultSet distributed process.
  • SNOW-110357: Fixed CVE-2019-16942 security vulnerability.
  • SNOW-110744: Fixed issue where array batch is not usable if records*fields in the batch is large (reported in GitHub #186).
3.51.x
3.10.204-Nov-2019
  • SNOW-96797: Internal change for pending feature.
  • SNOW-102750: Increased the max connections limit to 300.
  • SNOW-104007: Fixed CVE-2019-17195, which reported security vulnerability in nimbusds versions less than 7.9.
  • SNOW-109827: Internal fix.
3.50.x
ODBC Driver
2.20.113-Nov-2019
  • SNOW-115888: For Windows, fixed issue with uploading/downloading (PUT/GET) large files to stages in Azure.
  • SNOW-110240: Fixed issue that resulted in a segmentation fault on Redhat when uploading (PUT) files to stages in Azure.
3.51.x

 

October 2019

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
SnowSQL CLI
1.1.8622-Oct-2019
  • SNOW-64718: Internal change for pending feature.
  • SNOW-92738: Improved SnowSQL installation through brew cask for zshell users.
3.48.x
JDBC Driver
3.10.122-Oct-2019
  • SNOW-23970: Added support for wildcards in directory names in PUT commands.
  • SNOW-98272: Enabled OVERWRITE option for PUT command.
  • SNOW-99312: Improved retry functionality for chunk downloader.
  • SNOW-99497: Added session id to SnowflakeConnection.
  • SNOW-99630: Implemented fixes for CVE-2019-16335 and CVE-2019-14540 security vulnerabilities.
  • SNOW-99954: Internal enhancement.
3.48.x
ODBC Driver
2.20.024-Oct-2019
  • SNOW-97263: Implemented fixes from Simba, some of which introduced behavior changes:
    • Setting DSI_CONN_CURRENT_CATALOG to non-null value could cause an issue; also, implement SFSemantics and change the default behavior there.
    • Set SQL_DESC_CASE_SENSITIVE to false for non-character data types.
    • When using non-existent name or invalid character (e.g. ") in filters for catalog functions, return empty result instead of error.
    • Set SQL_ATTR_ENABLE_AUTO_IPD to false by default to match ODBC specification.
    • Add support for binding SQL_BIT parameter.
    • Fix incorrect value when binding SQL_REAL parameter.
    • Support Inf/Nan values when binding SQL_REAL/SQL_DOUBLE parameters.
    • Return truncation warning when data retrieval buffer size is smaller than actual data.
    • Support binding parameter with custom data types (SQL_SF_TIMESTAMP_LTZ, SQL_SF_TIMESTAMP_NTZ, SQL_SF_TIMESTAMP_TZ).
    • Provide correct information from SQLGetInfo(SQL_DATABASE_NAME), SQLGetInfo(SQL_USERNAME).
    • Fix test cases issues that show up after above changes.
  • SNOW-97669: Fixed issue with SOURCE_COMPRESSION = GZIP by matching the value case-insensitively.
  • SNOW-98456: Internal enhancement.
  • SNOW-100023: Fixed issue where Azure SDK fails to upload large files from Mac/Windows.
  • SNOW-101569: Replaced int128 and uint128 libraries.
3.48.x
2.19.1614-Oct-2019
  • SNOW-14287: Fixed Wrong Column Size error for string data type in the result set metadata.
  • SNOW-86742: Added client information to the USER-AGENT HTTP header.
  • SNOW-90398: Improved handling of Cache Directory creation errors.
  • SNOW-90427: Fixed issue where ensureCacheDir failure was not properly handled in readOCSPCacheFile().
  • SNOW-98251: Fixed performance degradation by removing CURLOPT_FORBID_REUSE from curl option.
3.45.x

 

September 2019

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
SnowSQL CLI
1.1.8530-Sep-2019
  • SNOW-94184: Fixed issue related to Arrow format (internal enhancement).
3.44.x
JDBC Driver
3.10.030-Sep-2019
  • SNOW-94386: Fixed inconsistencies in data types between JSON and Arrow result sets (internal enhancement).
  • SNOW-97598: Fixed issue with special characters in table names causing getColumns() to not return values.
  • SNOW-97684: Added support for asynchronously submitting in-band telemetry data to Snowflake; previously, the data was submitted inline, which may have resulted in some latency.
  • SNOW-97215: Changed Prepare statement to defer SQL syntax and binding value check until Execute to improve latency.
3.44.x
3.9.217-Sep-2019
  • SNOW-74252: Fixed issue where calculateUpdateCount(SFBaseResultSet resultSet) defines updateCount as an int, which is limited to 4B; fixed by adding support for executeLargeBatch.
  • SNOW-90601: Internal change for pending feature.
  • SNOW-90927: Fixed AccessControlException when calling SFResultSet.next().
  • SNOW-90968: Fixed NullPointerException when calling resultSet.getTimestamp() on Time columns with null values.
  • SNOW-91271: Fixed SQLFeatureNotSupportedException when calling prepareStatement(String sql, int autoGeneratedKeys).
  • SNOW-91553: Enhanced the driver to support ResultSet distributed processing.
  • SNOW-91578: Internal fix.
  • SNOW-92223: Fixed issue related to Arrow (internal enhancement).
  • SNOW-94341: Fixed issue related to Arrow (internal enhancement).
  • SNOW-94381, SNOW-94386: Fixed issues related to Arrow (internal enhancement).
  • SNOW-94387: Fixed issue related to Arrow (internal enhancement).
  • SNOW-96157: Added SnowflakeConnection interface.
  • SNOW-96712: Fixed issue where fetching date column fails with IllegalArgumentException.
3.42.x
ODBC Driver
2.19.1523-Sep-2019
  • SNOW-98251:  Fixed a performance regression introduced in v2.19.10 of the driver. Due to this fix, versions 2.19.10 to 2.19.14 have been removed from distribution and are no longer available for download.
  • Additional fixes (from removed versions):
    • 2.19.14:
      • SNOW-81418: Added support for OVERWRITE option in PUT and GET commands.
      • SNOW-91145: Implemented behavior change for values returned by SQLTable() function, based on the table type (TABLE, VIEW, or TABLE,VIEW).
    • 2.19.13:
      • SNOW-92671:  Fixed issue with duplicate row being inserted by ensuring requestID is consistent with expired session.
    • 2.19.12:
      • SNOW-76184: Fixed extra space in end-of-timestamp output by introducing ODBC_USE_STANDARD_TIMESTAMP_COLUMNSIZE=true where the output size is estimated to 29 instead of 35.
      • SNOW-76710: Implemented Out-of-Band Telemetry.
      • SNOW-90409: Fixed support for OCSP Fail-open.
    • 2.19.11:
      • SNOW-80091: Driver now sends clientStartTime and retryCount with each /queries/v1/query-request.
      • SNOW-82846: Fixed issue where inserting a TIMESTAMP into a STRING data type field via Parameterized insert left-trims the month, day, and time using MS ODBC TEST Tool (odbcte32.exe).
      • SNOW-88346: Internal change for pending feature.
      • SNOW-90246: Fixed issue with OCSP_FAIL_OPEN parameter normalization.
      • SNOW-90640: Fixed issue with CABundleFile parameter for PUT and GET support.
    • 2.19.10:
      •  SNOW-88730: In Windows, fixed PrivateLink connection issue by adding support for the CABundleFile parameter to the connect string.
      • SNOW-88853: Added support for optionally setting application name through the .ini file or connect string.
3.43.x
2.19.1416-Sep-2019Due to a performance issue introduced in 2.19.10 and fixed in 2.19.15, these versions of the driver have been removed from distribution and are no longer available for download. All fixes from these versions are included in 2.19.15.3.42.x
2.19.1303-Sep-20193.39.x

 

August 2019

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
SnowSQL CLI
1.1.8426-Aug-2019
  • SNOW-66323: Driver now suppresses echo of sensitive data output.
  • SNOW-82276: Removed support for old OCSP URL for AWS PrivateLink.
3.39.x
1.1.8318-Aug-2019
  • SNOW-88844: Fixed grammatical issues in SnowSQL error message.
  • SNOW-89190: Fixed issue with PUT and GET commands for accounts in the US Gov Virginia region (Azure).
3.38.x
JDBC Driver
3.9.126-Aug-2019
  • SNOW-84419: Added support for proxy for Snowflake accounts on Azure (host and port only; no support for user and password).
  • SNOW-90169: Fixed support for OCSP Fail-open.
  • SNOW-90230: Added support for flushing revoked OCSPExceptionTelemetryEvent immediately.
  • SNOW-92525: Updated Arrow library to be compatible with Java 8.
3.39.x
3.9.012-Aug-2019
  • SNOW-75648: Added validateDefaultParameters parameter to validate the database, schema, and warehouse at connection time. Value is false by default. Note that this parameter resulted in a minor behavior change if the parameter is explicitly set to true.
  • SNOW-85191: Fixed issue with DatabaseMetaData.getColumns returning an empty string on COLUMN_DEF for columns with no defaults.
  • SNOW-86243: Internal change for pending feature.
  • SNOW-86345: Added support for PrivateKey-based authentication with datasource.
  • SNOW-88426: Fixed issue with setObject and setNull in the PrepareStatement resulting in error (introduced in latest JDBC driver).
  • SNOW-88467: Removed javax.activation from the driver.
  • SNOW-88628: Fixed issue with getTime() method returning NullPointerException error when reading nulls.
  • SNOW-88756: Fixed issue with VARIANT data type with ARROW occasionally returns format different from JSON format.
  • SNOW-89066: Fixed issue that caused decoding the value for data type time(0) to fail if the result format is ARROW.
  • SNOW-89110: Upgraded com.fasterxml.jackson.core:jackson-databind to version 2.9.9.2 to fix security vulnerability.
  • SNOW-89737: Fixed issue with ResultSet from Arrow_force format not matching resultSet from JSON format after calling executeQuery().
  • SNOW-90009: Upgraded org.apache.tika:tika-core to version 1.22 to fix security vulnerability.
  • SNOW-90644: Added support for Statement.getLargeCount and executeLargeUpdate.
3.37.x
ODBC Driver
2.19.1226-Aug-2019Due to a performance issue introduced in 2.19.10 and fixed in 2.19.15, these versions of the driver have been removed from distribution and are no longer available for download. All fixes from these versions are included in 2.19.15.3.39.x
2.19.1112-Aug-20193.37.x
2.19.1005-Aug-20193.36.x

 

July 2019

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
SnowSQL CLI
1.1.8208-Jul-2019
  • SNOW-82268: This version of SnowSQL does not use the new OCSP hostname/URL for Privatelink; the new hostname/URL will be implemented in a future version.
3.32.x
JDBC Driver
3.8.829-Jul-2019
  • SNOW-79383: Implemented support for CallableStatement.
  • SNOW-87251: Added result_query_format parameter for pending feature.
  • SNOW-87589: Upgraded com.fasterxml.jackson.core:jackson-databind to version 2.9.9.1 (or later) to fix a security vulnerability.
3.35.x
3.8.715-Jul-2019
  • SNOW-83429: Driver now built with FIPS-certified Bouncy Castle libraries.
  • SNOW-85251: Internal change for pending feature.
3.33.x
3.8.608-Jul-2019
  • SNOW-84683: Added support for oktausername parameter to OKTA authenticator.
3.32.x
3.8.501-Jul-2019
  • SNOW-82723: Added support for dashes (-) and periods (.) in proxyHost.
  • SNOW-83666: Fixed an issue where issuing a PUT command to an AWS S3 endpoint through a proxy connection returned a timeout.
  • SNOW-84129: Internal change for pending feature.
  • SNOW-84396: Added support for the JDBC type SMALLINT in getColumnClassName.
3.30.x
ODBC Driver
2.19.929-Jul-2019
  • SNOW-82352: Enhanced prepared statements to support queries that start with an open parenthesis.
  • SNOW-84995: Driver now checks the OCSP Response Cert Status before checking the time validity for the cert; this prevents expired REVOKED OCSP responses from failing open.
  • SNOW-86966: Driver now sets empty SERVICE_NAME if passed from the services layer.
  • SNOW-86970: Replaced insecure CRT functions with secure functions.
3.35.x
2.19.815-Jul-2019
  • SNOW-85722: Driver now checks on the return value for TlsAlloc() and calls TlsFree() as needed.
3.33.x
2.19.708-Jul-2019
  • SNOW-85249: Fixed an issue where SERVICE_NAME was not propagated to the services layer.
  • SNOW-85264: Fixed a critical stability issue in OCSP "fail-open" handling introduced in version 2.19.0 of the driver. Due to this fix, versions 2.19.0 to 2.19.6 have been removed from distribution and are no longer available for download.
  • Additional fixes (from removed versions):
    • 2.19.6:
      • SNOW-81831: Driver now uses standard connection fields for global URLs.
    • 2.19.5:
      • SNOW-80433: Fixed issue with PUT commands encountering a data error (e.g. 'LOAD00000001.csv.gz',compression type used: 'GZIP', cause: 'data error') due to files with the same name being uploaded in separate, but concurrent sessions.
    • 2.19.4:
      • SNOW-67606: Internal fix.
      • SNOW-70889: Updated OCSP hostname/URL for Privatelink.
    • 2.19.3:
      • SNOW-79225: Internal change for pending feature.
    • 2.19.2:
      • SNOW-78624: Fixed issue with Linux dependency on gcc and g++.
    • 2.19.1:
      • SNOW-74552: Driver now returns the query ID for a successful ODBC call.
      • SNOW-77593: Improved logging for OCSP fail-open, as well as updated configuration naming from Soft Fail to Fail Open.
      • SNOW-77750: To facilitate downloading the driver automatically/programmatically, the Client Driver Repository now includes a Latest directory for each supported OS. The directory is a symlink to the latest version directory.
      • SNOW-77781: Implemented various fixes for issues caused by OCSP fail-open.
    • 2.19.0 fixes:
      • SNOW-76151: Implemented support for OCSP fail-open.
      • SNOW-76979: Updated priority of ways to configure OCSP fail-open.
      • SNOW-77160: Added OCSP_MODE metric.
3.32.x
2.19.601-Jul-2019Due to an OCSP fail-open issue introduced in 2.19.0 and fixed in 2.19.7, this version of the driver has been removed from distribution and is no longer available for download. All fixes from this version are included in 2.19.7.3.30.x

 

June 2019

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
SnowSQL CLI
1.1.8117-Jun-2019
  • SNOW-80440: Fixed an issue where extra linefeed characters were generated when output_format was set to tsv and a DESCRIBE SCHEMA command was executed on an empty schema.
3.29.x
1.1.8011-Jun-2019
  • SNOW-57024: Fixed an issue where casting a timestamp earlier than UNIX epoch time added 0.100 seconds to the output.
3.28.x
JDBC Driver
3.8.417-Jun-2019
  • SNOW-19476: Implemented support for the DatabaseMetadata.getTablePrivileges method.
  • SNOW-38957: Connection errors now return multiple error codes instead of the 200002 error code.
  • SNOW-74255: Implemented support for the Statement.executeLargeBatch method.
  • SNOW-78996: Driver now removes https if included in account name.
  • SNOW-80773: Driver now issues an exception if any values are set in the Connection.setClientInfo method.
  • SNOW-81015: proxyUser and proxyPassword are now optional when using a proxy in the connect string.
  • SNOW-81829: Driver now uses standard connection fields for global URLs.
3.29.x
3.8.303-Jun-2019
  • SNOW-70888: Updated OCSP hostname/URL for Privatelink.
3.27.x
ODBC Driver
2.19.521-Jun-2019Due to an OCSP fail-open issue introduced in 2.19.0 and fixed in 2.19.7, these versions of the driver have been removed from distribution and are no longer available for download. All fixes from these versions are included in 2.19.7.3.29.x
2.19.417-Jun-20193.29.x
2.19.303-Jun-20193.27.x

 

First Published On9/28/2016 9:52 PM

Powered by