/
August 2023 Release Notes

August 2023 Release Notes

Highlights

The SnapLogic® August 2023 Release includes the following:

Admin Manager

  • New interface to manage users, groups, service accounts, and roles

API Management

  • Additional insights into Ultra Task requests on the APIM dashboard

AutoSync

  • New source endpoints: Google Sheets, Snowflake, and Google BigQuery

  • Propagate field and column data type changes to the destination

  • New Append load type for CSV files

  • Updated experience for sharing data pipelines

Platform

  • Support for GitLabs

  • App gateway for connectivity for on-premises Git servers

  • Secrets Cache for Secrets Management

  • Support for linking Git repositories with Project Spaces

  • Support for Azure Key Vault using managed identity-based authentication

  • LDAP authentication on HashiCorp Vaults

Snaps

  • Introduced the following new Snap Packs:

    • Microsoft Dynamics 365 Business Central

    • Google Analytics 4

  • Introduced the following Snaps:

    • GeoJSON Parser

    • Google BigQuery Upsert (Streaming)

    • HDFS Delete

    • PGP Sign

    • SAP SuccessFactors Read Advanced

    • WKT Parser

  • SnapGPT (Early Access)

    You can now build your pipelines using simple text prompts.

August UAT Delta

This section tracks the changes made during the iterative pushes to the UAT server and the GA release. The following is the release schedule:

  • UAT: Friday, August 11, 2023 – Snaplex version: main-19739 - 4.34 GA (Recommended)

  • GA: Wednesday, August 16, 2023 – Snaplex version: main-19739 - 4.34 GA (Recommended)

The SnapLogic GA release build on the production server is also deployed on the UAT server.

About Upgrading to this Release

  • To use the new SnapLogic features and Snaps in the current GA release, ensure that your Snaplex nodes are upgraded to the recommended version.

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

  • Per the SnapLogic Release calendar, all remaining Snaplexes across Orgs are automatically upgraded to the recommended version. The automatic upgrade ends approximately at 4 PM (Pacific Standard Time) on Saturday, Sep 16, 2023. Orgs migrated to the current GA release before the automatic upgrade are not impacted. We strongly recommend that you use the recommended version for your Snaplexes.

Dot Releases - Snaps

Snap Pack

Date of Update

Snap Pack Version

Updates

Snap Pack

Date of Update

Snap Pack Version

Updates

Marketo

Sep 11, 2023

434patches22837

Updated the input and output schema for the Marketo Snaps.

SQL Server

Sep 11, 2023

434patches22758

Fixed an issue with the SQL Server Stored Procedure and Table List Snaps that caused no retries to be executed even though the user had selected a number of retries in the UI when a custom JDBC driver was used.

Oracle

Sep 8, 2023

434patches22787

Fixed an issue with the Oracle-Bulk Load Snap that was not resilient to the errors previously when trying to auto-discover the existing SQLLDR utility paths in the node. The Snap is now robust to those errors.

Microsoft OneDrive

Sep 7, 2023

434patches22736

  • Fixed an issue with the Microsoft OneDrive Snap Pack where the Snaps displayed Duplicate key OneDrive error. The Snaps now hide the drive details stored in the PreservationHoldLibrary folder when displaying suggestions. You can use the Drive ID to access the PreservationHoldLibrary folder.

  • Fixed an issue with the Mircosoft OneDrive Snaps that displayed a JsonNull error when the shared library list was empty. Now, it displays the message No Suggestions available.

Binary

Aug 31, 2023

434patches22639

The JSON key field in the Binary Google Service Account supports JSON strings. You can upload the JSON key either from SLDB or dynamically pass the value using a pipeline parameter or access values from Secrets Manager.

Transform

Aug 29, 2023

434patches22705

Fixed an issue with the JSON Splitter Snap that caused the pipeline to terminate with excessive memory usage on the Snaplex node after the 4.33 GA upgrade. The Snap now consumes less memory.

Hadoop

Aug 25, 2023

434patches22662

  • Enhanced the Parquet Writer Snap with the support for LocalDate and DateTime. The Snap now displays the schema suggestions for LocalDate and DateTime correctly.

  • Enhanced the Parquet Reader Snap with the Use datetime types checkbox that supports LocalDate and DateTime datatypes.

Behavior change:

When you select the Use datetime types checkbox in the Parquet Reader Snap, the Snap displays the LocalDate and DateTime in the output for INT32 (DATE) and INT64 (TIMESTAMP_MILLIS) columns. When you deselect this checkbox, the columns retain the previous datatypes and display string and integer values in the output.

