Key New Features

AutoSync:

• Google BigQuery as a destination endpoint.

• CSV File Reader as a source endpoint.

• The integration starts within 10 seconds as soon as you click Save and Load.

• From the dashboard, initiate an ad hoc load by clicking Run now in the integration card.

AutoPrep:

• Rename fields, format Date strings, and mask sensitive data.

API Management:

• Copy and Move Assets from one API Version to another.

• Import/Export API policies at the Version level.

• Change the Host server (Snaplex) of your API Version before publishing and republishing it to the Developer Portal.

Snaps:

• Introduced the API Suite Snap Pack, which contains the HTTP Client Snap.

• Introduced the Google AlloyDB Snap Pack, which is a fully managed PostgresSQL-compatible database service that you can use for all your database workloads.

Studio:

• Metric charts are available from the node details panel.

• Search supports filtering by Project Space and by Project.

Platform and IIP:

• APIs for retrieving and adding branches to GitHub.

• From the UI, create a new GitHub branch.

Dot Releases

Platform

Snaps

SnapLogic AutoSync

AutoSync provides a no-code, point-and-click interface for loading data into a cloud data warehouse. The October release includes the following new and changed functionality:

• Bulk load to a Google BigQuery destination:

  Open

  

• Use CSV files as sources:

  Open

  

• In the dashboard, the run now button starts an ad hoc load. The new button is shown in the following screenshot:

Enhancements

New load options are available for some sources. Refer to Supported Load Methods for the complete list.

Change of Behavior

When you click Save and Load for a new integration, it starts running in 10 seconds instead of 5 minutes, as in the previous release.

SnapLogic AutoPrep

New transformation options include:

• Changing the field data type. (Previously this action was only available from the Select fields menu. Now you can change the type from both places.)

• Formatting Dates and Date Strings. Selecting one of the available formats transforms the field into a Data String.

• Renaming a field.

• Masking sensitive data using an MD5, SHA-1, SHA-256, or SHA-512 algorithm.

In the Preview data pane, click the three dots in the column header to open the transformation options menu:

Refer to the video below for a demonstration of date formatting transformation:

Enhancements

The data in the Preview data pane format is easier to read and the buttons have been changed to improve usability:

Learn more about using AutoPrep.

SnapLogic API Management

Features

• Copy Assets from one API Version to another. You can now create new versions of your APIs by copying existing Pipeline, Task, and Account Assets:

• Import and Export API Policies in an API, Proxy, or Version:

Enhancements

• Change Snaplexes before publishing and republishing API Versions on the Developer Portal.

• Open the Task dialog to change a Snaplex if it is in an Unpublished API Version.

• Filter by Type. You can now browse through API Versions in the Portal Manager by Type: API or Proxy.

• As the logged-in user, your email appears by default in the Email ID of the Publish API Version dialog. You can change the email.

• View Developer Portal UX improvements, including a high-contrast color scheme and optimized dimensions for UX buttons and labels.

Fixed Issues

• Subscription counts for applications in the Subscription Manager are reflected accurately.

Change of Behavior

• Public APIs cannot be used with API Assets in API Manager.

• Snap Packs and Directories cannot be moved or copied from one API Version to another.

• Published and Deprecated APIs cannot be deleted when they are on the Developer Portal. You can Retire the API Version, which removes it from the Developer Portal, delete all the Version Assets, then delete the Version from API Manager.

SnapLogic Studio (Preview)

This release provides a new Metrics tab, search enhancements, and a change in the way to navigate to AutoSync.

Metrics Tab in Node Details

Node details now include a Metrics tab that displays charts of key metrics. To open node details:

1. From the left navigation pane in Studio, click Analyze > Infrastructure.

2. From the System overview, click a node to open its details.

3. Select the Metrics tab:

Search Enhancements

Search terms and filters are now preserved when you navigate to a different Studio page if that type of search is valid for the new page. On screens that display Project Assets, you can filter by Project Space and by Project:

Select a Project Space:

Expand a Project Space to select a Project:

UI Navigation Change

To open AutoSync from Studio:

1. Click the arrow next to your avatar and select Return to existing interface:

2. On the Designer tab, click the arrow and select AutoSync:

New Patterns in Studio

• Batch Sync New Leads From Marketo to Amazon Redshift

• Call a Command Line Utility on the Snaplex Node

• Changing Case of Attributes

• Check Failed Pipelines Details

• Create NetSuite Expense Report

• Create Record in AWS Redshift for New CSV in Box

• Create Users in ServiceNow from Salesforce Contacts

• Determine Changes Between Two Data Files

• Dropbox Samples via REST API

• Dynamic Field Extension

• Enable or Disable a Task

• Encrypt and Decrypt Sensitive Data in a Source

• Excel to SQL Server after Clearing the Lookup Table

• Export Accounts from Adaptive Insights

• Look up Addresses From Multiple Databases

• Move Salesforce Opportunity to NetSuite Sales Order

• MQTT to Azure Data Lake

• NetSuite Case to ServiceNow Incident

• Oracle to XML File

• Sync Excel to Marketo

• Sync New or Updated Leads From Microsoft Dynamics CRM to Marketo

Learn more about the Patterns available in Studio.

Known Issues

When Pipelines extend horizontally or vertically beyond the edge of the Designer canvas, the scrollbars might disappear or not allow you to scroll to view all of the Snaps.

As a workaround, try the following:

• Select to zoom to fit

• Zoom out completely

• If more than one Pipeline is open, toggle between Pipeline tabs

SnapLogic Snaps

New Snaps

• API Suite: Introduced the API Suite Snap Pack, which contains the HTTP Client Snap. This Snap unifies all HTTP-supported methods: GET, HEAD, POST, PUT, DELETE, OPTIONS, TRACE, and PATCH that you can execute on a REST API service endpoint (Snap Pack version: 430patches18454, both Latest and Stable).

• Google AlloyDB: Introduced the Google AlloyDB Snap Pack— a fully managed PostgresSQL-compatible database service that you can use for all your database workloads. This Snap Pack contains the following Snaps:

  • AlloyDB Bulk Load: Enables you to load data in bulk into the AlloyDB tables.

  • AlloyDB Delete: Enables you to execute a SQL DELETE.

  • AlloyDB Execute: Enables you to execute an arbitrary SQL.

  • AlloyDB Insert: Enables you to execute an SQL INSERTusing the document's keys.

  • AlloyDB Lookup: Enables you to look up records in the target AlloyDB table and return a selected set of fields for every matched record.

  • AlloyDB Select: Enables you to fetch data from the AlloyDB database by providing a table name and configuring the connection.

  • AlloyDB Table List: Enables you to connect to the database, read its metadata, and output a list for each table.

  • AlloyDB Update: Enables you to execute an AlloyDB UPDATE. 

Enhancements

• The Snowflake - Bulk Load Snap now has a Validation Errors Type dynamic field, which provides options for displaying the validation errors. You can now choose Aggregate errors per row to display a summary view of errors (Snap Pack version: 430patches18432, Latest).

Known Issues

• The HTTP Client Snap fails with the Name may not be null error when the Key-Value pair values are empty for x-www-form-urlencoded Entity Type.

• The AWS Sig V4 Account of the HTTP Client Snap does not support the Virtual Private Cloud (VPC).

Fixed Issues

• The Metadata Delete Snap deletes Projects from an Org. Previously, Delete operations resulted in the following error message: "Only assets in Org recycle bin can be deleted permanently" 400 Error code.

• The CSV Parser Snap now parses data with empty values in the columns when using a multi-character delimiter.

Platform and IIP

Features

New Git-related Public APIs are available:

• Create a Git Branch

• Add a Git Tag

• Retrieve Git Tags

Enhancements

• Pipeline owners can now access the Execution Statistics of a child Pipeline, even if they do not have read access to the parent Pipeline.

• Create a branch during checkout from the IIP in Manager:

1. From the Project options menu, choose Checkout GitHub Repository:

2. Select a repository and a branch, the new branch will be created from the selected branch.

3. In the Branches/Tags field, enter a new name:

4. Click Checkout.

Documentation Updates

• An AutoPrep example with sample data demonstrates how to transform data without writing expressions.