Snowflake Snap Pack
In this article
Overview
Snowflake is a cloud data warehouse (CDW). Use Snaps in this Snap Pack to:
Insert, upsert, update, unload, execute, and delete records in Snowflake.
Query a specific Snowflake instance and return the requested records or keys.
Execute multiple queries.
Enable SCD2 to track the history of changes.
The following Snaps support AWS S3, Azure Blob, and Google Cloud Storage for external staging:
Snowflake - Bulk Load
Snowflake - Bulk Upsert
Snowflake - Unload
The Snowflake Snap Pack supports Snowflake vectors, including schema generation and output compatibility with vector data types.
Important update from Snowflake about deprecated drivers:
As of February 1, 2024, Snowflake has ceased support of older driver versions in compliance with its Support Policy. You must upgrade to the latest driver version to access important security, performance, and functionality improvements. Ensure that your Snowflake pipelines use the Snowflake JDBC Driver v3.13.27 or a higher version. Learn how to check your current driver version. The Snowflake Snap Pack is bundled with the 3.16.0 JDBC driver, but if you are using your own version, it may be deprecated in accordance with Snowflake Guidelines.
Prerequisites
Snowflake JDBC driver JAR v3.0.0 or higher (tested and supported with the JDBC driver version 3.16.0).
For the
GEOMETRY
data type, JDBC driver JAR v3.13.28 or higher is requiredUser-defined functions (UDFs) created in the Snowflake console can be executed using Snowflake - Execute and Snowflake - Multi Execute Snaps.
Supported Versions
This Snap Pack is tested with JDBC driver version 3.16.0.
As of November 8, 2023, the Snowflake Snap Pack is bundled with the default Snowflake JDBC driver v3.16.0.
As of November 1, 2023, Snowflake instances hosted on Google Cloud must use Snowflake JDBC driver v3.13.25 or higher. If you are using the default drivers bundled with Snowflake or ELT Snaps, your pipelines are not affected. If your Snowflake instances hosted on Google Cloud use older JARs, you must update the client drivers. Learn more.
For support of all geospatial data types, we recommend that you use our custom JDBC driver. Contact support@snaplogic.com for details.
Snap Pack History
Release | Snap Pack Version | Date | Type | Updates |
---|---|---|---|---|
November 2024 | main29029 | Nov 13, 2024 | Stable | Updated and certified against the current SnapLogic Platform release. |
August 2024 | 438patches28811 | Nov 1, 2024 | Latest | Fixed an issue with the Snowflake Snaps where the Snaps intermittently displayed an error requesting to |
August 2024 | 438patches28667 | Nov 1, 2024 | Latest | Added the Snowflake - Snowpipe Streaming Snap that enables data insertion into Snowflake using the Snowpipe Streaming API. It allows for continuous data ingestion into Snowflake tables as soon as data becomes available. |
August 2024 | main27765 | Aug 21, 2024 | Stable | Upgraded the |
May 2024 | 437patches27531 | Aug 7, 2024 | Latest | Enhanced the Snowflake - Select Snap with Time Travel query support that enables you to access historical data at any point within a defined period. This includes restoring data-related objects, duplicating and backing up data, and analyzing data usage. |
May 2024 | 437patches27156 | Jul 10, 2024 | Latest |
|
May 2024 | 437patches26821 | Jun 27, 2024 | Latest |
|
May 2024 | 437patches26508 | May 28, 2024 | Latest |
|
May 2024 | main26341 | May 8, 2024 | Stable |
|
February 2024 | 436patches25630 | Mar 28, 2024 | Latest |
|
February 2024 | main25112 | Feb 14, 2024 | Stable | Updated and certified against the current SnapLogic Platform release. |
November 2023 | 435patches24865 | Feb 5, 2024 | Latest | Fixed an issue across the Snowflake Snaps that populated all suggestions for the Schema and Table Names existing in the configured Snowflake Account. Now, the Snaps only populate suggestions related to the database configured in the Account. |
November 2023 | 435patches24110 | Dec 14, 2023 | Latest | Added a lint warning to the Snowflake-Bulk Load Snap that recommends users to select the Purge checkbox when the Data source is input view and the Staging location is External. |
November 2023 | main23721 | Nov 8, 2023 | Stable | The Snowflake Snap Pack is now bundled with the default Snowflake JDBC driver v3.14. |
August 2023 |