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)
  • 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).

 

December 2019

 Version  Release Date  Changes/Fixes Compatible Snowflake Version 
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 Version 
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 Version 
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 Version 
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 Version 
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 Related Snowflake Version 
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 Related Snowflake Version 
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

 

May 2019

 Version  Release Date  Changes/Fixes Related Snowflake Version 
SnowSQL CLI
1.1.7910-May-2019
  • 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.
3.24.x
JDBC Driver
3.8.230-May-2019
  • SNOW-62766: Deprecated the CLIENT_PREFETCH_THREADS and CLIENT_RESULT_PREFETCH_SLOTS parameters.
  • 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.
3.27.x
3.8.121-May-2019
  • 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.
3.26.x
3.8.010-May-2019
  • 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.
3.24.x
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 2.19.7.3.26.x
2.19.120-May-20193.26.x
2.19.010-May-20193.24.x

 

April 2019

 Version  Release Date  Changes/Fixes Related Snowflake Version 
SnowSQL CLI
1.1.7825-Apr-2019
  • SNOW-74395: Fixed issue with Azure token renewal for long running jobs.
  • SNOW-75372: Enhanced SQL syntax highlighting in the SnowSQL editor.
3.22.x
1.1.7715-Apr-2019
  • SNOW-74042: Implemented the custom OCSP Cache Server URL in the Python Driver.
3.20.x
JDBC Driver
3.7.223-Apr-2019
  • 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.
3.22.x
3.7.108-Apr-2019
  • 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.
3.19.x
ODBC Driver
2.18.408-Apr-2019
  • 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.
3.19.x

 

March 2019

 Version  Release Date  Changes/Fixes Related Snowflake Version 
SnowSQL CLI
1.1.7601-Mar-2019
  • SNOW-66025: Added support for FORCE_PUT_OVERWRITE option.
3.15.x
JDBC Driver
3.7.026-Mar-2019
  • SNOW-65887: Changed source and target Java version to 1.8.
3.18.x
3.6.2812-Mar-2019
  • 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.
3.17.x
ODBC Driver
2.18.312-Mar-2019
  • SNOW-63521: Driver upgraded to OpenSSL 1.1.1b.
3.17.x

 

February 2019

 Version  Release Date  Changes/Fixes Related Snowflake Version 
SnowSQL CLI
1.1.7513-Feb-2019
  • SNOW-66722: For Windows, fixed regression for DATE format.
3.14.x
1.1.7406-Feb-2019
  • SNOW-64148: Upgraded Python version to 3.6.
3.13.x
JDBC Driver
3.6.2722-Feb-2019
  • 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.
3.14.x
3.6.2608-Feb-2019
  • 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.
3.13.x
ODBC Driver
2.18.222-Feb-2019
  • 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.
3.14.x
2.18.106-Feb-2019
  • SNOW-56250: Fixed issue where cancel does not record requestId.
  • SNOW-64779: Added BIGINT support to ODBC Data Type table.
3.13.x

 

January 2019

 Version  Release Date  Changes/Fixes Related Snowflake Version 
SnowSQL CLI
1.1.7329-Jan-2019
  • 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.
3.12.x
1.1.7211-Jan-2019
  • 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.
3.10.x
1.1.7107-Jan-2019
  • 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.
3.8.x
JDBC Driver
3.6.2525-Jan-2019
  • 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.
3.12.x
3.6.2411-Jan-2019
  • 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.
3.10.x
3.6.2303-Jan-2019
  • 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 logging.properties 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.
3.8.x
ODBC Driver
2.18.029-Jan-2019
  • SNOW-65165: Driver upgraded to SimbaSDK 10.1.
3.12.x
2.17.615-Jan-2019
  • 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.
3.10.x
2.17.510-Jan-2019
  • 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.
3.9.x
2.17.407-Jan-2019
  • 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.
3.8.x

 

December 2018

 Version  Release Date  Changes/Fixes Related Snowflake Version 
SnowSQL CLI
1.1.7013-Dec-2018
  • SNOW-60580: Fixed 403 error encountered by accounts in EU region.