API Suite

Aug 24, 2023

434patches22631

Fixed an issue with the HTTP Client Snap that displayed incorrect cookie information, with a null value in the cookies when you have duplicate cookies in the header. The Snap now displays the cookie information correctly.

Flow

Aug 23, 2023

434patches22576

Fixed an issue with the Pipeline Execute Snap that caused a null pointer exception during the retry when the input view was a Binary type. Retry is not supported for a Binary input view with this Snap.

Azure Active Directory

Aug 23, 2023

434patches22620

Fixed an issue with the Azure Active Directory Create Entry Snap that caused it to fail with a cast error when a boolean value was entered in a field where expressions were enabled.

SOAP

Aug 23, 2023

434patches22655

Fixed an issue with the SOAP Execute Snap that caused it to be unable to parse some WSDL files.

SQL Server

Aug 22, 2023

434patches22579

Improved the SQL Server Bulk Load Snap to help reduce the chance of causing a deadlock error.

Anaplan

Aug 21, 2023

434patches22600

  • Fixed an issue with the Anaplan Action Snap that caused the File Not Found error to display when multiple instances of the Anaplan Upload Snap (which included empty files) were executed concurrently.

  • Enhanced the Anaplan Snap Pack with support for retries to avoid Server failure error during the pipeline execution.

Salesforce

Aug 21, 2023

434patches22537

Improved the Salesforce Bulk Upsert Snap error messages by limiting the length of the reason displayed with the error.

Aug 21, 2023

 

434patches22601

 

Google Analytics 4

Aug 17, 2023

434patches22562

Fixed an issue with the Google Analytics 4 Create Report and Create Realtime Report Snaps that improperly rounded off decimal data. You can now view the precise value in the report.

Admin Manager

Admin Manager is a new interface for administrators with an updated user experience based on feedback from you. The classic IIP Manager will be phased out when all settings become available in Admin Manager.

Open Admin Manager from the application menu:

Application menu

This release introduces a subset of features. Manage users, groups, service accounts, and roles from Admin Manager. Learn more.

Features

Admin Manager introduces new concepts and terminology:

  • Orgs are called environments, and an Org admin is called an Environment admin.

  • Roles are used instead of groups to differentiate admins from regular users.

  • Groups provide a way to share assets such as AutoSync data pipelines, AutoSync credentials, and IIP Account assets.

Known Issues

  • On the Roles screen, the count of users for each role does not match the number shown on the details page. The details page opens when you click a role.

  • When you delete a user and get a confirmation notice, the deleted user might display in the list for a short time while their assets are being deleted.

API Management

Enhancements

The APIM dashboard displays more data for Ultra requests. The dashboard displays the number of requests waiting in the queue for each minute, every FeedMaster node, and the total number of requests across all FeedMaster nodes. You can now view the average wait time, average processing time, and average total time for each Ultra Task.

The API dashboard also introduces a new Queue Size widget that displays the number of requests inline to be processed per time segment.

Known Issues

In the Response Mapper and Response Transformer policies, APIM functions display in the expressions dropdown menu but do not actually work.

AutoSync

Features

  • AutoSync now supports the following endpoints:

  • Detection of changes to source data types: Now AutoSync detects changes to source column or field data types and updates the destination table with a compatible type. Supported for Amazon Redshift, Google BigQuery, and Snowflake destinations. Learn more.

Enhancements

  • You can now append data to a table created from a CSV file by splitting the file. This is useful, for example, when the data exceeds the 100 MB size limit or when a system periodically generates CSV files and you want them to load to the same table. Learn more.

  • New experience for sharing data pipelines. Learn more.

  • The Snowflake destination endpoint now uses internal Snowflake staging, which removes the need to have and configure a separate staging environment.

  • The Amazon Redshift endpoint now supports using an S3 bucket for staging that is in a different AWS region. If the S3 bucket is in the same region as the Redshift instance, you can leave the region unspecified.

Known Issues

  • When a data pipeline with Snowflake as a destination encounters an error, it stops loading. It should instead log the error record and continue.

Data Automation

Enhancement

  • Upgraded the JDBC driver support for Snowflake to snowflake-jdbc-3.13.33.jar.

  • Updated the ELT Snowflake Account to append or replace (if it exists) the connection parameter application in its JDBC URL with the value