Designing and Running Pipelines

Writing multiple data in a single excel file sheet

Hi, Good day, I have got a requirement to append the data in an excel as the incoming data is coming from various sources. Since the append operation is not allowed, I would like to know if is there any way of loading the data in different sheet name...

Asset updated at date (pipelines and tasks)

Is there a way to see when a task or pipeline was last updated? I can see when it was created, who created it, and who updated it, but not when it was last updated. This information would be useful for troubleshooting pipeline failures to see if ther...

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

SnapLogic - Integration Nation

Forum Posts

Writing multiple data in a single excel file sheet

Asset updated at date (pipelines and tasks)

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

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