3.7.x
Node.js Driver
No longer documented here (see release notes available in Github)
JDBC Driver
3.6.2219-Dec-2018
  • SNOW-54606: Fixed issue that caused the following exception when using the driver with Java Spring Boot: Caused by: java.lang.IllegalArgumentException: URL must start with 'jdbc'.
  • SNOW-61424: Removed unnecessary/redundant version logs.
  • SNOW-62140: The default setting for CLIENT_MEMORY_LIMIT parameter is now dynamic, based on the amount of system memory available.
  • SNOW-62996: Fixed intermittent JDBC connection failure in PrivateLink.
  • SNOW-63026: Driver now invalidates outdated OCSP responses when checking the cache.
  • SNOW-63163: Fixed NPE when fetching data.
3.7.x
3.6.2111-Dec-2018
  • SNOW-61862: Driver now uses YYYY-MM-DD HH24:MI:SS.FF9 TZH:TZM for timestamp array binding.
3.6.x
3.6.2005-Dec-2018
  • SNOW-61209: Fixed performance issue with result set download.
3.6.x
3.6.1904-Dec-2018
  • SNOW-44393: Driver now catches exceptions for prepareStatement so that execution can continue.
3.6.x
ODBC Driver
2.17.313-Dec-2018
  • SNOW-55056: Fixed issue caused by including region and cloud platform in account parameter in odbc.ini.
3.7.x
2.17.207-Dec-2018
  • SNOW-52535: Internal change for pending feature.
  • SNOW-58250: Driver now filters client application names to pass only alphanumeric and underscore characters; all other characters in client application names are ignored.
  • SNOW-60207: Fixed an issue where the warehouse specified in the connection parameters is not set when a session is created by an ID token.
3.6.x

 

November 2018

 Version  Release Date  Changes/Fixes Related Snowflake Version 
SnowSQL CLI
1.1.6915-Nov-2018
  • SNOW-58838: Added service name support for multi-GS clustering (internal feature).
  • SNOW-58845: Added SNOWSQL_DOWNLOAD_DIR environment variable to set the download directory.
  • SNOW-60056: For Windows, fixed issue with Python connector failing to convert pre-epoch TIMESTAMP_NTZ data.
3.5.x
1.1.6808-Nov-2018
  • SNOW-58177: SnowSQL now raises a more user-friendly error if localhost is not found. 
3.4.x
Node.js Driver
 No longer documented here (see release notes available in Github)
JDBC Driver
3.6.1827-Nov-2018
  • List of fixes not currently available
3.5.x
3.6.1713-Nov-2018
  • SNOW-56081: CLOB data type now mapped to STRING data type in Snowflake.
  • SNOW-58812: Fixed issue with PARALLEL parameter for PUT and GET commands.
  • SNOW-59802: Fixed issue with wrong TIME format for the Loader API.
  • SNOW-59862: Added JVM properties for CLIENT_PREFETCH_THREADS, CLIENT_MEMORY_LIMIT, and CLIENT_RESULT_CHUNK_SIZE.
3.5.x
3.6.1601-Nov-2018
  • SNOW-56603: As announced previously, the CLIENT_MEMORY_LIMIT parameter now governs the total memory used per process instead of per query.
  • SNOW-57107: Driver now checks to ensure all dependencies are correctly shaded.
3.4.x
ODBC Driver
2.17.108-Nov-2018
  • SNOW-55036: Added request_guid to all HTTP requests to support better tracing.
3.4.x

 

October 2018

 Version  Release Date  Changes/Fixes Related Snowflake Version 
SnowSQL CLI
1.1.6725-Oct-2018
  • SNOW-56812: Fixed an issue where exit_on_error=true didn't work if an error occurred for a PUT or GET command.
  • SNOW-56882: Fixed an issue caused by using a backslash followed by a single quote in a literal (e.g. 'text\'s string').
3.2.x
1.1.6616-Oct-2018
  • SNOW-55034: Added request_guid to each HTTP request for tracing.
  • SNOW-56079: Fixed an issue with setting a single right angle bracket (>) as the command-line prompt.
3.1.x
1.1.6509-Oct-2018
  • SNOW-55027: Added support for binding the datetime object with the Snowflake TEXT data type.
  • SNOW-55253: Added the --client-session-keep-alive option.
3.0.x
Node.js Driver
1.1.602-Oct-2018
  • List of fixes not available
