Client Release History

« Go Back


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)
  • JDBC Driver
  • ODBC Driver

For information about the other Snowflake clients (Python, Node.js, .NET, Go, etc.), see the logs and release notes provided in their respective repositories in snowflakedb (in Github).

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

Back to: Announcements.

Client Releases (by Month)

Within each month, the list is organized by client 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).


August 2020

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
  • SNOW-181011: Fixed missing dependency for keyring package, which caused issues when connecting using authenticator = externalbrowser.
  • 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.


July 2020

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
JDBC Driver
  • SNOW-170944: Security enhancement for improved masking of sensitive data.
  • SNOW-171834: Internal fix.
ODBC Driver
  • 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.


June 2020

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
  • 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.
1.2.6Version is not available for download.
JDBC Driver
  • SNOW-159743: For AIX (Unix), fixed issue with returning query results.
  • 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 (or later).
3.12.7Version is not available for download; all fixes were rolled into 2.12.8.
  • 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 after queries have completed.
ODBC Driver
  • 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.
  • 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.
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
  • 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
  • SNOW-156092: Fixed Spark/JDBC NullPointerException in getObject().
  • SNOW-155630: Internal fix for pending feature.
  • SNOW-158363: Internal fix for pending feature.
ODBC Driver
  • SNOW-136211: Implemented Arrow Bulk fetch.
  • SNOW-157756: Notarized mac package.


April 2020

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
JDBC Driver
  • 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.
ODBC Driver
  • 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.



March 2020

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
JDBC Driver
  • 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 (or later). Similar fix was introduced in version 3.12.2 of the non-FIPS-compliant driver.
  • 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 (or higher).
ODBC Driver
  • 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.
  • 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.


February 2020

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
  • 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.
JDBC Driver
  • 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.
  • 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.
ODBC Driver
  • 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.


January 2020

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
  • 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.
  • 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.
JDBC Driver
  • 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.
ODBC Driver
  • SNOW-121054: Reduced unnecessary calls to ALTER SESSION SET AUTOCOMMIT=TRUE.
  • 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.


December 2019

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
  • 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.
  • 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.
JDBC Driver
  • 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).
ODBC Driver
  • 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.


November 2019

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
  • SNOW-110647: Moved upgrade repository from S3 to sfc-repo; original S3 repository is still available for earlier versions.
JDBC Driver
  • 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).
  • 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.
ODBC Driver
  • 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.


October 2019

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
  • SNOW-64718: Internal change for pending feature.
  • SNOW-92738: Improved SnowSQL installation through brew cask for zshell users.
JDBC Driver
  • 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.
ODBC Driver
  • 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.
  • 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.


September 2019

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
  • SNOW-94184: Fixed issue related to Arrow format (internal enhancement).
JDBC Driver
  • 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.
  • 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
  • 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.
ODBC Driver
  • 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.
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


August 2019

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
  • SNOW-66323: Driver now suppresses echo of sensitive data output.
  • SNOW-82276: Removed support for old OCSP URL for AWS PrivateLink.
  • 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).
JDBC Driver
  • 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.
  • 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 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.
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


July 2019

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
  • 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.
JDBC Driver
  • 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 (or later) to fix a security vulnerability.
  • SNOW-83429: Driver now built with FIPS-certified Bouncy Castle libraries.
  • SNOW-85251: Internal change for pending feature.
  • SNOW-84683: Added support for oktausername parameter to OKTA authenticator.
  • 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.
ODBC Driver
  • 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.
  • SNOW-85722: Driver now checks on the return value for TlsAlloc() and calls TlsFree() as needed.
  • 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.
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


June 2019

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
  • 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.
  • SNOW-57024: Fixed an issue where casting a timestamp earlier than UNIX epoch time added 0.100 seconds to the output.
JDBC Driver
  • 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.
  • SNOW-70888: Updated OCSP hostname/URL for Privatelink.
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


May 2019

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
  • SNOW-75465: Fixed issue with !SET indent with comment.
  • SNOW-76043: Added option to skip request pooling.
  • SNOW-76797: Implemented support for OCSP fail-open.
  • SNOW-77160: Added OCSP_MODE metric.
