August 2024 Release Notes

Highlights

The SnapLogic August 2024 Release includes the following highlights:

Admin Manager

  • Enable or disable the SnapLogic Cloud Pattern Library

API Management

  • New Public API to invalidate response cache for API proxies

  • Support for Secrets Management tools

Documentation Enhancements

  • New guide for organizations planning to migrate their environments from the US to the EMEA control plane

  • A new Introduction section replaces the dated Getting Started guide

GenAI App Builder

  • Amazon Bedrock LLM: Added the Agent Retrieve, Agent Retrieve and Generate, and Invoke Agent Snaps

  • Azure OpenAI LLM: Added the Azure OpenAI Entra ID Application Account, Azure OpenAI Entra ID User Account, and Azure OpenAI Entra Token Accounts

  • Google GenAI LLM Snap Pack

  • OpenSearch: Added the Amazon OpenSearch Account

  • OpenAI LLM: Added the Add Message, Create and Run Thread, Create Thread, and Run Thread Snaps.

Monitor

  • New design for the System overview

Platform

  • Additional rules added to the public API to check the pipeline quality

Snaps

  • Databricks - Run Job

  • Google Directory - Google Service Account

  • Oracle - Parallel Load


Dot Releases – Snaps

Snap Pack

Date of Update

Snap Pack Version

Updates

Snap Pack

Date of Update

Snap Pack Version

Updates

Flow

Sep 16, 2024

438patches28047

Enhanced the Head and Tail Snaps (for the Number of documents and Document offset fields) to support pipeline parameters via expressions that enable you to reuse the pipelines.

API Suite

Sep 13, 2024

438patches28040

Enhanced the HTTP Client Snap with improved handling of redirect URL encoding to minimize runtime errors.
By default, the Snap executes the standard redirect behavior. However, if a redirect URL contains unencoded spaces, or special characters, or any other improper format that could potentially cause issues, the Snap encodes the URL before redirecting, ensuring a successful runtime execution.

Salesforce

Sep 13, 2024

438patches28040

Fixed an issue with the Salesforce SOQL Snap where the URL encoding was improperly applied to sandbox instance URLs. Now, the Snap ensures that URL sandbox instance URLs are properly encoded.

Breaking change from Salesforce:

Salesforce is retiring some of the hostnames for non-enhanced domains.

  • Redirections for legacy (non-enhanced) hostnames stop in production orgs and demo orgs. Production orgs get this release starting in January 2025.

  • Redirections for legacy (non-enhanced) hostnames stopped in sandboxes, Developer Edition orgs, patch orgs, scratch orgs, and Trailhead Playgrounds.

When deploying a new My Domain, including enhanced domains, Salesforce automatically redirects previous URLs. For detailed information, such as hostname formats for legacy (non-enhanced) domains, refer to the Prepare for the End of Redirections for Non-Enhanced Domains.

