In this article
Platform:
API Management:
Support for creating APIs from Swagger 2.0 specifications
ELT for Cloud Data Platforms:
Support for Snowflake that is hosted on Azure or Google Cloud Platform (GCP)
Support for ELT operations on data from Google Cloud Storage into Snowflake
New Snaps:
Twilio Snap Pack
|
Date of Update | Snaplex Build | Updates |
---|---|---|
main-9988 - 4.25 Patch 3 (Recommended) |
| |
N/A | Control Plane update:
| |
main-9825 - 4.25 Patch 2 (Restricted) | This is a restricted Snaplex build. For more information, contact support@snaplogic.com. | |
main-9727 - Patch 1 |
| |
N/A | Control Plane update:
|
Date of Update | Update |
---|---|
| |
|
|
|
|
The Snaplex-based Scheduler will be the default scheduling mechanism for all Scheduled Tasks in the 4.26 release (August 2021). The new scheduling mechanism improves the timeliness and reliability of Scheduled Task executions, and we recommend that you enable the Snaplex-based Scheduler on your Orgs. |
duplicate_flag
parameter being disabled.Retired the legacy UI: The legacy UI for Snaps is retired. Starting in the 4.25 release (May 2021), the option to deselect the New Form UI in the User Settings dialog window is no longer available. All Snaps can be viewed only in the new UI.
Write S3 objects with Access Control List (ACL) details in a single API call.
Behavior Change In the 4.23 release, the S3 File Writer Snap used to write an S3 file and then set ACL if the ACL property was not empty. If the file write was successful and the ACL setting failed, both the output document in the output view and the error document in the error view was displayed. This issue has been resolved in the 4.24 release by enabling the Snap to configure ACL while writing the file. Therefore, the Snap produces an error document in the error view if the ACL configuration fails, irrespective of whether the file write action passes or fails. |
Enhanced the output view of the Box Directory Browser Snap to display the error message, Error retrieving contents of the folder with id:<Folder ID>
instead of No folder exists with <Folder ID>
when you enter an invalid folder ID.
Enhanced the pass-through behavior in Bulk API mode for Salesforce Write Snaps to include the input document in the original
key when the batch size is set to 1. When the batch size is greater than 1, the input document is not included in the original
key. This enhancement impacts the following Snaps:
Transform Snap Pack: Enhanced the Group By N Snap with the following settings:
The Generic JDBC - Insert Snap in the JDBC Snap Pack might fail due to a connection issue. We recommend that you roll back to the main8614 version.
The Avro Parser Snap in the Transform Snap Pack might fail due to ClassCastException
error. We recommend that you upgrade to the 425patches9815 version.
SnapLogic's data automation solution speeds up the identification and integration of new data sources, and the migration of data from legacy systems. The solution can automatically detect duplicate, erroneous, or missing data, and identify structures and formats that do not match the data model. Data automation can accelerate the loading and transformation of your data into the data warehouse, speeding up the data-to-decisions process.
ELT Snaps automatically use a corresponding JDBC JAR file to connect to your target database and to perform the load and transform operations.
Database | Certified JDBC JAR File |
---|---|
Azure Synapse | mssql-jdbc-9.2.1.jre8.jar |
Redshift | redshift-jdbc42-2.0.0.2.jar |
Snowflake | snowflake-jdbc-3.13.1.jar |
Though we recommend you to use the above JAR file versions, you can choose to use a different version, based on your environment. |
For Redshift and Azure Synapse databases, the ELT Load Snap displays JSON values for fields with datatypes Date and Time when validating the Pipeline.
Snowflake | Redshift | Azure Synapse |
---|---|---|
”time_data” : “09:23:56”, | ”time_data” : {“time”: “09:23:56”}, | ”time_data” : {“time”: “09:23:56”}, |
”date_data” : “2020-12-20”, | ”date_data” : “2020-12-20”, | ”date_data” : {“date”: “2020-12-20”}, |
However, the ELT Load Snap outputs the correct date and time values when executing the Pipeline.
To prevent these values from showing up in JSON format in the previews and ELT Transform Snap, you can cast the time or date values to a VARCHAR type in your custom query as follows: |
ELT Transform Snap displays incorrect data types (string instead of the actual data type) for column names populated in its Input schema section.
Ideal for business/data analysts, FDL is a data ingestion tool that simplifies the tasks of replicating and synchronizing data from the following source endpoints:
Weather (pre-configured endpoint)
Covid (pre-configured endpoint)
You can integrate your data source with the following destination data warehouses:
To gain your complimentary access to FDL, sign-up on the registration page. For more information, see the FDL user guide. For support questions, contact fdl-support@snaplogic.com.