• Enhanced the Snowflake S3 Database Account to skip batch execution, when the Batch size value is one. When the Batch size is greater than one, the batch is executed.
• Added the following truncate options to Snowflake - Bulk Load Snap to truncate existing data before performing data load to more efficiently transfer data where possible.
  • Truncate data: Truncates existing data before performing data load. 
  • Truncate columns: Truncates column values that are larger than the maximum column length in the table.
• Enhanced the Snowflake - Execute Snap to invoke stored procedures.

• Enhanced Snowflake - Lookup and Snowflake SCD2 Snaps with the Input Date Format field to select from the following two options:
  • Continue to execute the snap with the given input Date format
  • Auto Convert the format to Snowflake default format
• Added a new account type Snowflake Google Storage Database to connect to Google Cloud Storage to load data.

• Added support for all existing Snowflake Snap accounts to connect to a Snowflake instance hosted on the Google Cloud Platform

4.24 Patch

Enhanced the Snowflake - Select Snap to return only the selected output fields or columns in the output schema (second output view) using the Fetch Output Fields In Schema check box. If the Output Fields field is empty all the columns are visible.

4.23 Patch

Fixed the performance issue in the Snowflake - Bulk Load Snap while using External Staging on Amazon S3.

• Enhances both, Snowflake - Unload and Snowflake - Bulk Load Snaps by adding a new field, Storage Integration, which supports using the Cross Account IAM in the external staging.
• Enhances Snowflake Snaps by enabling session management for Snowflake queries by adding a new field, Manage Queued Queries, to give you an option to track and cancel queued queries when the Pipeline stops or fails. The default option is to let the Pipeline to continue the queued queries and not have the Snowflake Snaps to trigger additional queries for session management. The field is introduced in the following Snaps:
  • Snowflake - Bulk Load
  • Snowflake - Bulk Upsert
  • Snowflake - Delete
  • Snowflake - Execute
  • Snowflake - Insert
  • Snowflake - Lookup
  • Snowflake - Select
  • Snowflake - Unload
  • Snowflake - Update
  • Snowflake - Multi Execute
  • Snowflake SCD2

Fixes an issue with the Snowflake Snaps that fail while displaying the same error message, javax.management.MalformedObjectNameException: Invalid character '=' in value part of property, repeatedly when there is “=“ or ”:” in the Snowflake URL connection.

4.22 Patch

• Enhances the Snowflake Snaps by adding a new field, Manage Queued Queries, to enable you to decide whether a given Snap should continue or cancel executing the queued Snowflake Execute SQL queries. This field is introduced in the following Snaps:
  • Snowflake - Bulk Load
  • Snowflake - Bulk Upsert
  • Snowflake - Delete
  • Snowflake - Execute
  • Snowflake - Insert
  • Snowflake - Lookup
  • Snowflake - Select
  • Snowflake - Unload
  • Snowflake - Update
  • Snowflake - Multi Execute
  • Snowflake SCD2
• Enhanced Snowflake Snaps by enabling the Session Management of the Snowflake Queries to give the user an option to be able to track and cancel queued queries when the pipeline stops or fails. Default option is to let the pipeline to continue the queued queries and not have the Snowflake Snaps to trigger additional queries for session management.

4.21 Patch

Fixes the issue where Snowflake SCD2 Snap generates two output documents despite no changes to Cause-historization fields with DATE, TIME and TIMESTAMP Snowflake data types, and with Ignore unchanged rows field selected.

4.21 Patch

• Fixed the following issues with DB Snaps:
  • The connection thread waits indefinitely causing the subsequent connection requests to become unresponsive.
  • Connection leaks occur during Pipeline execution.
• Fixed the exception RefCnt has gone negative across the Snaps in Snowflake Snap Pack.

4.21 Patch 

Added a new field, Handle Timestamp and Date Time Data, to Snowflake Lookup Snap. This field enables you to decide whether the Snap should translate UTC time to your local time and the format of the Date Time data.

4.21 Patch

Fixed the connection issue in Database Snaps by detecting and closing open connections after the Snap execution ends. 

• Certifies the Snowflake Snap Pack against JDBC Driver version 3.12.3.

Re-release of fixes from db/snowflake8687 for 4.20: Fixes the Snowflake Bulk Load snap where the Snap fails to load documents containing single quotes when the Load empty strings checkbox is not selected.

Fixed the Snowflake Bulk Load snap where the Snap fails to load documents containing single quotes when the Load empty strings checkbox is not selected.

4.19 Patch 

Added the property Handle Timestamp and Date Time Data to Snowflake - Execute and Snowflake - Select Snaps. This property enables you to decide whether the Snap should translate UTC time to your local time.

4.19 Patch 

Fixed an issue with the Snowflake - Update Snap wherein the Snap is unable to perform operations when:

• An expression is used in the Update condition property.
• Input data contain the character '?'.

• Added a new field-set, Auto Historization Query, in the Snowflake SCD2 Snap to support auto-historization of column data. With this enhancement you can detect whether the incoming record is a historical event or a current event.  
• Raised the minimum buffer size in the Snowflake - Bulk Upsert and Snowflake - Bulk Load Snaps to 6 MB.

