Designing and Running Pipelines

Fixed Width Formatter Generate Blank file

Hi, I am using fixed width formatter in my pipeline and If I don’t have any data in the source and fixed formatter generates one output and create a blank file. Do we have any other functionality similar to ignore empty stream.

Resolved! RPE only returns small proportion of documents

I have a RPE running with the snaplogic recommended data science docker image. When i pass documents to the remote python script (hundreds, sometimes thousands) I only get around 1% of the documents back from the snap. Even when i literally pass the ...

Resolved! Convert data from SQL select to JSON

What is the best way to take data from a SQL Select statement and convert to JSON so that it can be used in a API put commend?

Passing a custom sql server data type into a stored procedure

Given the below sql server procedure definition excerpt. How would we pass in an array of data into this this datatype as the input parameter of the stored procedure. when passing in a straight array of values we get the following error. “reason”: “E...

Error message on snowflake bulkload

I am trying to migrate the data from MySQL to Snowflake DB. I am getting th following error message with snowflake bulk load snap. I have entered the data for all the columns but still getting the same error. “reason”: “The·input·to·the·SF·Bulk·Load...

How to load Today Date Files from s3 Bucket to SLDB

Hi, I am getting the files from amazon s3 bucket every day, I want to load today date files from s3 bucket to SLDB.Any one can help me on that. Thanking you in advance. Thanks M SATHISH

Resolved! Routing files from S3

Continuing the discussion from How to load Today Date Files from s3 Bucket to SLDB:

Resolved! Consolidate Header file and Data file

Hi Team, I’m having 2 separate excel files; one containing the headers ONLY and the other one having the actual data. How can I MERGE these 2 files into a single entity so that further transformations can be applied and eventually sent to downstream ...

SnapLogic - Integration Nation

Forum Posts

Fixed Width Formatter Generate Blank file

Resolved! RPE only returns small proportion of documents

Resolved! Convert data from SQL select to JSON

Passing a custom sql server data type into a stored procedure

Error message on snowflake bulkload

How to load Today Date Files from s3 Bucket to SLDB

Resolved! Routing files from S3

Resolved! Consolidate Header file and Data 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

Deleting multiple files at once from SFTP folder

SQS -pipeline stalling