November 2024 Release Notes

November 2024 Release Notes

Highlights

The SnapLogic November 2024 Release includes the following highlights:

Admin Manager

  • Configure Asset catalog (formerly Integration catalog) visibility

  • Manage Enhanced Account Encryption and Trusted environments for account migration

  • Configure the Git Integration

AgentCreator (formerly GenAI App Builder)

Provides the following capabilities to create agents:

  • Advanced response configuration: Enables consistent output for all LLM providers

  • Stop sequence support: Allows reduced token usage on output when the expected sequences hit

  • Tool calling: Included in the Flow Snap Pack with the PipeLoop Snap and in the LLM Utilities Snap Pack with the Message Appender Snap

  • Multimodal input support available in all LLM provider Snap Packs

AutoSync

  • New SQL Server Bulk Load endpoint

Monitor

  • Integration catalog renamed to Asset catalog

  • Ability to edit custom Asset catalog metadata from Task details

Platform

  • New API for managing Asset catalog custom metadata

Snaps

 


Dot Releases: Snaps

 

Snap Pack

Date

Snap Pack Version

Updates

 

Snap Pack

Date

Snap Pack Version

Updates

Teradata

Dec 5, 2024

439patches29265

  • Fixed an issue with the Teradata FastLoad Snap that validated successfully even when the fast load was paused due to an error. The Snap now displays the error with the appropriate reason for the pause.

  • Fixed an issue with the Teradata FastLoad Snap where an invalid output document was generated when an error occurred while fetching the table schema, and the Create table if not present, checkbox is deselected. Now, the Snap correctly displays an error in such cases, regardless of the checkbox status.

Salesforce

Dec 3, 2024

439patches29230

Fixed the vulnerabilities in CXF library dependencies within the Salesforce Snap Pack to enhance security and ensure reliable functionality.

OpenAI LLM

Dec 3, 2024

439patches29164

Azure OpenAI LLM

Dec 3, 2024

439patches29063

Enhanced the following accounts in the Snap Pack with the Read timeout (seconds) field that enables the Snap to wait for a response from Azure:

SAP

Dec 2, 2024

439patches29181

Enhanced the SAP Execute Snap with the Round to SAP decimal checkbox that enables the Snap to round the decimal value to match the number of Decimal Places defined in the SAP target field. This property only applies to the SAP packed decimal fields, which store data in the BCD (Binary Coded Decimal) format.

JDBC

Nov 28, 2024

439patches29008

  • Upgraded the JOOQ library of the JDBC Snap Pack from v3.9.1 to v3.17.x. Pipelines using the Generic - JDBC Snaps might be impacted by the jOOQ upgrade because the latest jOOQ version is not fully backward-compatible. Learn more.

  • Fixed an issue with Generic JDBC - Execute and Select Snaps when connecting to the Oracle database where the data was displayed in an unexpected structure and without the actual row address value when querying table columns of ROWID type. Now, the Snaps handle the ROWID type columns correctly to prevent the display of the nested output when ROWID is combined in the query with other selected columns.

Breaking change:

With the 439patches29008 Snap Pack version, existing pipelines using the Generic JDBC Execute and Select Snaps may experience issues when connecting to the Oracle endpoint specifically when handling the encoded ROWID (manually processing the Base64-encoded data). To avoid potential pipeline failures, it is recommended to downgrade the Generic JDBC Snap Pack to the previous version until the issue is resolved.

Behavior change:

Earlier, the ROWID columns were displayed in binary (Base64 encoded data) form in the output. With the 439patches29008, the Generic JDBC Execute and Select Snaps that integrate with the Oracle endpoint display the ROWID columns in string form in the output (which can be used for other operations downstream).

API Suite

Nov 22, 2024

439patches29124

  • Fixed an issue in the GraphQL Client Snap where improper extensions caused a validation error; however, it resulted in an empty error view when the Route Error Data to Error View was enabled.

  • Fixed an issue with the GraphQL Client Snap that did not load the Query Builder properly.

Transform

Nov 18, 2024

439patches29078

Fixed an issue with the CSV Parser Snap that introduced unexpected characters into the records and output data because of incorrect handling of the delimiter.

Salesforce

Nov 15, 2024

439patches29014

Fixed an issue with the Salesforce Lookup, SOQL, and SOSL Snaps, where errors were not routed to the error pipeline when Route Error Data to Error View was enabled, and a referenced expression variable was missing in the upstream or pipeline parameters.

Oracle

Nov 14, 2024

439patches29008

Fixed an issue with Oracle Execute, Select, and Stored Procedure Snaps where the data was displayed in an unexpected structure and without the actual row address value when querying table columns of ROWID type. Now, the Snaps handle the ROWID type columns correctly to prevent the display of the nested output when ROWID is combined in the query with other selected columns.

Breaking change:

Generic JDBC: With the 439patches29008 JDBC Snap Pack version, existing pipelines using the Generic JDBC Execute and Select Snaps may experience issues when connecting to the Oracle endpoint, specifically when handling the encoded ROWID (manually processing the Base64-encoded data). To avoid potential pipeline failures, it is recommended to downgrade the Generic JDBC Snap Pack to the previous version until the issue is resolved.

Behavior change:

Earlier, the ROWID columns were displayed in binary (Base64 encoded data) form in the output. With the 439patches29008, the Oracle Execute and Select Snaps display the ROWID columns in string form in the output (which can be used for other operations downstream).

AutoSync

Nov 19, 2024

439patches29077

438patches29076

Fixed an issue loading to Databricks. To consume this fix:

  • For a version 4.39 AutoSync Snaplex or Groundplex, upgrade data pipelines with Databricks as a target to use the AutoSync 439patches29077 Snap Pack.

  • For a version 4.38 AutoSync Snaplex or Groundplex, upgrade data pipelines with Databricks as a target to use the AutoSync 438patches29076 Snap Pack.

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-28272 - 4.39 GA (Recommended).

