This article contains the release notes for the Snowflake JDBC Driver, including the following when applicable:
- Behavior changes
- New features
- Customer-facing bug fixes
Note: Beginning with the January 2022 release, all release note information for this connector is published on this page. For release note information for previous versions, see the
Server Release Notes.
Note: Beginning this month, Golang Driver release notes are published on the Snowflake documentation site. Starting in September 2023, these release notes will no longer appear on this page. Please update any links you might have saved.
Version 1.6.24 (August 22, 2023)
New Features and Updates
- Added support specifying a temporary directory for encryption and compression.
- Improved performance by checking location data once per query instead of for each row and column separately.
- Added support specifying a custom context when fetching an arrow batch.
Bug Fixes
Version 1.6.23 (July 25, 2023)
New Features and Updates
- Added support for binding named parameters.
- Added support for sql.Null types for query bind mapping.
- Allowed setting separate authentication timeout for key pair authentication.
- Added sample application providing example of distributed fetch feature.
- Added external browser timeout.
- Provided easier way to configure Snowflake connection (see /cmd examples).
- Upgraded arrow library to better handle 32bit systems.
- Provided sample app demonstrating how to use Arrow batches.
Bug Fixes
- Fixed error messages from race conditions with multiple threads.
- Fixed an issue with retry async requests if a query is still in progress.
- Added null checks before accessing connection config during chunk downloading.
- Fixed an issue with handling JSON result sets returned from server when driver expected Arrow.
- Recreate new JWT token (with new expiration) on key pair authentication retry.
- Added timeout for authentication in external browser to prevent infinite waiting when user closed browser tab.
- Fixed driver panic when temporary file system is in readonly mode.
- Fixed an authentication issue by requriing username and password only for authentication modes in which it is required.
Version 1.6.22 (June 14, 2023)
New Features and Updates
- Added a sample app,
async.go, within the cmd folder to demonstrate how to use asynchronous API calls within the Golang driver. - Added a sample app,
multistatement.go, within the cmd folder to demonstrate how to send multiple statements within the Golang driver.
Bug Fixes
- Fixed an issue where
Commit() and Rollback() did not use the same context set in BeginTx(), which could cause locks to occur.
Version 1.6.21 (May 23, 2023)
New Features and Updates
- Added to check to see whether the context deadline was exceeded when retrying in the snowflakeChunkDownloader.
- Upgraded the arrow library to version v12.
- Added the ability to expose the direct arrow IPC streams from the Snowflake Go driver.
- Included the Arrow Database Connectivity (ADBC) version 0.4.0 release, which uses the updated Snowflake library to provide a Snowflake ADBC driver that can be consumed by anything that access a C interface, in addition to the native Go bindings.
Bug Fixes
- Fixed an int64 overflow issue with large or small datetime values.
Version 1.6.20 (April 18, 2023)
New Features and Updates
- Added support for Okta Identity Engine (OIE) logins.
- Improved memory usage by cleaning up the first data chunk before reading the next data chunk.
Bug Fixes
- Fixed the interface conversion panic when the context has been cancelled while monitoring an asynchronous query and passing a cancelable context to WithFetchResultByID.
- Updated log messages for OCSP file lock errors.
- Now logs an error when a single file upload fails.
Version 1.6.19 (March 21, 2023)
New Features and Updates
- Added support for Go version 1.20 and dropped support for Go version 1.18.
- Migrated from azure-storage-blob-go v0.15.0 to azure-sdk-for-go v1.0.0.
- The Go driver now supports retrying on an HTTP 429 error code.
- Upgraded the Arrow library to version v10.
Bug Fixes
- Fixed an issue where the God driver failed to validate an SSO URL before executing it. Now, the driver uses the URLValidator and URLEncoder utilities to validate and encode the URL.
- Fixed the Pointer datatype *time.Time returns <nil> value from version GO Driver 1.6.13.
Version 1.6.18 (February 22, 2023)
New Features and Updates
Bug Fixes
- Added support for disabling connection caching for multi-factor authentication and external browsers, which are enabled by default, but setting either of the following configuration parameters (#710).
- ClientStoreTemporaryCredential=ConfigBoolFalse
- ClientRequestMfaToken=ConfigBoolFalse
Version 1.6.17 (January 26, 2023)
New Features and Updates
Bug Fixes
- Improved performance of multi-statement queries by skipping queries that return no update count.
- Fixed connection caching for MFA and external browser authentication.
- Added a mutex lock to the configuration parameters map to avoid concurrent read/writes when using multiple go routines.
Version 1.6.16 (December 14, 2022)
Bug Fixes
- Fixed an issue where file decryption was causing a panic.
- Reverted the go-ieproxy library back to version 0.0.1.
Version 1.6.15 (November 16, 2022)
New Features
- Added MultiFactor Authentication mechanism and caching for MFA/Id token.
- Fixed an issue where 405 error is thrown when S3 bucket acceleration is disabled.
Version 1.6.14 (October 28, 2022)
New Features
- Removed support for Go 1.7 and added support for Go 1.17.
- Changed the format for float and numeric values when converting arrow types.
- Added the following functions to access data in arrow.Record format directly from queries:
- GetArrowBatches(), which is a blocking call
- GetQueryID()
- GetStatus()
- Updated Go vendors.
Version 1.6.13 (August 22, 2022)
New Features
- Added an example to show how to use key-pair authentication.
- Added the tracing connection parameter to enable logging in the connection string and DSN.
- Improved logging details for chunk downloads.
- Added support for using interface slice []interface{} to insert NULL values via array binding for the time.Time data types.
Bug Fixes
- Fixed the “Failed to decrypt. Check file key and master key” error that occurred when binding large data files via array binding.
Version 1.6.12 (July 29, 2022)
New Features
- Added support for using interface slice []interface{} to insert NULL values via array binding.
Bug Fixes
- Fixed an issue where setting DisableTelemetry to TRUE did not disable telemetry.
- Fixed an issue with encrypted SAML assertions when authenticating with an external browser.
Version 1.6.11 (June 23, 2022)
Bug Fixes
- Created a temporary workaround to avoid the “Failed to decrypt. Check file key and master key” error that occurred when binding large data files via array binding. Determining the root cause of the issue is currently under investigation.
Version 1.6.10 (May 25, 2022)
Bug Fixes
- Removed redundant calls that impacted performance for PrepareContext().
Version 1.6.8 (March 15, 2022)
New Features
- Added support for exporting unique universal IDs (UUIDs).
Bug Fixes
- Fixed a default server side error.
Version 1.6.7 (February 16, 2022)
Bug Fixes
- Fixed an issue where multi-statement queries were missing result IDs.
- Implemented Universally Unique Identifier version 4 (UUIDv4).
- Fixed and issue with GetQueryStatus.
- Fixed an issue in PUT Memory Enhancements performance tests.
- Fixed an issue with arrow record result batches.
- Made the port parameter optional.
Version 1.6.6 (January 18, 2022)
Bug Fixes
- Updated copyrights.
- Fixed an issue when using S3 GET in a nested stage.
