Versions Compared

Old Version 145

changes.mady.by.user Amritesh Singh

Saved on

compared with

New Version 146

changes.mady.by.user Amritesh Singh

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Snap Pack

Date of Update

Snap Pack Version

Updates

Google BigQuery

432patches20962

Fixed an intermittent null pointer exception that occurred in the BigQuery Write Snap.

Salesforce

432patches20586

Fixed an issue with the Salesforce SOQL and Salesforce Read Snaps where the Match Data Type checkbox selection was not honored if the Salesforce API field was set to Bulk API.

Snowflake

432patches20906

  • The default JDBC JAR for the Snowflake Snap Pack is upgraded to version 3.13.28 to support the GEOMETRY data type.

  • Fixed an issue with the Snowflake Multi Execute Snap to enable processing of large amounts of data (more than 2 billion records).

  • Fixed a column mismatch issue that was caused by an assumed null AWS token that could potentially be an empty string.

Microsoft OneDrive

432patches20510

Fixed the following issues with the OneDrive Snaps:

  • The Snaps erroneously displayed the permission error when the actual cause was an empty display name in the API.

  • The Snaps failed with a 403 error when selecting a user (in the User field) from the Suggestions list without the User.Read.All permission. Now you can enter the value manually in the User field and proceed with the specific operation you want to perform in OneDrive even if the Suggestions list is not available.

ELT

432patches20978

Fixed an issue with the ELT SCD2 Snap where the COLLATE column constraint (used in the new target table definition for Snowflake) resulted in an incorrect syntax internally, causing the pipeline to fail. The load operation succeeds with this fix.

Azure SQL

432patches20967

Fixed an issue with the connection pool in the Azure SQL accounts, which was affecting the Snap Pack's performance. You should now experience improved performance when using these accounts.

Hadoop

432patches20820

Fixed an authorization issue that occurs with the Parquet Writer Snap when it receives empty document input.

Microsoft Dynamics 365 Finance and SCM

432patches20657

Added the Dynamics 365 Finance and SCM Create, Update, and Delete /wiki/spaces/DRWIP/pages/2812510209, /wiki/spaces/DRWIP/pages/2812510268, and /wiki/spaces/DRWIP/pages/2812510392 Snaps to the Microsoft Dynamics 365 Finance and Supply Chain Management Snap Pack.

API Suite

432patches20818

  • Fixed an issue with the HTTP Client Snap that caused encoding of spaces in the query portion of a URL with a plus sign (+) instead of percent-encoding (%). This fix changes the default behavior to percent-encoding through the Use form encoding for spaces checkbox, which is deselected by default. Select this checkbox to enable the Snap to encode any space characters in query parameters using the plus sign (+).

  • Updated the HTTP Client Snap to stop sending unnecessary headers in GET requests that do not have a defined entity.

SAP Concur

main128

Introduced the SAP Concur Snap Pack. This Snap Pack contains the following Snaps and Account:

Marketo

432patches20585

The Marketo Bulk Extract Snap works successfully in the non-lineage path in an Ultra task.

Redshift

432patches20500

The Redshift Account no longer encounters a failure when a URL is entered in the JDBC URL field without specifying a driver.

Copybook

develop124

Improved the performance of the COBOL Copybook Parser Snap when parsing large COBOL copybook files.

Transform

432patches20535

Fixed an issue with the Encrypt Field Snap, where the Snap failed to support an RSA public key to encrypt a message or field. Now the Snap supports the RSA public key to encrypt a message or field.

Exchange Online

432patches20437

Fixed an issue with the Microsoft Exchange Online OAuth2 User and Exchange Online OAuth2 Application accounts that caused 401 unauthorized errors when updating the access tokens.

SOAP

432patches20553

  • Fixed the storage issue with the JCC output file caused by the cyclic import of WSDL warning logs by SOAP Snaps.

  • The performance of the SOAP Execute Snap has been enhanced by reducing the need for multiple WSDL downloads and parsing to obtain the same Description.

Binary

432patches20458

Fixed an issue where the ZipFile Read and ZipFIle Write Snaps failed to display the input schema for the File or File name field when using an expression.

...

  • The Amazon SNS Account supports publishing messages larger than 256 KB using the Enable large message support checkbox. When you select this checkbox, the Snap displays S3-related properties enabling you to read from and publish messages in the Amazon S3 bucket. (432patches20327)

  • The Azure Synapse SQL Account and Azure Synapse SQL Active Directory Account now support the latest JDBC Driver 12.2.0.jre11 by default. You do not have to manually upload the JAR file in the JDBC Driver field. (432patches20389)

  • The Hive Snap Pack is certified with the Cloudera Data Platform (CDP - Public Cloud 7.2.x).

  • The Join Snap is enhanced with the following (432patches20446):

    • The Pipeline Execution Statistics of the Join Snap now has a status message that displays the parameters - Free disk space, Available memory, and Average document size.

    • The internal sort buffer size is reduced to a minimum of 10 MB when the available memory in the node becomes lower than 500 MB to avoid the out-of-memory crash.

    • The internal sort buffer size is restored to its original size when the available memory becomes larger than 2 GB.

    • Error handling has been improved for the out of disk space on node error to make it more user-friendly. The error message now provides more clarity in terms of the type of error, the reason, and the resolution. The updated error message now provides clear guidance for users, as shown below:
      Reason: Insufficient free disk space available to stage sort data into temporary files.
      Resolution:  Increase the amount of free disk space and try again.

  • The Display null or empty values as null checkbox in the following Salesforce Snaps enable you to control the display of empty strings and null data as null in the output preview (432patches20393):

  • Sort Snap: (432patches20250)

    • The Maximum memory unit dropdown list in this Snap now enables you to better manage the memory in the Snap.

    • You can choose a unit, percentage (%), or MBfrom the dropdown list for better memory control.

    • The Maximum memory % field is revised to Maximum memory.

...