All Snaplexes on older versions will be upgraded to the recommended version during the mandatory automatic upgrade, which is scheduled for 3 PM (PDT) on Saturday, Jan 11, 2025. For other Snaplex versions released this year, view the SnapLogic Release calendar.

Admin Manager

New Features

  • System Configuration now includes the Git Integration page for selecting a Git provider. This supports continuous integration and continuous development (CI/CD) across different environments. Learn more.

    image-20241101-072520.png
  • In the Security section, configure Enhanced Account Encryption (EAE) from the Account encryption page. With a subscription to EAE and use of a Groundplex, sensitive account data is encrypted with a public key in the SnapLogic control plane and decrypted with a private key on the Groundplex. Learn more.

    account-encryption.png

     

  • In the Application settings section, configure Asset catalog visibility. The Asset catalog is available to enterprise SnapLogic customers by request. Learn more.

    image-20241106-104259.png

AgentCreator

AgentCreator represents the next major revision of the GenAI App Builder. It offers advanced features for enterprises to create agents that have the ability to reason and use tools to perform tasks autonomously. The tool can be any SnapLogic connector, pipeline, or API. It also includes comprehensive observability and validation capabilities that allow enterprises to understand and evaluate agent actions.

Breaking change:

With the main29029 GA release, ARRAY and OBJECT options have been removed from the Type dropdown list in the Azure OpenAI Function Generator and OpenAI Function Generator Snaps. If your existing pipelines use these options, the following errors display:

  • Invalid property value found (ARRAY), must be one of: INTEGER, NUMBER, STRING, BOOLEAN

  • Invalid property value found (OBJECT), must be one of: INTEGER, NUMBER, STRING, BOOLEAN

Workaround: Replace ARRAY and OBJECT options with supported types (INTEGER, NUMBER, STRING, or BOOLEAN).

New Features

Enhancements

Known Issues

Limitation

  • The OpenAI documentation states that cancelled is a supported value for the Filter field in OpenAI List Vector Store Files. However, using this value can result in a status code 400 error from the endpoint. To avoid the 400 status code, use only the following supported values: completed, in_progress, and failed.

API Management

Fixed Issues

  • On the APIM Metrics/API Dashboard, Alerts no longer display the error, unable to instantiate policy.

AutoSync

New Features

  • The new SQL Server Bulk Load endpoint provides better performance for data pipelines that synchronize large datasets. This endpoint requires:

    • The data pipeline must run on a Groundplex configured to use the Microsoft SQL Server Bulk Copy Utility, bcp. Before using this endpoint in an AutoSync data pipeline, you must install the utility on each Groundplex node.

    • The 438patches28952 AutoSync Snap Pack. Refer to AutoSync settings for information on selecting a Snap Pack for a data pipeline.

Fixed Issues

  • Fixed an issue loading to Databricks. To consume this fix:

    • For a version 4.39 AutoSync Snaplex or Groundplex, upgrade data pipelines with Databricks as a target to use the AutoSync 439patches29077 Snap Pack.

    • For a version 4.38 AutoSync Snaplex or Groundplex, upgrade data pipelines with Databricks as a target to use the AutoSync 438patches29076 Snap Pack.

Documentation Enhancements

View the list of help articles that have been migrated to docs.snaplogic.com from the legacy documentation site. 

New Videos

  • Learn how to create an APIM API version using assets in the Git Repository

    Create an API version from a Git Repository.mp4
  • Compare the interface for node metrics in Dashboard with the new one in Monitor: Dashboard to Monitor - Node Metrics

Monitor

Enhancements

  • The Integration catalog, available to enterprise SnapLogic customers by request, is now the Asset catalog. It includes the following enhancements:

    • With the new API described in the Platform section, you can add custom metadata columns to the table of tasks and add, update, or delete existing custom metadata values from a task.

    • With the new configuration described in the Admin Manager section, you can allow all users view-only access to the Asset catalog or restrict it to admins.

    • The new Pipelines tab displays standard pipeline metadata:

      catalog-pipelines-tab.png
    • Task details are easier to read, with important information moved to the header and execution statistics split out into a new tab:

      catalog-task-general-tab.png
    • The Custom tab on the Task details pane includes the ability to edit custom metadata values:

      catalog-task-edit-metadata2.png

Known Issues

  • The Asset catalog Edit metadata functionality in the Custom tab of task details has an issue. When editing, if you click Clear to remove an existing value and then click Cancel, the value is deleted instead of being retained as expected.
    Workaround: Re-enter the cleared value and click Save.

  • The average number of documents processed for pipelines that contain a BigQuery Execute Snap is being incorrectly reported as zero. This impacts both the Asset catalog and the Execution overview.

  • In the Asset catalog Pipelines tab, when you filter by the Path column, a search might not return all pipelines that match.

  • The Asset catalog Execution statistics tab for task and pipeline details currently displays no data.

Fixed Issues

  • The Node status and Node type filters are no longer missing from the System overview node view.

  • The documentation Graph descriptions page clarifies which graphs represent total values and which show the average percentage of the value.

Platform

New Features

Enhancements

Fixed Issues

  • The runtime pusher (the mechanism by which the pipelines are initialized before they process data) was improved for better node performance.

  • Pipelines were failing because the Snaplex JCC ran out of the connections, resulting in the error: Timeout waiting for connection from pool.

  • Pipeline executions were taking longer due to the slow preparation of the pipelines.

  • On the APIM Metrics/API Dashboard, alerts were displaying the error: unable to instantiate policy.