Designing and Running Pipelines

Updating Databricks/Delta Lake tables in Standard Pipelines

Hi community, I was wondering if anyone has tried doing Inserts/Updates to Databricks/Delta Lake Table using the generic JDBC Snaps (or any other work around if you have it). Using the latest Databricks JDBC Driver, I was able to setup an account suc...

Pivot of table

Hello Experts, i’m trying to achieve pivot source data. but not working as expected. Attaching source file and expected result. Source.xlsx (10.4 KB) Any help will be help ful. Regards, Ajay Chawda

2nd object from json object array

Question: I have input JSON array [ {“name”:“AU”, “value”: 3}, {“name”:“US”, “value”: 1}, ] I want to have 2nd object i.e. {“name”:“US”, “value”: 1} please advise how to get it? Thanks, DK

Find max date

Hi, How can we find the max between dates? I’m trying to find the newly created date between the dates below. 2021-05-19T19:01:47.000+0000 2021-05-19T22:11:26.000+0000

How to pass Snap label to error pipeline

I am trying to pass Snap label to error pipeline using in-build expression snap.label. I am getting error. Is their a way to pass snap label from multiple parent pipelines to the same error pipeline? Kindly help to find a better approach with in-buil...

Resolved! Getting unwanted xml tag

Hi, I am getting unwanted tags in my output xml. such as How do I avoid it. My pipeline looks like below:-

How to raise custom error message or a snap

Hi, Can some one let me know “How to raise custom error message or a snap”. Thanks, DK

Create xml segment only if condition is met

Hi, I am trying to convert xm1 into xml2. In order to that I have used XML Parser, Mapper,XML Formatter. There is one logic, I need to create a segment only if value of a particular repeatable segment is either jsonPath($, “$Z_RDGD102.IDOC.DKA1[].PAR...

SnapLogic - Integration Nation

Forum Posts

Updating Databricks/Delta Lake tables in Standard Pipelines

Pivot of table

2nd object from json object array

Find max date

How to pass Snap label to error pipeline

Resolved! Getting unwanted xml tag

How to raise custom error message or a snap

Create xml segment only if condition is met

Execute each child pipeline multiple times

Routing files from S3

Clean duplicated lines in CSV datasource

How to get all values of a key from objects in a l...

The "Pipeline execute" is changing data types?

Remove XML duplicate key from JSON list in XML for...

Generating individual files based on 'n' records f...

Convert array with objects into object with key/va...

Converting a string to JSON doesn't work

Rest Post for Multipart form type content type wit...