Designing and Running Pipelines

SCD2 implemmetation in snaplogic using azure snappacks

I have a database table in azure sql and I am getting daily data from a dataset,then I have to compare dataset record with database table records and 1 : Insert the records that are present in dataset but not in database into database in sql 2 Apply...

I want to insert brand new records and update the already exits records using azure snappacks how I can do in snaplogic

I want to insert brand new records and update the already exits records using azure snappacks how I can do in snaplogic. In short I want to implement SCD2 in snaplogic using azure snappacks.

Resolved! Add incoming document to new file row

We want the ability to write a document to a new row within a CSV file. This is only if the document meets certain requirements Is this possible? This article from a few years back suggests not and wondered if there has been any advancements

How are pipeline executions distributed across a Snaplex?

When a request to run a pipeline is submitted against a Snaplex,the Control Plane must decide which member node to send the request to. In making that decision,the Control Plane assumes that each node in a Snaplex is homogenous in terms of both hardw...

Strange issue - data and email results the same but email doesn't come on execute, only on preview

To keep things simple, Email snap is set with Validate & Execute so that it will fire on preview tests as well as execute. Data is simple, pulls 46 rows from a table, merges the count i.e. 46 and sends the results to an email. Email comes reliabilit...

Resolved! Router Snap Expression for checking Value

We have a Router Snap that evaluates a string and checks whether it matches one of a set of predefined values. I can’t seem to get the expressions right and think a short circuit evaluation is at play here? The logic is as follows If Status CONTAINS ...

Removing leading characters

I’m receiving data with 18 characters, which includes 7 leading 0s. Would I use the Mapper to TRIM off the leading 0s? If so how would I go about this? Thank you

How to loop thru a REST snap

Hello, I am trying to load transaction data from a REST API end point. The API has pagination as required Input parameter. I am using the REST GET to fetch the data and the Https URL should be as below. https://xxxxxx–xxx/transactions?datestart=2018-...

SnapLogic - Integration Nation

Forum Posts

SCD2 implemmetation in snaplogic using azure snappacks

I want to insert brand new records and update the already exits records using azure snappacks how I can do in snaplogic

Resolved! Add incoming document to new file row

How are pipeline executions distributed across a Snaplex?

Strange issue - data and email results the same but email doesn't come on execute, only on preview

Resolved! Router Snap Expression for checking Value

Removing leading characters

How to loop thru a REST snap

What account should be used for API with query par...

How to dynamically update an account?

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...