Designing and Running Pipelines

Using expression libraries in JSON Generator

Hello, I need to generate a JSON with a bunch of dynamic keys, which are stored in an expression library. I haven’t found a well rounded solution so far, except pushing it all together in a single mapper field, however i was hoping to find something ...

How it do insertion faster for redshift

I am trying insert 70K records in loop till a condition is false. Looping logic working fine. But, I see it takes 1 hour to insert 70K records each time. PFA of the pipeline I am executing. Is there a way to perform insertion faster? Any tips would b...

Date formatting

Hi , I am trying to convert a local-date-time format to dd-MMM-yy ( say for eg :13-NOV-19). I tried various methods still could not achieve this . It could be useful if I have a method to achieve this Thanks in advance

Resolved! Time difference calculation excluding weekends

Does anyone have a pattern available to determine difference between two timestamps and add the duration to another timestamp, both of which calculations would exclude weekends? For example, three inputs and one output: Baseline start timestampBaseli...

How to use proxy to setup a sftp connection

file writer snap provides function of sftp, but I don’t see it supports proxy(socks5) in-between? Another way I can think of is to use the script snap and python script to connect, but not sure how to do it? Could anyone give some hint? either an alt...

Can I use Dynamic SQL in SnapLogic?

I have a DYNAMIC SQL that I run in SQL Server Query and it runs fine. I am having trouble running the same SQL in the SQL Server - Execute snap. Can someone guide me on what I might need to do to get dynamic SQL running in SnapLogic. This is the mes...

Rerun a task manually

Is there an easy way to rerun a task? I usually update the schedule on the task to run it and revert the schedule to its original value once the task kicks off.

Error pipelines

Hello, I am looking some tips and looking for sample error pipelines. Thank you in advance. //Harish

SnapLogic - Integration Nation

Forum Posts

Using expression libraries in JSON Generator

How it do insertion faster for redshift

Date formatting

Resolved! Time difference calculation excluding weekends

How to use proxy to setup a sftp connection

Can I use Dynamic SQL in SnapLogic?

Rerun a task manually

Error pipelines

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