/
August 2021, 4.26 Release Notes

August 2021, 4.26 Release Notes

In this article

Key New Features in SnapLogic

Platform:

  • Zero Downtime during quarterly release updates.
  • Snaplex-based Scheduler will be the default scheduling mechanism for all Scheduled Tasks after the auto-upgrade on September 18.
  • Ability to encrypt SnapLogic user emails.

API Management: 

  • Ability to manage lifecycle of APIs.
  • Redesigned API Catalog and API documentation for the Developer Portal.
  • Support for creating APIs from existing SnapLogic Assets.

New Snaps:

  • Shopify Snap Pack.
  • Tableau Snaps—Hyper Formatter, Hyper Parser, and Hyper Write.
  • Zuora Snaps—Zuora OpenAPI and Zuora REST Read.

ELT for Cloud Data Platforms:

  • Support for Databricks Lakehouse Platform as a target database.
  • Ability to run multiple SQL queries using ELT Execute Snap.

New! Introducing SnapLogic Flows


4.26 UAT Delta

 Click here to expand...

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 1: Friday, July 30, 2021 – Snaplex version: 4.26_rc-10116 - 4.26 GA (Recommended)

  • UAT 2: Friday, August 06, 2021 

  • GA: Saturday, August 14, 2021 (9 p.m. PT)  

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

Important

  • Per the SnapLogic Release Process, all remaining Snaplex instances across Orgs are auto-upgraded to the main-10245 - Patch 1 version at 9 p.m. PT on September 18, 2021. Orgs migrated to the 4.26 GA version prior to the auto-upgrade are not impacted. 

    The Snaplex upgrade process also upgrades the Java version to the latest version. After the upgrade, the Java version of your Cloudplex nodes may not be the same as your FeedMaster nodes. However, this does not impact the operations of your SnapLogic instance. We will be fixing this issue in a subsequent release.

  • To use the new SnapLogic features and Snaps in the 4.26 release, ensure that your Snaplex nodes are upgraded to the main-10245 - Patch 1 (Recommended) version.
  • This 4.26 release includes the patches deployed to SnapLogic after the 4.25 release, as listed in the 4.25 Dot Releases section. 

4.26 Dot Releases

Platform

Date of UpdateSnaplex BuildUpdates
 main-10631 - Patch 3
  • Fixed an issue that caused Pipelines to be stuck in the NoUpdate state.
  • Fixed an issue where some validated Pipelines would not show preview data.
  • Fixed an issue where some schedule tasks would fail to execute.
  • Fixed an issue that prevented the Snowflake Snap from loading JAR files.
main-10451 - Patch 2
  • Fixed an issue where the FeedMaster node would not enter maintenance mode. 
  • Fixed an issue where the Load Balancer node would return an error instead of stopping further requests when in maintenance mode.
N/A

Control Plane update:

  • Fixed an issue where system administrators would not receive password reset emails if email encryption was enabled. 
  • Fixed an issue where users were unable to see Tasks under the Task Column of the Dashboard
  • Fixed an issue where opening Ultra Task Details would return an Invalid ID error.
  • Fixed an issue where Ultra Tasks would continuously restart.
  • Fixed an issue that prevented users from updating a Snaplex with the Manage Snaplex Versions setting if the Snaplex had Slack users or channels added.
  • Fixed an issue that prevented users from creating APIs in projects that had Tasks with empty Snaplex instances configured. 
  • Added a read-only view for non-admin users to the Developer Portal.
 main-10245 - Patch 1 (Recommended)
  • Fixed an issue where Scheduled Tasks would execute twice after switching between control plane scheduling and Snaplex scheduling.
  • Fixed an issue where a Snaplex would wait an hour before starting to execute scheduled jobs after switching from control plane level scheduling to Snaplex level scheduling.

UI

