June 2024 Release Notes

Highlights

The SnapLogic June 2024 Release includes the following highlights:

Admin Manager

  • Environment admins can now configure user and team accounts to log in with multi-factor authentication (MFA)

AutoSync

  • Enhancements to the merge columns transformation interface

  • Connect to any endpoint with a Groundplex

Documentation Updates

  • New video tour of SnapLogic Monitor

  • Added FAQ document for API Management solution

GenAI Builder

  • Added the OpenSearch Snap Pack

Monitor

  • New Activity log event to track enabling and disabling pipeline validation at the project level

  • New Snaplex node and pipeline execution statistics

Platform

  • New public API to check the pipeline quality

Snaps

  • Added NetSuite Get Server Time Snap to the NetSuite SOAP Snap Pack

  • Added File Password Account to the Binary Snap Pack

  • Added Kafka OAuth2 Account to the Kafka Snap Pack

  • Added Kerberos authentication support for Oracle databases on Windows and Linux systems

SnapGPT

  • New discovery skills workflow to facilitate user journeys

Dot Releases - Platform

Date

Component

Version

Description

Date

Component

Version

Description

Jun 18, 2024

APIM - API Suite Snap Pack

437patches26826

Updated the API Suite to support the SSL account type with API Versions and Proxies. This enables sending the client data as basic auth headers, rather than in the body of the request, leveraging the same property name as other OAuth2 accounts.

Jun 14, 2024

APIM - Policies Snap Pack

 

437patches26674

Added support for the OAuth2 SSL Account.

Jun 12, 2024

Snaplex

main-24960 - 4.37 Patch 2

Snaplex version for the June Release.

May 22, 2024

Snaplex

main-24517 - 4.37 Patch 1

Fixed an issue with the Ultra task, where the presence of a special character in the Ultra task label resulted in an error.

Dot Releases - Snaps

Snap Pack

Date of Update

Snap Pack Version

Updates

Snap Pack

Date of Update

Snap Pack Version

Updates

Unstructured

Jul 9, 2024

437patches26999

Introduced Unstructured Snap Pack that enables seamless integration with the Unstructured API to extract structured data from raw unstructured documents. It transforms the provided data to inject into your application, data, and other generative AI needs. It contains the following Snap and Account:

  • Partition API: Extracts structured data from raw unstructured documents using the Unstructured API and transforms it into structured data.

  • Unstructured API Account: Authenticates with Unstructured API using the specified credentials.

Adobe PDF

Jul 9, 2024

437patches27004

Introduced Adobe PDF Snap Pack that enables you to integrate PDF functionalities into applications using Adobe’s REST APIs. It contains the following Snaps and Account:

  • Extract: Extracts text, table, and figures from a PDF file.

  • OCR: Adds a scannable layer on top of an image-based PDF file.

  • Adobe Account: Authenticates with Adobe APIs using the specified Client ID and Client secret.

OpenAI LLM

Jul 9, 2024

437patches27021

Enhanced the OpenAI Chat Completions Snap with Advanced prompt configuration field set that enables the Snap to parse JSON objects to include them in the output and configure system prompts to guide the responses or actions.

Azure OpenAI LLM

Jul 9, 2024

437patches27098

  • Updated the API version for the Azure OpenAI LLM Snap Pack from 2023-05-15 to 2024-02-01.

  • Enhanced the Azure OpenAI Chat Completions Snap with Advanced prompt configuration field set that enables the Snap to parse JSON objects to include them in the output and configure system prompts to guide the responses or actions.

Amazon Bedrock LLM

Jul 9, 2024

437patches27098

  • Enhanced the Amazon Bedrock Account with IAM Role and Cross-Account Access role support for enhanced security, scalability, and automation.

  • Enhanced the Anthropic Claude on AWS Messages Snap with Advanced prompt configuration field set that enables the Snap to parse JSON objects to include them in the output and configure system prompts to guide the responses or actions.

SQL Server

Jul 5, 2024

437patches27091

Fixed a case-sensitivity issue with the SQL Server—Bulk Load Snap that caused a NullPointerException when retrieving the PATH environment variable in a Windows environment. This change is applicable only to Windows, as environment variables are case-sensitive in Linux.

Binary

Jun 28, 2024

437patches26873

Fixed an issue with the File Poller Snap where the Snap applied a case-sensitive filter in the Windows operating system.

Vertica

Jun 28, 2024

437patches26900

The jOOQ library for Vertica Snap Pack is upgraded from v3.9.1 to v3.17.x. This upgrade will be part of the GA release on August 14, 2024 (Stable release). Learn more.

Snowflake

Jun 27, 2024

437patches26821

  • 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.

ELT

Jun 24, 2024

437patches26846

Fixed the issue with the ADLS Gen 2 account connection where some conflicts between internally used Azure libraries prevented the ELT Load Snap from reading files.

  • Fixed an issue with the ELT Merge Into Snap where the 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 including table names, column names, data types among their other metadata.

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

