Designing and Running Pipelines

Stored procedure versus multiple sql execute snaps

I have a SQLServer stored procedure snap with mostly SELECTs from several tables (not in an ultra pipeline). If I break up the stored procedure and substitute the SQLServer stored procedure snap with a series of sequential SQL execute and mapper comb...

Rerun Pipeline until success

Hi guys, Would you know if it is possible, in case of scheduled pipeline run failure, to rerun it until it’s successful? A Kind of retry until completes successful. Thanks,

Pipeline Parameter being last run's date

Hi everyone, There is another interesting case I need to work on. Is there a way to schedule a run of a pipeline passing it, as parameter (to be used inside the new run) the last successful run date? In pseudo algorithm, this would be: Oracle Data Se...

All Python Function is not working in Script task

I have perfectly executed python code in my computer. However, same code does not execute in Script task. For instance, I used parse() function to format datetime. parse(“2017-08-27T00:00:00.000”).date() works in my computer, but not in script task....

Using Azure Storage/Azure Blob Storage

I am trying to create an Azure Blob Reader but I keep encountering this error: Error: Directory not found or access denied: wasb:///storage@janoswsl.blob.core.windows.net/; Reason: com.snaplogic.snaps.hadoop.BinaryAzureAccount cannot be cast to com....

Proper syntax for file reader snap - network file

Hi, I am on a windows box. I have a network file, file://fs01-hou/Common/RDMetric/CARType.xls, that I can access from Chrome. However, I can’t seem to get the correct syntax for the file reader snap Any help is highly appreciated Daisy

Subpipeline - Lookup

We have a requirement to do a lookup on a db table and get additional attributes. This lookup is being done in a sub-pipeline. We would ideally like to load the lookup data into memory and do an in-memory lookup instead of querying the database for e...

Identity column value after merge or insert in SQL Server

Is there a way to get the identity column value from SQL Server after a merge or insert without doing a select again?

SnapLogic - Integration Nation

Forum Posts

Stored procedure versus multiple sql execute snaps

Rerun Pipeline until success

Pipeline Parameter being last run's date

All Python Function is not working in Script task

Using Azure Storage/Azure Blob Storage

Proper syntax for file reader snap - network file

Subpipeline - Lookup

Identity column value after merge or insert in SQL Server

Change all Keys in JSON structure to lowercase

How to read .xlsb file

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file

Data Validator Pattern error