JDBC Driver
  • SNOW-77592: Implemented support for the getProcedures and getProcedureColumns methods.
  • SNOW-79011: Fixed an issue caused by the driver returning an error when closing a connection, but the session is already gone. The driver now ignores these errors.
  • SNOW-79125: Fixed an issue caused by OCSP key comparison performed using double equal signs instead of equal signs when fetching whitelist URLs.
  • SNOW-79699: Upgraded com.fasterxml.jackson.core:jackson-databind to version 2.9.9 (or later).
  • SNOW-80208: Fixed an issue that could cause missing data in large result queries. In certain situations, a NULL value in one column could cause the driver to return NULL values in subsequent columns. This issue affected versions 3.7.1. 3.7.2, 3.8.0, and 3.8.1 of the JDBC driver.
  • SNOW-67078: PUT and GET commands now supported by executeBatch().
  • SNOW-70751: Driver now supports ApplicationName in Connection.setClientInfo().
  • SNOW-74086: Driver now implements DatabaseMetaData.getFunctionColumns().
  • SNOW-76035: Statement.getUpdateCount() and PreparedStatement.getUpdateCount() return the number of rows updated by DML statements. For all other types of statements, including queries, they return -1.
  • SNOW-76375: Driver now implements PreparedStatement.getParameterMetaData(), ParameterMetaData.getParameterCount(), and ParameterMetaData.getParameterType(int).
  • SNOW-77987: Fixed issue with Revoked OCSP response being removed from the in-memory cache; the response is now persisted in the cache.
  • SNOW-79011: Fixed issue if missing session error occurs when closing a connection; driver now ignores the error.
  • SNOW-75285: Driver now removes sensitive data from URL before logging.
  • SNOW-75925: Created interfaces SnowflakeStatement, SnowflakeResultSet, and SnowflakePreparedStatement to expose Snowflake specific APIs: SnowflakeStatement.getQueryID(), SnowflakeStatement.getBatchQueryID(), SnowflakeResultSet.getQueryID(), SnowflakePreparedStatement.getQueryID().
  • SNOW-76010: Updated c3p0 version.
  • SNOW-76150: Implemented support for OCSP fail-open.
  • SNOW-76375: Implemented DataBaseMetaData.getParameterMetaData() and ParameterMetaData.getType().
  • SNOW-77160: Added OCSP_MODE metric.
ODBC Driver
2.19.225-May-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


April 2019

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
  • SNOW-74395: Fixed issue with Azure token renewal for long running jobs.
  • SNOW-75372: Enhanced SQL syntax highlighting in the SnowSQL editor.
  • SNOW-74042: Implemented the custom OCSP Cache Server URL in the Python Driver.
JDBC Driver
  • SNOW-68756: If a JAVA heap space error occurs when querying data, the driver now provides a detailed error message and suggestions.
  • SNOW-70356: Driver now ensures all associated objects are freed when closed.
  • SNOW-70409: Driver now closes all associated objects when the parent object is closed.
  • SNOW-71689: Updated to use new OCSP Endpoint URL based on Client Failover.
  • SNOW-73034: Fixed issue where setting the index 0 for binding was ignored; the driver now raises an exception.
  • SNOW-73555: Fixed issue with unselected columns not being dropped after creating a temporary table.
  • SNOW-74238: SnowflakeBasicDatasource no longer uses DriverManager to create connection; instead, connection is created directly.
  • SNOW-70354: SQLException is now raised when attempting to call a method for a closed object. This is a behavior change from previous versions of the driver.
  • SNOW-73421: Internal change for future improvement.
ODBC Driver
  • SNOW-66128: Driver now supports SERVICE_NAME.
  • SNOW-73120: Fixed issue with PUT command failing to load file to internal stage.
  • SNOW-73304: Fixed the TIMESTAMP_LTZ behavior for the driver.


March 2019

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
  • SNOW-66025: Added support for FORCE_PUT_OVERWRITE option.
JDBC Driver
  • SNOW-65887: Changed source and target Java version to 1.8.
  • SNOW-66302: Fixed issue with parsing date and time formats.
  • SNOW-67095: Fixed issue which caused 3.6.x versions of the driver to hang when resultSet was not consumed; the driver now always releases resultSet and its memory usage when a statement is closed.
  • SNOW-67120: Modified getTableTypes() to include TEMPORARY and TRANSIENT table types; previously only returned TABLE and VIEW.
ODBC Driver
  • SNOW-63521: Driver upgraded to OpenSSL 1.1.1b.


February 2019

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
  • SNOW-66722: For Windows, fixed regression for DATE format.
  • SNOW-64148: Upgraded Python version to 3.6.