NetSuite SOAP

Jun 24, 2024

437patches26823

In a specific scenario where the body is absent in the SOAP request, the NetSuite Search Snap reloads the envelope to prevent the Snap from erroring out.

MongoDB

Jun 24, 2024

437patches26832

Fixed the inconsistency in ObjectId and Date representation in the output preview between MongoDB - Execute and MongoDB - Find snaps.

Enhanced the MongoDB Execute Snap with the Timezone Offset field set that enables you to apply the timezone offset on the date fields.

API Suite

Jun 24, 2024

437patches26862

Fixed an issue with the HTTP Client Snap where redirect URLs containing spaces were not properly encoded, resulting in runtime errors.

API Suite

Jun 18, 2024

437patches26826

Enhanced the SSL OAuth2 Account with the Send Client Data as Basic Auth header checkbox that enables you to send the client information as a header to the OAuth endpoint.

SAP Concur

Jun 13, 2024

main175

Fixed the documentation links for SAP Concur Snap Pack.

Sharepoint Online

Jun 13, 2024

main175

Admin Manager

New Feature

  • In environments subscribed to multi-factor authentication (MFA), Environment admins can now configure user and team accounts to log in with MFA. Learn more.

    enable-mfa.png

API Management

Enhancements

Known Issue

  • When you create an API Proxy with the API Suite Outbound OAuth2 policy and call the Proxy endpoint with basic auth credentials, the authentication fails with a 400 error (bad request).

AutoSync

Enhancements

  • You now have the option to connect to any endpoint with a Groundplex:

    • Select a Groundplex or the AutoSync Snaplex when selecting a target in the wizard or when editing a data pipeline.

    • The Groundplex must have connectivity to all endpoints in the data pipeline. Learn more.

  • Merge columns in the data pipeline wizard and the edit screen have two usability enhancements. The following highlights the changes in the edit screen:

    as-transform-overlay-buttons.png

    • Columns selected to merge display in an overlay on the right side, making it easier to navigate the preview and choose other columns.

    • Cancel and save actions are now available below the merge configuration. This clearly separates the controls to cancel or save a single merge from the buttons to cancel or save all configured merges.

Known Issues

  • The merge column preview doesn’t update correctly when you drag the column names to reorder the data. When you save the merge, the new column reflects the correct order.

  • A new merged column can fail to load because of the name’s case. For example, for a Snowflake target, until this issue is fixed, the name must be uppercase and for a Redshift target, the name must be lowercase.
    Workaround: If a merged column fails to load, try changing the case of the name.

Documentation Updates

API Management Enhancements

  • Updated the OAuth 2.0 Client Credentials Policy with the OAuth2 framework for the client credentials grant type. Learn More.

  • The FAQ document for the API Management solution is now available. Learn More.

Content Published on New Doc Site

  • The first version of a new Introduction section, designed for new SnapLogic users, contains workflow and architectural concepts and links to existing content for more details.

Video

Watch how to navigate Monitor to analyze, review, and observe activity in your SnapLogic environment.

Watch the Integration Catalog video to know more about it.

GenAI Builder

Introduced the OpenSearch Snap Pack, which contains the following Snaps and Account:

  • OpenSearch Query: Executes a query on the specified OpenSearch index.

  • OpenSearch Upsert: Performs an operation that updates existing records if they exist, or inserts new records if they don't.

  • OpenSearch Account: Authenticates with OpenSearch services using the specified AWS account credentials.

Monitor

New Features

  • A new Node diagnostics table shows the maximum, minimum, recommended, and current values for configurable parameters to help you maximize Snaplex node performance and avoid issues. It also shows average and peak RAM usage.
    In the System overview, click a Snaplex node to open its details panel. Click the Additional details tab to view the table. Entries in red in the Current value column highlight settings that do not meet the recommendation:

    Activity logs now include project-level events such as pipeline validation events. You can filter the log by Project events. Learn more.

Enhancements

Monitor enhancements include:

  • The Insights page now opens first when you navigate to Monitor. The calendar can be set to show statistics for the last year. Previously, the limit was six months.

  • You can now stop a running execution or restart a resumable pipeline from the Execution overview page. The following shows the Stop pipeline option on the execution row Actions menu:

  • The details panel for a pipeline execution now includes a link to open the pipeline in Designer, the Task Name, and two new fields:

    • Slot—Snaplex nodes are configured with a maximum number of slots, or allocated memory spaces. Each Snap uses a slot to execute. This is the count of the number of slots used by the pipeline.

    • Resumable—Indicates whether the Resumable subscription feature is enabled for a pipeline.

  • The new State Transition tab in the pipeline execution details panel updates with a timestamp when the pipeline transitions from the prepared to the completed state:

  • The details panel for an Ultra Task pipeline includes two new fields:

    • Max-in-flight—The threshold for the number of documents a single node processes. When the execution re