Fixed an issue with the Snowflake - Select Snap wherein the Snap converts the Snowflake-provided timestamp value to the local timezone of the account.

4.18 Patch 

Enhanced the Snap Pack to support AWS SDK 1.11.634 to fix the NullPointerException issue in the AWS SDK. This issue occurred in AWS-related Snaps that had HTTP or HTTPS proxy configured without a username and/or password. 

4.18 Patch

Fixed an issue with the PostgreSQL grammar to better handle the single quote characters.

4.18 Patch 

Fixed an issue with the Snowflake - Execute Snap wherein the Snap is unable to support the '$' character in query syntax.

4.18 Patch

Updated the AWS SDK library version to default to Signature Version 4 Signing process for API requests across all regions.

4.18 Patch 

• Fixed an issue with the Snowflake - Bulk Upsert Snap wherein the Snap fails when using a pipeline parameter in Key columns.
• Fixed an issue with the Snowflake - Unload Snap wherein the Snap does not abort the query when you stop the Pipeline execution.

Added the Use Result Query property to the Multi Execute Snap, which enables you to write results to an output view.

Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.

4.17 Patch 

Fixed an issue wherein bit data types in the Snowflake - Select table convert to true or false instead of 0 or 1.

4.17 Patch 

Added AWS Server-Side Encryption support for AWS S3 and AWS KMS (Key Management Service) for Snowflake Bulk Load, Snowflake Bulk Upsert, and Snowflake Unload Snaps.

• Fixed an issue with the Snowflake Execute Snap wherein the Snap would send the input document to the output view even if the Pass through field is not selected in the Snap configuration. With this fix, the Snap sends the input document to the output view, under the key original, only if you select the Pass through field.
• Added the Snap Execution field to all Standard-mode Snaps. In some Snaps, this field replaces the existing Execute during preview check box.

Fixed an issue with the Snowflake Lookup Snap failing when Date datatype is used in JavaScript functions.

4.16 Patch 

Added support for file format options for input data from upstream Snaps, to the Snowflake Bulk Load Snap.

4.16 Patch 

• Snowflake Bulk Load: Added new property, Buffer size (MB). Configure this to specify the size limit of each buffer when writing to external staging systems such as S3. 
• Fixed an issue with the Lookup Snap passing data simultaneously to output and error views when some values contained spaces at the end.

• Snowflake Account: Added the ability to use SnapLogic to securely connect to and query a Snowflake instance using Azure Blob as its storage layer. 
• Snowflake Account: Added support for Snowflake JDBC JAR version 3.6.17. 
• Snowflake Unload, Bulk Load, and Bulk Upsert: Updated the Snaps to enable SnapLogic users to successfully connect to a Snowflake instance to query, bulk load, and unload data from Azure Blob storage.

• Added two new Snaps, Snowflake - Multi Execute, and Snowflake SCD2. Snowflake - Multi Execute is used for executing multiple DDL and DML queries on the Snowflake DB. Snowflake SCD2 is used for Type 2 field historization. 
• Enhanced the Snowflake Bulk Upsert Snaps to improve the Snaps performance.
• Enhanced the Snowflake Snap Pack to reflect Azure certification.

snapsmrc486

snapsmrc480

Fixed a document call issue that was slowing down the Snowflake Bulk Load Snap.

4.11 Patch 

Snowflake Bulk Load - Fixed an issue by adding PUT command to the list of DDL command list for Snowflake.

4.11 Patch 

Snowflake Bulk Load - Resolved an issue with Snowflake Bulk Load Delimiter Consistency (comma and newline).

4.10 Patch

Updated the Snowflake Bulk Load Snap with Preserve case sensitivity property to preserve the case sensitivity of column names.

snapsmrc414

• Updated the Snowflake Bulk Load Snap with Load empty strings property for the empty string values in the input documents to be loaded as empty strings to the string-type fields.
• Updated the Snowflake Bulk Load Snap with Table Columns to support the order of the entries on the staged files that contain a subset of the columns in the Snowflake table.
• Added the property Use Result Query to view the output preview field with a result statement.
• Tested for the JDBC jar version 3.1.1 on the Database and the Dynamic accounts.

4.9.0 Patch

Enhanced Snowflake - Execute Snap results to include additional details

4.9.0 Patch

Addressed an issue in Snowflake Bulk Load where the comma character in a value is not escaped.

4.8.0 Patch

Potential fix for JDBC deadlock issue.

4.8.0 Patch

Addressed an issue with the Snowflake schema not correctly represented in the Mapper Snap.

snapsmrc398

• Info tab added to accounts.
• Database accounts now invalidate connection pools if account properties are modified and login attempts fail.

• Enhanced the default count of input and output view (UI) behavior of the Snaps for better user experience. 

  
  

  Snowflake Snap Pack
  Views	Bulk Load	Bulk Upsert	Insert	Update	Delete	Execute	Unload	Select	Table List	Lookup
  Initial (4.7) Input-Output views	1-0	1-0	1-0	1-0	0-0	0-0	0-0	0-1	0-1	0-1
  Current (4.8) Input-Output views	1-1	1-1	1-1	1-1	0-1	0-1	0-1	0-1	0-1	0-1
  Note that the Snowflake Select, Table List and Lookup Snap views remain unchanged.