JDBC Driver
  • SNOW-42661: Added support for unknown type binding variable in UDTFs (user-defined table functions).
  • SNOW-62511: Added support for masking AWS passwords in queries.
  • SNOW-66840: Changed CLIENT_METADATA_REQUEST_USE_CONNECTION_CTX parameter for JDBC to align with the ODBC driver.
  • SNOW-67327: Fixed null pointer exception when TIMESTAMP value is null in binding.
  • SNOW-53174: Improved error messages when a driver fails to connect to Snowflake, S3, or OCSP.
  • SNOW-64063: Updated the Loader API to using CREATE TABLE ... LIKE syntax.
  • SNOW-64977: Added more granular error message for failed batch loads.
  • SNOW-65154: Fixed format of CHANGELOG.rst file.
  • SNOW-65421: Fixed issue with binding null with data type raising an error.
  • SNOW-66015: Fixed issue where binary column always returned 0 precision; now it returns the length in bytes.
  • SNOW-66026: Changed all INFO and WARNING logging to DEBUG.
ODBC Driver
  • SNOW-39055: Documented support for defining custom C data types.
  • SNOW-60376: For Windows, fixed issue that prevented changing the installation location from the default.
  • SNOW-56250: Fixed issue where cancel does not record requestId.
  • SNOW-64779: Added BIGINT support to ODBC Data Type table.


January 2019

 Version  Release Date  Changes/Fixes Compatible Snowflake Release
  • SNOW-57001: Driver now ignores exceptions from Heartbeat.
  • SNOW-63422: Added support for negative values for year.
  • SNOW-63839: Fixed out-of-range error for year values.
  • SNOW-64053: Added an option to automatically print query ids.
  • SNOW-37156: Added new SQL functions to the keyword list for auto-completion and syntax highlighting.
  • SNOW-54514: Fixed issue with explicitly-specified default region causing SnowSQL to hanging indefinitely.
  • SNOW-36812: Added the !pause command to pause and continue running queries.
  • SNOW-56234: Fixed the PUT/GET progress bar for accounts on Azure.
  • SNOW-59077: Added the timing_in_output_file option to store the query timing in the output file.
  • SNOW-60603: Added the progress_bar option to suppress displaying the progress of PUT and GET commands.
  • SNOW-61860: Adjusted the log level to mitigate confusion.
JDBC Driver
  • SNOW-63813: Driver now allows explicitly providing all proxy data via the JDBC connection string.
  • SNOW-64564: Driver now initializes logging when the tracing parameter is specified in the JDBC connection string; otherwise, the driver lets the application code enable logging.
  • SNOW-64570: Fixed issue with failure to serialize ClientAuthnDTO in Dell Boomi cloud environment.
  • SNOW-61650: Fixed issues to support Dell Boomi Cloud.
  • SNOW-62247: Added enum REJECTED_RECORD in LoadingError class.
  • SNOW-63844: Security enhancement - Driver checks that the version for Jackson Databind (com.fasterxml.jackson.core:jackson-databind) is greater than or equal to 2.9.0, but less than 2.9.8.
  • SNOW-45402: Added support for 256-bit encryption for Azure stages.
  • SNOW-61210: Improved OCSP Cert Auth and Handshake retry.
  • SNOW-63067: Fixed issue with intermittent error in driver even though the **Query Details** page (in the web interface) shows the query was successful.
  • SNOW-63137: Changed driver log level from ALL to INFO in the example (in the Snowflake documentation).
  • SNOW-63240: Added additional null checks in statements.
  • SNOW-63341: Driver no longer throws an incident for no row found user errors.
  • SNOW-63481: Security enhancement: Updated tika-core to 1.20.
  • SNOW-63523: Removed hard-coded Level.ALL for logger initialization.
ODBC Driver
  • SNOW-65165: Driver upgraded to SimbaSDK 10.1.
  • SNOW-60066: For Mac OS, fixed key pair segfault when extracting public key.
  • SNOW-60617: Added support for setting APPLICATION property.
  • SNOW-63031: Driver now invalidates outdated OCSP responses when checking cache hit.
  • SNOW-63305: Improvements for future use.
  • SNOW-62431: For Snowflake accounts hosted on AWS, support added for PUT and GET commands.
  • SNOW-62880: Support added for loading PrivateKey file for key-pair authentication.
  • SNOW-62922: Fixed issue with driver crashing when DB2 ODBC library is also used.
  • SNOW-61962: Improved the precision for floating point numbers to mitigate precision loss.
  • SNOW-62077: Driver now checks HTTP Response Codes for OCSP Cache Download.


First Published On9/28/2016 9:52 PM

Powered by