Designing and Running Pipelines

Snowflake Bulk insert just stuck, do not process any data

I have seen that sometimes my Kafka to snowflake bulk insert is just stuck it does not process anything, neither it fails at the “Snowflake Bulk Insert snap”, like if there is a snowflake outage for 5 min, it gets stuck even after outgate is over, in...

"Connection is closed" error with MSSQL service account

I’m running into a strange problem connecting a pipeline to one of my company’s MS SQL servers. My pipeline requires two service accounts as I’m connecting to servers on two different domains. I tested it using accounts linked to lower environments i...

Parameterizing Snowflake query in Snaplogic

I am trying to execute a Snowflake query to fetch some columns data in a table using Snowflake Execute snap. Select “id”, “user_name”, “user_location”, “user_email” from t_user where “user_location” = ‘Chennai’ order by “id”; Now in the above query I...

Resolved! Sum in a loop

Hi, I have an default value for field $sum=390 and 10 input records(count may increase/decrease). Requirement :Each row should get $sum=$sum+10. if 1st row having sum=400, 2nd sum=410… Please suggest.

Retrieve the details of executing pipelines in another pipeline as an input

The purpose is to create a logging pipeline that stores the info of executing pipeline in a file format. Logging pipeline shall receive the following as inputs Executing master pipeline name (required)Executing master pipeline Id (required )Execu...

Zip File Write

Hi Team, I am trying to write a zip file with data as CSV formatted with file name as exteact.zip. I was able to write it as zip file but when i extract it i see a file inside with input0. But I don’t want this input0 to be inside the zip instead i w...

Resolved! Map Json Structure

Currently we have json data like this : { “Test”: “1” “SerialNumbers”: { “SerialNo”: [ “123”, “456” ] } The desired output is like this: { “Test”: “1” “SerialNumbers”: [ {“SerialNo”: “123”}, {“SerialNo”: “456”} ] } Is there any function we could use ...

SIngle log file

I have a pipeline which updates records between systems. The pipeline runs on a schedule and some records are not getting updated. Hence I want to create a log file which is written to everytime the pipeline runs. The log file would hold the date/t...

SnapLogic - Integration Nation

Forum Posts

Snowflake Bulk insert just stuck, do not process any data

"Connection is closed" error with MSSQL service account

Parameterizing Snowflake query in Snaplogic

Resolved! Sum in a loop

Retrieve the details of executing pipelines in another pipeline as an input

Zip File Write

Resolved! Map Json Structure

SIngle log file

Trim and convert string into Date

How to output the SQL statement that was executed ...

How to identify if there are no files in the sourc...

Decode column name that has @ as a prefix

Cannot call parameter in the error pipeline

Formatting CSV data for XML output

Get MIN (oldest) or MAX (most recent) date from ar...

Line Break in Mapper

how to filter out spaces

Expression to extract values in nested JSON object...