Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel1
outlinefalse
typeflat
separatorbrackets
printablefalse

...

The MongoDB - Atlas Vector Search Snap now supports the following:

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

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

    Snap Pack

    Date of Update

    Snap Pack Version

    Updates

    SQL Server

    437patches27732

    Fixed an issue with the SQL Server - Select Snap configured with an Ultra task to handle temporary database unavailability. The Snap now validates the database connection to ensure that it is reestablished after temporary database outages.

    API Suite

    08 Microsoft Dynamics 365 for Sales

    437patches27592

    Updated the API Suite Snaps to process authentication information from incoming documents to support features such as Secrets manager-based credentials.

    Databricks

    437patches27246

    Added the following Snap to the Databricks Snap Pack:

    • Databricks - Run Job: Executes a job, checks its status in Databricks, and, based on the job's status, completes or fails the pipeline.

    Snowflake

    437patches27531

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

    PostgreSQL

    437patches27531

    Enhanced the Postgres and Postgres Dynamic Accounts with support for IAM and Cross-account IAM role authentication.

    API Suite

    437patches27587

    Fixed an issue with the HTTP Client Snap that caused NullPointerException when the Retry-After header contained a decimal value in the 429 (Too Many Requests) response.

    RabbitMQ

    437patches27616

    Fixed the following issues with the RabbitMQ Producer Snap:

    • With no access to the virtual hosts, the Snap displayed a null pointer exception.

    • The Snap did not display the original payload when the error view was enabled.

    Azure OpenAI LLM

    437patches27527

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

    OpenSearch

    437patches27473

    Added the Amazon OpenSearch Account to the OpenSearch Snap Pack to authenticate with OpenSearch services using the specified Access key ID and Secret access key. This account also provides Cross-account IAM role support.

    PDF

    437patches27596

    Fixed an issue with the PDF Parser Snap that could not parse multiple incoming PDF documents and processed only the first document (without errors).

    Hadoop

    437patches27226

    The upgrade of the Azure Storage library from v3.0.0 to v8.3.0 has impacted the Hadoop Snap Pack causing the following issue when using the WASB protocol.

    Panel
    bgColor#DEEBFF

    Known Issue

    When you use invalid credentials for the WASB protocol in Hadoop Snaps (HDFS Reader, HDFS Writer, ORC Reader, Parquet Reader, Parquet Writer), the pipeline does not fail immediately, instead it takes 13-14 minutes to display the following 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.

    Learn more about the Azure Storage Library Upgrade.

    SQL Server

    437patches27328

    Fixed an issue with the SQL Server Insert Snap that caused an error when inserting the infinity value into a decimal-type column.

    MongoDB

    437patches27343

    Shopify

    437patches27471

    Fixed a resource leak issue with the Shopify Snaps, which involved too many stale instances of ProxyConnectionManager and significantly impacted memory utilization.

    Facebook

    437patches27471

    Fixed a resource leak issue with the Facebook Snaps, which involved too many stale instances of ProxyConnectionManager and significantly impacted memory utilization.

    Hadoop437patches27711

    Fixed an issue with the Dynamics 365 for Sales Execute Snap that encountered a NullPointerException error for a 204 No Content return status. Now a custom output document is successfully returned for a 204 No Content status.

    Confluent Kafka

    437patches27730

    Fixed an issue with the Kafka Consumer Snap where the Seek Type of Beginning or End (skip all existing messages) may not work correctly after a rebalance. 

    API Suite

    437patches27592

    Updated the API Suite Snaps to process authentication information from incoming documents to support features such as Secrets manager-based credentials.

    Databricks

    437patches27246

    Added the following Snap to the Databricks Snap Pack:

    • Databricks - Run Job: Executes a job, checks its status in Databricks, and, based on the job's status, completes or fails the pipeline.

    Snowflake

    437patches27531

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

    PostgreSQL

    437patches27531

    Enhanced the Postgres and Postgres Dynamic Accounts with support for IAM and Cross-account IAM role authentication.

    API Suite

    437patches27587

    Fixed an issue with the HTTP Client Snap that caused NullPointerException when the Retry-After header contained a decimal value in the 429 (Too Many Requests) response.

    RabbitMQ

    437patches27616

    Fixed the following issues with the RabbitMQ Producer Snap:

    • With no access to the virtual hosts, the Snap displayed a null pointer exception.

    • The Snap did not display the original payload when the error view was enabled.

    Azure OpenAI LLM

    437patches27527

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

    OpenSearch

    437patches27473

    Added the Amazon OpenSearch Account to the OpenSearch Snap Pack to authenticate with OpenSearch services using the specified Access key ID and Secret access key. This account also provides Cross-account IAM role support.

    PDF

    437patches27596

    Fixed an issue with the PDF Parser Snap that could not parse multiple incoming PDF documents and processed only the first document (without errors).

    Hadoop

    437patches27226

    The upgrade of the Azure Storage library from v3.0.0 to v8.3.0 has impacted the Hadoop Snap Pack causing the following issue when using the WASB protocol.

    Panel
    bgColor#DEEBFF

    Known Issue

    When you use invalid credentials for the WASB protocol in Hadoop Snaps (HDFS Reader, HDFS Writer, ORC Reader, Parquet Reader, Parquet Writer), the pipeline does not fail immediately, instead it takes 13-14 minutes to display the following 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.

    Learn more about the Azure Storage Library Upgrade.

    SQL Server

    437patches27328

    Fixed an issue with the SQL Server Insert Snap that caused an error when inserting the infinity value into a decimal-type column.

    MongoDB

    437patches27343

    The MongoDB - Atlas Vector Search Snap now supports the following:

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

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

    Shopify

    437patches27471

    Fixed a resource leak issue with the following Hadoop Shopify Snaps, which involved too many stale instances of ProxyConnectionManager and significantly impacted memory utilization:.

    JDBC

    PostgreSQL

    Facebook

    437patches27471

    Fixed a resource leak issue with the Facebook Snaps, which involved too many stale instances of ProxyConnectionManager and significantly impacted memory utilization.

    Hadoop

    437patches27416437patches27471

    Fixed an a resource leak issue with the Generic JDBC - Insert and PostgreSQL - Insert Snaps that exposed following Hadoop Snaps, which involved too many stale instances of ProxyConnectionManager and significantly impacted memory utilization:

    JDBC

    PostgreSQL

    437patches27416

    Fixed an issue with the Generic JDBC - Insert and PostgreSQL - Insert Snaps that exposed sensitive information in the error message when the batch operation was not successful.

    PostgreSQL

    Google AlloyDB

    437patches27416

    Fixed an issue with the PostgreSQL - Bulk Load and AlloyDB Bulk Load Snaps that caused incorrect or invalid binary data to be inserted when the column was of Binary type.

    Kafka

    437patches27404

    Fixed an issue with the Kafka SSL Account that displayed an error when the Kafka Consumer Snap could not commit offsets during the rebalancing process. This behavior avoids unstable partition allocation. Now, the Snap logs a warning, allowing the Kafka Consumer to continue processing instead of displaying an exception.

    Azure SQL

    437patches27180

    Fixed the following issues with the Azure SQL - Bulk Load Snap:

    • The Snap displayed an error when the DateTime was of the LocalDateTime type.

    • The Snap lost milliseconds when the DateTime was in the String data type because we were parsing the given DateTime format into a Date object and creating the timestamp object from that date.

    ELT

    437patches27372

    • Enhanced the pipeline execution statistics of the ELT Insert-Select Snap to be displayed in its output view and to allow downloading detailed stats as a JSON file that includes additional statistics (extraStats) on DML statement executions on target Databricks Lakehouse Platform (DLP) tables.

    OpenAI LLM

    437patches27319

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

    Azure OpenAI LLM

    437patches27297

    Amazon Bedrock LLM

    437patches27322

    Salesforce

    437patches27307

    Fixed authentication issues with the Salesforce Subscriber Snap in the Ultra Pipeline to ensure the Snap reauthenticates and reconnects as expected.

    Anaplan

    437patches27283

    Fixed an intermittent connection reset issue with the Anaplan Snaps caused by the absence of the keep-alive header in the server response.

    ELT

    437patches27246

    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. The Snap also allows you to download detailed stats as a JSON file that includes additional statistics (extraStats) on DML statement executions on target Databricks Lakehouse Platform (DLP) tables.

    Binary

    437patches27146

    Enhanced the Azure Storage Account with Managed Identity, which provides applications with an automatically managed identity for connecting to resources that support Microsoft Entra ID authentication.

    Google Sheets

    437patches27197

    Fixed an issue with the Google Sheets Writer Snap where using cell names as worksheet names caused incorrect data writing behavior.

    ...

    • Improved performance for the group by Pipeline and Task aggregations in the Monitor Execution overview.

    • Monitor now saves specific selections across sessions. When you switch pages or log out and log in across different user sessions, Monitor saves some selections that you made on the initial page. For example, the list view/map view in the Infrastructure page and Column Preferences in the Execution overview are saved across sessions. Additionally, Monitor saves selections in the current session for the time window.

    • In the pipeline details Snap Statistics tab, hover over a Snap to see additional information such as the status, Snap ID, and Snap Pack Build:

      snap-details.pngImage Removed

    Platform

    New Features

    • New public API to download and save the slpropz file. Learn more.

    Enhancements

    • Users can now configure sending Slack and email notifications when a task is delayed.

    Change in Behavior

    • Project-level pipeline execution: Before this release, tasks stored in a Project Space could execute pipelines in a different Project Space or by requests from a different Org. With the current release, tasks must belong to the same Project Space as the pipeline to execute successfully. Learn more.

    • The Snaplex configuration file (.slpropz) is no longer available as a URL in the user interface to enhance security. Instead, you can download it from the Snaplex > Downloads tab by clicking (blue star) or with the API GET /api/1/rest/plex/config/<path_to_groundplex>. Learn more.

    ...

    • sessions. Additionally, Monitor saves selections in the current session for the time window.

    • In the pipeline details Snap Statistics tab, hover over a Snap to see additional information such as the status, Snap ID, and Snap Pack Build:

      snap-details.pngImage Added

    Platform

    New Features

    • New public API to download and save the slpropz file. Learn more.

    Enhancements

    • Users can now configure sending Slack and email notifications when a task is delayed.

    Change in Behavior

    • Project-level pipeline execution: Before this release, tasks stored in a Project Space could execute pipelines in a different Project Space or by requests from a different Org. With the current release, tasks must belong to the same Project Space as the pipeline to execute successfully. Learn more.

    • The Snaplex configuration file (.slpropz) is no longer available as a URL in the user interface to enhance security. Instead, you can download it from the Snaplex > Downloads tab by clicking (blue star) or with the API GET /api/1/rest/plex/config/<path_to_groundplex>. Learn more.

    ...

    Known Issues

    • 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

    The Snaps mentioned in this section are deployed on the Latest distribution type. To access the updated Snap Packs, an Org admin must select the Snap Pack version in Manager > Snap Packs.

    ...

    Note

    Your existing PostgreSQL pipelines that use the default driver (bundled with the PostgreSQL Snap Pack) might break because this upgrade is not fully backward-compatible.

    ...

    • Some error messages will now include the data type, for example:

      • Old: "...where (badId = 1) was aborted:..."

      • New: "...where (badId = ('1'::numeric)) was aborted:..."

    • There are some minor text changes to a few of the error messages, for example:

      • Old"Hint: No operator matches the given name and argument types."

      • New"Hint: No operator matches the given name and argument type(s)."

    ...