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	Enhanced the Snowflake Azure OAuth2, Snowflake Google Storage OAuth2, and Snowflake S3 OAuth2 accounts with the Grant type dropdown list that enables you to authorize your account using the available (Authorization code, Client credentials, or Password) grant types. Updated the tooltip for the Encrypted Private Key Passphrase property in the Snowflake Azure Database Account for readability.
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	Fixed an issue with the Snowflake - Bulk Load and Snowflake - Bulk Upsert Snaps that displayed a `null pointer exception` when the File format type field was left blank or empty. Upgraded the JDBC driver for the Snowflake Snap Pack to v3.16.0.
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