To align with Salesforce’s redirection changes for non-enhanced domains, the classic URL format (https://snaplogic--devqa.my.salesforce.com/) is no longer supported for Sandbox environments. As a result, any existing Salesforce pipelines using classic URLs will stop functioning as before.

Workaround

To run your pipelines successfully, you must append sandbox to your classic URLs: https://snaplogic--devqa.sandbox.my.salesforce.com/

Learn more about the enhanced domains deployment by Salesforce.

Google BigQuery

Sep 13, 2024

438patches28058

Fixed an issue with the BigQuery Table Data List Snap that displayed a null pointer exception when the table source schema contained a nested Array list schema.

Unstructured

Sep 11, 2024

438patches28036

Enhanced the Unstructured API Account with the Read timeout (seconds) field that enables the Snap to wait for a response from the Unstructured API.

ELT

Sep 10, 2024

438patches28010

The ELT Insert-Select Snap no longer fails to execute SQL statements that contain multiple multiline comment character pairs (/* and */) and/or multiple quoted substrings. Quoted substrings refer to schema, database, table, or column identifiers, which are delimited to allow special characters.

  • We recommend that you upgrade your main27765 (August 2024 GA release) ELT Snap Pack to this latest version.

OpenAPI

Sep 10, 2024

438patches27965

Fixed a chunked transfer encoding issue with the OpenAPI Snap that did not pass the upstream data to the output view even when the Pass through checkbox was selected.

Transform

Sep 9, 2024

438patches27959

Fixed an issue with the Sort where the Snap could not sort files larger than 52 MB. This fix applies to Join Snap also.

Azure OpenAI LLM

Sep 3, 2024

438patches27824

Added the following Snaps to the Azure OpenAI LLM Snap Pack:

  • Add Message: Adds messages to an existing thread.

  • Create Thread: Creates a thread by making an HTTP request to the Assistant API.

  • Create and Run Thread: Creates a thread and retrieves the result on a specified assistant.

  • Run Thread: Executes the specified thread and retrieves the result on a specified assistant.

PDF

Sep 3, 2024

438patches27926

Fixed an issue with the PDF Lock, PDF Splitter, and PDF Unlock Snaps that previously processed only the first binary input. These Snaps now support multiple binary inputs.

SAP

Sep 3, 2024

438patches27908

Fixed an issue with the SAP IDoc Listener and SAP IDoc Document Listener Snaps that displayed a Null Pointer Exception when you selected the Route errors checkbox (which routes the error to the error view) in the Snaps.

Oracle

Aug 30, 2024

438patches27870

Fixed an issue with the Oracle - Merge Snap that caused a date format error when the merge condition was used with the TO_DATE() function.

Google Drive

Aug 27, 2024

main199

Fixed the Google Drive OAuth2 User Account documentation link.

SAP SuccessFactors

Aug 27, 2024

main181

Enhanced the SuccessFactors Read and Read Advanced Snaps to handle empty responses.

SAP S/4HANA

 

Aug 27, 2024

main181

Enhanced the SAP S/4HANA Read and Read Custom Query Snaps now include the Raw response checkbox. Select this checkbox to output the raw response as a single document. If you clear the checkbox, the results are written as individual documents.

Exchange Online

Aug 27, 2024

438patches27849

Fixed an issue with the Read Email Snap that prevented reading all the emails when you selected both the Fetch only unread emails and the Mark email as read checkboxes.

Upgrading to this Release

  • To use the new SnapLogic features and Snaps in the current GA release, ensure that your Snaplexes are upgraded to the recommended version: main-26434 - 4.38 GA (Recommended). Note that on Sep 17, 2024 we deployed a new Snaplex update (main-27019 4.38 Patch 1), which is the recommended version now. Learn more

  • This release includes stable versions of the monthly Snap patches deployed to the SnapLogic Platform after the May 2024 release, as listed in the Dot Releases section of the June 2024 and July 2024 Release Notes.

  • Per the SnapLogic Release calendar, all Snaplexes on older versions will be upgraded to the recommended version during the automatic upgrade, scheduled for 1 PM (Pacific Daylight Time) on Saturday, Sep 28, 2024. Orgs that were migrated to the current GA release before the automatic upgrade are not impacted. For information on how to upgrade your Snaplex, refer to the SnapLogic Release Process.

Admin Manager

New Features

  • Enable or disable the SnapLogic Cloud Pattern Library for the environment. Learn more.

    environment-pattern-catalog.png

API Management

New Features

  • New Public API to invalidate the response cache defined in the HTTP Response Cache policy. Learn more.

Enhancements

  • Support for Secrets Management: If you use secrets management tools and services to manage your API Keys, you can now reference them when configuring API policies. The following policies have expression-enabled fields for API Keys:

    • API Key Authenticator

    • OAuth Policy

  • API logs: The logs now contain more details about failed requests. When investigating why a request failed, you can now identify which Snaplex node ran the policy that failed the request.

Fixed Issues

  • Fixed an issue where the Request Transformer policy did not get applied during the API call.

  • Fixed an issue where headers were not actually modified by the API Proxy’s mapping rules.

  • Fixed an issue where the Authorization Header in the outbound account would add an extra space between the scheme and the bearer token making some upstream servers recognize the token as invalid, including Task authentication.

Known Issues

  • When you create an API from an existing Project and choose the Assets and Snaplex in the dialog, API creation is successful, and all the assets import successfully. However, Triggered and Ultra Tasks fail to recognize the designated Snaplex that you select during API creation in the UI. Even if you explicitly specify the plex_path in the public API, the tasks will default to using the Snaplex associated with the source project.
    Workaround: Set the Snaplex for each task manually.

  • In APIM, the Create a Version and Create an API dialogs do not display the Create from Git Checkout checkbox, even if you are authenticated in Git.

AutoSync

Fixed Issues

  • When you save a new merged column without changing the name and then change it and save again, the changed name is now preserved.

  • When you apply both concatenation and data masking transformations, the data masking is applied correctly.

Known Issues

  • After you resolve a naming conflict, the transformations data preview in either the wizard or the editor might show the wrong table names or duplicate table names.

  • The data preview for the Replace empty values screen displays data from the wrong table when the selected table has no nullable columns.

Data Automation

With the basic authentication type for Databricks Lakehouse Platform (DLP) reaching its end of life on July 10, 2024, SnapLogic ELT pipelines designed to use this authentication type to connect to DLP instances would cease to succeed. We recommend that you reconfigure the corresponding Snap accounts to use the Personal access tokens (PAT) authentication type.

Enhancements

  • Enhanced the ELT Execute Snap to display statistics for all SQL statements executed. The statistics are shown in both the pipeline execution statistics and the output view of the Snap. For target Databricks Lakehouse Platform (DLP) tables, the Snap also allows you to download DML statement execution statistics in a JSON file (extraStats).

  • Enhanced the pipeline execution statistics of the ELT Insert-Select Snap to be displayed in its output view. For target Databricks Lakehouse Platform (DLP) tables, you can download a JSON file that includes additional statistics (extraStats) on DML statement executions.

  • Enhanced the ELT Load Snap to support loading data from nested AVRO, JSONLines, ORC, or Parquet files in Azure storage to target tables in a Databricks Lakehouse Platform (DLP) instance. Only two Load actions are supported: Drop and create table and Append table.

  • Upgraded the jOOQ library for the ELT Snap Pack from v3.9.1 to v3.17.x.

Fixed Issues

  • Some conflicts between internally used Azure libraries prevented the ELT Load Snap from reading files using an ADLS Gen 2 account connection.

  • The ELT Merge Into Snap’s SELECT SQL statement could not fetch the target tables' information from the PG_TABLE_DEF catalog table of the Amazon Redshift instance.

    • The SELECT SQL statement now uses lowercase for both non-delimited and delimited table names and excludes double quotes from delimited table names to fetch the values from the catalog table.

    • PG_TABLE_DEF is a Redshift system catalog table that contains information about the tables such as table names, column names, data types, and other metadata.

Documentation Enhancements

API Management

  • Updated the Generic OAuth2 Policy with the OAuth2 framework for the authorization code grant type. Learn more.

New Content

New Videos

  • Learn how to set up Azure Managed Identity in the Azure Portal:

    Configure Managed Identity in Azure.mp4
  • Learn how to Configure Azure Storage Account with a Managed Identity in SnapLogic:

Content Published on New Doc Site

The following content was added to the new site for this release. Visit https://docs.snaplogic.com to view all content available on the new site.

GenAI App Builder

New Features

Enhancements

Amazon Bedrock LLM:

Azure OpenAI LLM:

OpenAI LLM:

  • Enhanced the OpenAI Prompt Generator Snap to output the entire prompt message array and user role selection for the prompt.

  • Enhanced the OpenAI Chat Completions Snap with message payload to generate responses based on a specified list of messages.

Monitor

Enhancements and Changes

  • The new design for the System overview graph node view shows you all that you need to know about the environment infrastructure at a glance:

     

    • The bars represent the average memory, CPU utilization, and disk utilization for each node for the selected time period.

    • The colored carets mark the maximum values during the selected time period.

    • Bars and carets are color-coded for usage: Green indicates up to 45%, yellow indicates up to 75%, and red indicates over 75%.

    • Snaplexes with any nodes where the average or maximum values are either yellow or red show at the top of the page.

  • In the graph node view, hover over a node to view the actual values:

  • Now, when you switch from the System overview node graph view to the list view, the Snaplex list opens instead of the Node list.

  • In the Execution overview, the search Invocation type filter now provides options such as nested, error, and regression pipelines. The following screenshot shows the complete list:

  • The node details panel's Additional details tab no longer includes Max Threads because it doesn’t apply to the Windows OS and was inaccurate for the Linux OS.

Learn more about:

Platform

New Features

  • The public API for pipeline quality includes additional rules to provide complete reports for all standard checks. The reports include message levels with actionable message descriptions. Learn more.

  • A new guide for organizations planning to migrate their environments from the U.S. to the EMEA control plane.

Enhancements

  • A new note in the UI for the Update Snaplex dialog box in the Downloads tab states that only the latest version download links are available because deprecated versions cannot be used for installation. Learn more.

  • The Automated Pipeline Killer prevents high memory-consuming pipelines from causing node crashes. It tracks pipeline use and reservation of heap and non-heap memory. When the committed and used memory is excessive, the Automated Pipeline Killer identifies the faulty Snap responsible for the high memory utilization, kills that pipeline, and adds an error message to the Snap. The enhanced Automated Pipeline Killer:

    • Considers non-heap memory versus heap memory and committed memory versus used memory.

    • Adds information to the node log about the utilization of heap and non-heap memory, memory pools, and buffer pools.

    • Improves memory tracking by considering the ratio of total committed memory to physical memory to prevent an unresponsive JCC state.

    • Improves the pipeline termination process by ignoring completed Snaps and considering only running Snaps. The Pipeline Execution Statistics indicate details in the UI.

The Automated Pipeline Killer is enabled for all environments by default and has a threshold setting that controls its behavior. To adjust the threshold, contact your CSM. Learn more.

Fixed Issues and Behavior Changes

  • Fixed an issue with the OAuth2 password grant type to make sure that the Snap OAuth2 Account token refreshes successfully every 20 minutes.

  • Updates to Accounts using OAuth2 now succeed without issues.

  • For Accounts using OAuth2, the Platform no longer saves data in the refresh token field unless the endpoint returns refresh tokens.

Known Issues

  • Snaplexes configured with the French or Macedonian locale may not be able to make some HTTP requests to the control plane.
    Workaround: Roll back the impacted Snaplex to main-24152 4.37 GA (Deprecated) until we fix the issue.

  • In Snaplex version 4.38, pipelines using the Catalog Insert Snap no longer populate the Data Catalog tables in Manager with metadata.
    Workaround: Do not use Snaplex version 4.38 to run pipelines with the Catalog Insert Snap.

  • When you call a Triggered Task on a Groundplex using the Cloud URL with a payload of 26 MB or larger, the pipeline processing can exceed the WebSocket connection timeout.
    While the pipeline succeeds in delivering the payload, the bytes after the 26MB limit might be lost on the response side.
    If the payload is on the request side, then only the first 26 MB of bytes are sent to the pipeline, causing the possibility of pipeline failure.

Snaps

Upcoming

New Snaps/Accounts

Enhancements

  • Apache Velocity is upgraded from v1.7 to v2.3 across all Snap Packs to fix the vulnerability issue in v1.7.

  • API Suite:

    • Updated the API Suite Snaps to process authentication information from incoming documents to support features such as credentials stored in a secrets manager.

  • Binary:

  • Flow:

    • Enhanced the Pipeline Execute Snap to evaluate the Pipeline Parameters for child pipelines one time at the beginning of the batch processing or during instance reuse, thereby improving performance.

  • MongoDB:

    • Enhanced the MongoDB - Atlas Vector Search Snap with the following:

      • Suggestions for the Search index field that enables the Snap to populate the associated indexes in the list.

      • The input schema displays the mandatory vector field and optional filter suggestion (if the Search index contains a filter type query) in alignment with the fields expected by the Snap.

  • ML Data Preparation:

    • Enhanced the Date Time Extractor Snap to support Date time formats (YYYY-MM-dd HH:mm:ss and YYYY-MM-dd HH:mm:ss.SSS) and allow the root path to auto-convert all fields.

  • Oracle:

    • Enhanced the Oracle Insert, Merge, Update, and Delete Snaps to support the Enable, Disable, and Force commands in the Session parameters that enable you to dynamically manage specific session settings.

  • PostgreSQL:

  • Redshift:

    • Upgraded the JDBC driver for the Redshift Snap Pack to v2.1.0.29 to address the SQL Injection vulnerabilities. Pipelines using the Redshift Snaps are not impacted after the driver upgrade, because the latest JDBC driver is fully backward compatible.

  • Snowflake:

    • Enhanced the Snowflake—Select Snap with Time Travel query support that enables you to access historical data at any point in a defined time period. This includes restoring data-related objects, duplicating and backing up data, and analyzing data usage.

  • Upgraded the org.json.json library from v20090211 to v20240303 for the following Snap Packs, which is fully backward-compatible: 

Fixed Issues

  • When the Router Snap was the first Snap in a triggered task, the documents were not processed. Previously, the response contained a 200 status code but was empty. Now, it processes one document and provides non-empty output.

Behavior Changes

  • Previously, the Router Snap generated no output without an input document. Now, the Snap generates an empty document when no input document is provided.

  • Fixed an issue in the Snap OAuth2 Accounts for endpoints that do not support auto-refresh. Previously, you could enable Auto-refresh even though it would fail to refresh the access token. Now, on account validation, an alert advises that you cannot auto-refresh because the endpoint does not support it. Existing Accounts with the auto-refresh setting enabled continue to work as before.

Known Issues

  • SAP Snap Pack: When you upgrade the SAP Snap Pack from 4.37 main24152 to 4.38 main27765 (from SnapLogic Manager), with the old SAP native library still installed, the following fatal initialization error displays:
    Pipeline prepare error Reason: Dependent native libraries are not found or could not be resolved: Could not initialize account. [com-snaplogic-snaps-sap-jcoaccount_2-438rc27664]: Native library sapjco3 is too old. Found library /opt/snaplogic/ldlib/libsapjco3.so has version "753.811", but required is at least version "753.1324".

    Workaround:
    Follow these steps to resolve the issue:

  1. Copy the updated native library on every node in the Snaplex:

    • For Linux, copy the libsapjco3.so file to the /opt/snaplogic/ldlib folder.

    • For Windows, copy the sapjco3.dllfile to the C:\opt\Snaplogic\ldlib folder.
      Note: For Snaplexes with multiple nodes, make sure to install the library on every node.

  2. Restart all the nodes in the Snaplex.

You can download the library here.


  • Hadoop Snap Pack: The upgrade of the Azure Storage library from v3.0.0 to v8.3.0 caused the following issue when using the WASB protocol:
    When you use invalid credentials for the WASB protocol in (HDFS Reader, HDFS Writer, ORC Reader, Parquet Reader, Parquet Writer) Snaps, the pipeline does not fail immediately, instead it takes 13-14 minutes to display this error: reason=The request failed with error code null and HTTP code 0. , status_code=error
    SnapLogic is actively working with Microsoft Support to resolve the issue.

SnapGPT

Enhancements

  • You can now resize the SnapGPT pane to make it easier to read the responses to your prompts.