In this article

We updated the SnapLogic platform with the following features and enhancements at 4 p.m. PT on 09 Jun 2022. If you have any questions, email support@snaplogic.com.

Reviewers: note that the links go to the live docs, but the updates for the new and deprecated features will not go live until Wednesday June 8

SnapLogic Studio (Preview)

New Features

• Studio displays informational, operational, and alert notifications.

• The Studio Execution Overview displays a Completed with Errors card with a sum of all Pipeline executions that generated an error document.

• You can resize columns on the Execution Overview page.

Platform

New Features

• The new Public API for deleting Projects and Project Spaces is available. Learn more.

Enhancements

• Org admins can restore or permanently delete Project Spaces and Projects from the Recycle Bin.

• The Create User dialog features a redesign simplifying the workflow.

• Users with the write permission can move, copy, or delete Flows from a Project.

• Flows are included in an Asset Search. <add link when new page is live>

Deprecation

The eXtremeplex is no longer available as a Snaplex type.

Known Issue

In Manager, when you navigate to the Recycle Bin and refresh the page, a Datatables warning pop-up error message is displayed. Click OK to continue.

Data Automation

ELT Snaps

New Features

• The ELT Snap Pack supports the latest JDBC drivers across CDWs—Azure Synapse, BigQuery, DLP, Redshift, and Snowflake. See Configuring ELT Database Accounts or the respective Account page for the exact versions.

• The end Snap SQL query in the ELT Insert Select Snap’s preview output now displays the appropriate CREATE TABLE... or the DELETE/DROP TABLE statements to be run before the query that inserts/loads data into a new table in the Snowflake target CDW.

• The Value List field in the ELT Pivot Snap displays a dynamic list of suggestions to select from.

• The ELT SCD2 Snap:

  • Allows replacing an existing target table with a new table and loading the SCD2 entries into it from the source table/files. Use the new Overwrite existing table option in the Target Table action field to perform this action.

  • Displays the final SQL query in its output preview upon Pipeline validation.

Fixed Issues

• Field names in ELT Aggregate, ELT Cast Function, ELT String Function, and ELT Transform Snaps are normalized.

• The ELT Insert Select, ELT Merge Into, ELT Load, and the ELT SCD2 Snaps now run successfully even when the specified target table does not exist. The Snaps now create a new target table if it does not exist during Pipeline validation.

• The ELT Load Snap does not cause:

  • Any null values in new columns added to the target table through the Alter table Load Action.

  • The SQL exception—[Simba][SparkJDBCDriver](500051) ERROR processing query/statement when reading from a CSV file in S3 mount point on DBFS in the case of a DLP target instance.

FDL

New Features

Added AWS S3 account as a source endpoint in Fast Data Loader (FDL). Amazon Simple Storage Service (Amazon S3) is an object storage service. Customers can store and protect their data for any use case, such as data lakes, cloud-native applications, and mobile apps.

Flows

New Features

• Introduced the Triggered Event - Webhook as a source endpoint that automatically generates an external URL which you can use to configure your external event.

• Added Webhook support for the Google Sheets endpoint to set up an external event with your Google Sheets account. A notification will be sent to Flows when the event occurs.

Enhancements

• Moving, Copying, Exporting and Deleting Flows: You can now move, copy, export and delete a Flows from the PROJECTS tab in Flows.

• Exporting Projects in Flows: You can now export a Project from the PROJECTS tab in Flows.

• Using Auto-Link in Data Wrangler: While mapping data via the Data Wrangler, the Auto-link can now automatically map the fields in the target endpoint by using the input and output schema.

• Searching Flows via Asset Search: You can now search, sort and filter Flows via the Manager > Asset Search in IIP.

Fixed Issue

Earlier while setting up a Flows, clicking the back button on the browser used to redirect the user to the Home page instead of the Select a Source/Target Snap. Now, while setting up a Flows, clicking the back button will redirect the user to the Select a Source/Target Endpoint page.