2.59.x
JDBC Driver
3.6.1518-Oct-2018
  • SNOW-56604: Added skipParsing option to prepareStatement method to skip fetching metadata.
  • SNOW-56771: Implemented shading of additional dependencies to a new location to mitigate package conflicts.
  • SNOW-56836: Added support for nanoseconds precision for TIMESTAMP data in Loader API.
  • SNOW-57051: Implemented fix for CVE-2018-11761 security vulnerability.
3.1.x
3.6.1416-Oct-2018
  • SNOW-55075: Introduced the CLIENT_RESULT_COLUMN_CASE_INSENSITIVE session parameter to enable matching case-sensitivity for column names in ResultSet.
3.1.x
3.6.1309-Oct-2018
  • SNOW-54926: Added compressFileByPut, compressDataBeforePut, compressLevel to Loader API.
  • SNOW-55035: Added request_guid for HTTP request tracing.
  • SNOW-55095: Internal change for pending feature.
  • SNOW-55138: Upgraded dependency to fix known vulnerabilities.
  • SNOW-55868: Added service name support for multi-GS clustering (internal feature).
3.0.x
ODBC Driver
2.17.030-Oct-2018
  • SNOW-55095: Internal change for pending feature.
  • SNOW-56912: Changed mapping for BOOLEAN data type from SQL_INTEGER to SQL_BIT.
3.3.x
2.16.1125-Oct-2018
  • SNOW-55003: For Windows ODBC configuration, changed UID parameter from required to optional, enabling creation of system DSNs without a username.
3.2.x

 

September 2018

 Version  Release Date  Changes/Fixes Related Snowflake Version 
SnowSQL CLI
1.1.6425-Sep-2018
  • SNOW-31060: Adjusted log levels by changing most INFO logs to DEBUG.
  • SNOW-54322: Fixed a misspelling in an error message for SSO.
  • SNOW-54714: SnowSQL now retries if HTTP 405 error is encountered.
2.59.x
1.1.6318-Sep-2018
  • SNOW-52668: Added -U and --upgrade options to enable forcing upgrading to the latest version of SnowSQL.
  • SNOW-53452: Internal change for pending feature.
  • SNOW-53650: Internal change for pending feature.
  • SNOW-53890: Fixed the incorrect description in the SnowSQL help for the friendly option.
  • SNOW-53891: Fixed issue which displayed the following message when [Ctrl]+[D] was used to exit SnowSQL: If the error message is not clear, enable the logging using -o log_level=DEBUG...; the message is no longer displayed.
2.58.x
1.1.6211-Sep-2018
  • SNOW-53405: Deprecated the region parameter; instead, region information is specified (if needed) in the account parameter.
  • SNOW-53629: Removed instances of hardcoded testaccount name.
2.57.x
Node.js Driver
1.1.612-Sep-2018
  • List of fixes not available
2.57.x
JDBC Driver
3.6.1225-Sep-2018
  • SNOW-26324: Added --version option to return the JDBC driver version and additional information.
2.59.x
3.6.1117-Sep-2018
  • SNOW-53452: Internal change for pending feature.
  • SNOW-53650: Internal change for pending feature.
2.58.x
ODBC Driver
2.16.1025-Sep-2018
  • SNOW-45298: Driver no longer generates incidents for errors caused by user environment.
2.59.x

 

August 2018

 Version  Release Date  Changes/Fixes Related Snowflake Version 
SnowSQL CLI
1.1.6130-Aug-2018
  • SNOW-50629: SnowSQL now uses UTC timestamp for logging.
  • SNOW-50766: Updated SnowSQL to enforce virtual host style for S3 URLs.
2.56.x
1.1.6022-Aug-2018
  • SNOW-50514: Internal change for pending feature.
  • SNOW-51669: Internal change for pending feature.
2.55.x
Node.js Driver
 No changes this month (latest version is v1.1.5 released in July 2018)
JDBC Driver
3.6.1023-Aug-2018
  • SNOW-39748: Disabled cookie management.
  • SNOW-45419: Changed the heartbeat frequency to hourly to mitigate issue with token expiration.
  • SNOW-50717: Fixed SQLException in getFunctionColumns API call.
  • SNOW-50766: Updated driver to enforce virtual host style for S3 URLs.
  • SNOW-52486: Fixed clientStartTime and retryCount metrics in query-request.