Date of UpdateSnaplex BuildUpdates
 N/A
  • Fixed an issue where the Join Snap would fail after its input view was updated.
  • Fixed an issue where the default value of newly-added properties would not appear in existing instances of the Snaplex.
  • Fixed an issue where the Router Snap returned an error if a view was renamed multiple times.
  • Fixed an issue where some Pipeline Execute Snaps were missing the Reuse executions to process documents checkbox.
  • Fixed an issue that prevented the conditional fields of the Team Operations Snap and SQS Account from rendering.

Standard

Snap PackDate of UpdateSnaplex BuildUpdates
REST426patches12749

Fixed an issue with the REST Post Snap, where the Snap delayed the fetching of documents, when the batch size is greater than or equal to one.

SQL Server426patches12535

Fixed an issue in the SQL Server Bulk Load snap where boolean data type failed to load into BIT field.

Binary
Hadoop
426patches12288

Fixed memory leak issue when using the HDFS protocol in Hadoop and Binary Snaps.

Transform

426patches11922Fixed an issue with the Join Snap, where it exhausted the memory while buffering millions of objects.
Binary426patches11922Fixed an issue with the File Writer Snap, where the Snap failed to open a channel while accessing through a SFTP protocol.
Salesforce426patches12054Enhanced the Salesforce Subscriber Snap with improved resilience to network failures and fixed an issue with duplicate documents.
REST426patches11746

Enhanced the REST Post Snap to display all cookies (securedauth cookies and httponly cookies) from the CookieStore along with headers when you select the Show all headers checkbox.

Transform426patches11780Fixed an issue in the XML Formatter Snap, where the Map input to first repeating element in XSD checkbox is selected, while no XSD is specified for mapping the input.
RabbitMQ426patches11770

Enhanced the RabbitMQ Account with a new checkbox Cluster Support that enables multiple cluster node support for RabbitMQ Consumer and RabbitMQ Producer Snaps. You can select this checkbox to enable high availability of clusters by adding multiple hosts (Host name and Port) for each cluster node.

Marketo 426patches11555Fixed an issue with the Marketo Lead Read Snap, wherein the Snap generated the same next page token anytime during the day.
Email 426patches 11591

Fixed the following issues with the Email Archive Snap where the Snap:

  • Failed with an error User is authenticated but not connected, as the Snap did not re-authenticate with the server after the connection expired due to the long durations in the execution of Ultra Pipelines. 
  • Caused multiple copies of the same source message in the target folder when the Snap was executed multiple times in preview.
Transform 426patches11725Fixed an issue with the Join Snap wherein the upstream document flow of the right view is blocked by the left view, which hung the Join Snap.
DynamoDB426patches11593Fixed an issue with the DynamoDB Update Snap, where the data type conversion for input keys caused an error.
Binary 426patches11529
  • Fixed an issue with the Decompress Snap, where the Snap prematurely uncompressed multi-stream BZIP2 files.
  • Enhanced the PGP Encrypt Snap with improved memory usage and also fixed an issue with this Snap, where the Snap failed to encrypt large size files due to the lack of memory.
Workday 426patches11525Enhanced the Workday Read Snap with the new field Pool Size that controls the maximum number of threads in the pool. This field is available only when you select the Multi-threaded checkbox.
Snowflake 426patches11469Fixed an issue with Snowflake Insert and Snowflake Bulk Load Snaps where the schema names or database names containing an underscore (_) caused the Pipelines to time out.
Active Directory 426patches11280Fixed an issue with the Active Directory Add Member Snap that failed when using forward slash "/" in the Distinguished name field.
SharePoint Online main89Enhanced all Snaps in the SharePoint Online Snap Pack to support dynamic site and document library values using input document variables.

Data Automation

Snap PackDate of UpdateSnap Pack Build NameUpdates
ELT 426patches12534
  • Fixed an issue with ELT Transform Snap where it may display incorrect schema only in the previews (during Pipeline validation). This occurs especially when the incoming SQL statement (defined in the SQL Statement Editor of the upstream Snap) contains one or more of the WHERE, GROUP BY, HAVING , ORDER BY, LIMIT, LIMIT followed by OFFSET, and SAMPLE clauses. Here are a few Pipeline scenarios where this issue might surface:

ELT 426patches12021
  • Fixed an issue where the ELT Load Snap connecting to a Databricks Lakehouse Platform (DLP) instance failed to perform the load operation. Ensure that you provide a valid DBFS Folder path in the Snap's account settings as the Snap requires this folder path.
ELT 426patches11646
  • Enhanced the ELT Database Account to support token-based authentication (Source Location Session Credentials) to S3 locations for Snowflake and Redshift target databases.
  • Enhanced the ELT Aggregate Snap with the following changes:
    • Revised the field labels from:
      • GROUP BY Fields List field set > Output Field to GROUP BY Field.
      • ORDER-By Fields to ORDER-BY Fields (Aggregate Concatenation Functions Only).
    • Removed the Suggestion option for Field Name field under General Aggregate Functions List field.
    • Made the Alias Name fields in the Aggregate Concatenation Functions List and the Percentile Distribution Functions List field sets mandatory.
  • If your target database is a Databricks Lakehouse Platform (DLP) instance, then the ELT Load Snap supports loading data from source CSV files that contain only comma as the separator between values.
ELT 426patches11323
  • Enhanced the ELT Database Account to allow parameterization of field values using Pipeline Parameters. You can define and use these parameters in expression-enabled fields to pass values during runtime.

ELT 426patches11262
  • Fixed the following Known Issues recorded in the 4.26 GA version:
    • For a Snowflake target instance, the ELT Insert Select Snap does not suggest column names to select for the Insert Column field in the Insert Expression List.
    • The Snaps—ELT Merge Into, ELT Select, ELT Join, and ELT Filter—do not prevent the risk of SQL injection when your target database is Databricks Lakehouse Platform (DLP).
    • Intermittent null-pointer exceptions in the ELT Load Snap on Databricks Lakehouse Platform (DLP).

    • The ELT Insert Select Snap attempts to create the target table even when it exists in the Snowflake database.
    • When loading data from a JSON file into a target Databricks Lakehouse Platform (DLP) instance using an ELT Load Snap, if you choose the Drop and Create Table option as the Load Action and specify an additional column (that is not available in the JSON file) for the new table, it results in one more column null added to the new target table.
    • When you use the SQL editor in the ELT Select Snap configuration to define your SQL query, the Pipeline validation fails due to a syntax error in the following scenarios. However, the Pipeline execution works as expected. The only workaround is to drop the LIMIT clause and the optional OFFSET clause from the SQL query during Pipeline validation.
      • The query contains a LIMIT clause on a Snowflake, Redshift or Databricks Lakehouse Platform target instance: The SQL query created during Pipeline validation includes an additional LIMIT clause, for example: SELECT * FROM "STORE_DATA"."ORDERS" LIMIT 10 LIMIT 990

      • The query contains an OFFSET clause (supported in case of Snowflake and Redshift): The SQL query created during Pipeline validation looks like SELECT * FROM "STORE_DATA"."ORDERS" LIMIT 10 OFFSET 4 LIMIT 990

Platform 

Snaplex-based Scheduler

During the 4.26 release cycle's auto-upgrade date of September 18, the Snaplex-based Scheduler will be enabled by default through the Control Plane. The new scheduling mechanism improves the timeliness and reliability of Scheduled Task executions. You do not need to update your Snaplex instances to enable the new scheduler, unless you have set the feature flag to false for your Org, in which case you will have to switch it to true in order for the Snaplex-based Scheduler to be enabled for your Org. Contact support@snaplogic.com for more information. 

Zero downtime of the SnapLogic Platform during the release windowStarting with this release, we are implementing zero downtime for the SnapLogic Platform during quarterly release updates. Thus, you will be able to access the SnapLogic UI and all your Pipelines will run as schedule during the release window. For details, see the SnapLogic release