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 required

  • User-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 rollback/commit.

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 org.json.json library from v20090211 to v20240303, which is fully backward compatible.

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

  • Added Snowflake - Vector Search Snap to enable advanced vector-based queries as part of the Select statement.

  • Enhanced the Snowflake Snap Pack with full vector support, including schema generation and output compatibility with vector data types.

May 2024

437patches26508

May 28, 2024

Latest

May 2024

main26341

May 8, 2024

Stable

  • Enhanced the Snowflake Bulk Load and Snowflake Insert Snaps to support iceberg tables. Iceberg tables partition and organize data across multiple nodes to distribute the workload and speed up data processing.

  • Updated the Delete Condition (Truncates a Table if empty) field in the Snowflake - Delete Snap to Delete condition (deletes all records from a table if left blank) to indicate that all entries will be deleted from the table when this field is blank, but no truncate operation is performed.

February 2024

436patches25630

Mar 28, 2024

Latest

  • Enhanced the Snowflake Bulk Load Snap to fetch the file format types based on the selected Datasource. The Snap now supports only CSV and NONE file format types (as a Suggestions list) when the Datasource is Input view.

  • Enhanced the Snowflake Bulk Upsert Snap to support only CSV and NONE file format types (as a Suggestions list).

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