2.56.x
3.6.916-Aug-2018
  • SNOW-41673: Added retryCount and clientStartTime parameters to query-request requests for JDBC.
  • SNOW-49850: Added support for disabling SOCKS proxy for JDBC traffic using a new connection parameter (disableSocksProxy).
  • SNOW-51691: Added support for specifying file cache directories as environment variables or JVM system properties.
2.55.x
ODBC Driver
2.16.830-Aug-2018
  • SNOW-50766: Updated driver to enforce virtual host style for S3 URLs.
  • SNOW-51436: Fixed issue with underflow of INTEGER values.
2.56.x
2.16.701-Aug-2018
  • SNOW-50618: Internal change for pending feature.
  • SNOW-51002: Fixed issue introduced in v2.16.4 of the driver, in which numeric values fetched as the FLOAT/DOUBLE data type using the bulk fetch API could return wrong results.
2.53.x

 

July 2018

 Version  Release Date  Changes/Fixes Related Snowflake Version 
SnowSQL CLI
1.1.5903-Jul-2018
  • SNOW-48675: Added support for client-side job telemetry (for internal use).
  • SNOW-48678: Internal change for pending feature.
2.50.x
Node.js Driver
1.1.529-Jul-2018
  • SNOW-42892: Upgraded to the latest version of the OCSP module to address issue when using Yarn as the package manager and connecting to a region other than US West (us-west-2).
N/A
JDBC Driver
3.6.826-Jul-2018
  • SNOW-49653: Internal change for pending feature.
2.53.x
3.6.718-Jul-2018
  • SNOW-49653: Internal change for pending feature.
  • SNOW-49850: Upgraded AWS SDK.
  • SNOW-49982: Added onError parameter in the Loader API; corresponds to the ON_ERROR option in the COPY INTO <table> command.
  • SNOW-50141: Fixed issue with setObject not handling BOOLEAN data type.
2.52.x
3.6.612-Jul-2018
  • SNOW-50032: Fixed issue with the OCSP retry check, which wasn't performed if the validity check failed.
2.51.x
3.6.505-Jul-2018
  • SNOW-45021: Removed login name requirement when authenticating with an OAuth access token.
  • SNOW-45545: Fixed issue with the data-to-CSV converter for the Loader API. NULL and empty values are now correctly converted to NULL and empty, respectively.
  • SNOW-45631: Improved array binding when routing bind values through stage.
2.50.x
ODBC Driver
2.16.624-Jul-2018
  • SNOW-42835: For Mac OS, added version number to package file metadata.
  • SNOW-49898: Driver now returns Okta-specific error code when Okta authentication fails.
2.52.x
2.16.511-Jul-2018
  • SNOW-49793: Driver now deletes the OCSP response cache from the memory cache if validity check fails.
  • SNOW-49860: For Mac OS, fixed the default driver manager encoding.
2.51.x
2.16.403-Jul-2018
  • SNOW-48678: Internal change for pending feature.
2.50.x

 

June 2018

 Version  Release Date  Changes/Fixes Related Snowflake Version 
SnowSQL CLI
1.1.5815-Jun-2018
  • SNOW-45021: Removed login name requirement when authenticating with an OAuth access token.
2.48.x
Node.js Driver
 No changes this month (latest version is v1.1.4 released in May 2018)
JDBC Driver
3.6.414-Jun-2018
  • SNOW-41096: Added a parameter to control Telemetry service (for pending feature in the Spark Connector).
  • SNOW-45484: Fixed calculation for 50MB file size.
  • SNOW-45600: Driver now closes the HTTP response stream to allow HTTP client to reuse socket.
  • SNOW-45612: Added authenticator setting to SnowflakeBasicDatasource.
2.48.x
3.6.307-Jun-2018
  • SNOW-43251: Fixed erroneous exception raised when COPY statement loads 0 files.
2.47.x
ODBC Driver
2.16.315-Jun-2018
  • SNOW-44911: For ODBC on Windows, fixed issue with non-ASCII character binding.
2.48.x
2.16.207-Jun-2018
  • SNOW-44075: Removed login name requirement when authenticating with an OAuth access token.
2.47.x

 

First Published On9/28/2016 9:52 PM

Powered by