Designing and Running Pipelines

Script Snap Data Structures

Hello, I have written a script to create a JSON object with counters of a parameterized length, with the desired structure like this: [ { “counter”: 1 }, { “counter”: 2 }, { “counter”: 3 }, … ] However, when I do this through a loop in a script sna...

Issue in parsing the date format using JSON parser

I have a simple pipeline as below, The file contents are, { "Time": { "_snaptype_localdatetime": "2017-12-12T10:51:12.013" }, "BP_number": 2 } When I use json parser and convert the time to string I get below output, When using...

Json File generation from Redshift Table

Hi All, I am working on generating a JSON file from a Redshift table in the below desired format Required Output: { “data”: [ { “classification_code”: “ARGENTINA”, “reporting_country”: “Argentina”, “sub_region”: “Rest of Latin America”, “territory”: ...

Setting up Kerberos on SnapLogic groundplex for authentication to Cloudera - Hive account and snap pack

I’m looking for information on how to set up Kerberos on the SnapLogic groundplex for authentication to Cloudera. I want to use Hive account and snap pack. I see this documentation: https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/2015960/Ho...

Pipeline failure when input json file has 0 records

One of my pipeline is failing when the input json file has 0 records. Are there any options to make the pipeline not fail when the input file has 0 records? Thanks.

S3 File as Email Attachment

Hello, As part of an error handling pipeline, I am attempting to write a detailed error file to an S3 bucket, and then attach that file to the email notification at the end of the error pipeline to alert users of the issue. I was able to do this succ...

Format to XML in an Ultra Pipeline?

Has anyone been able to format multiple input fields into XML in a pipeline that will be executed via an Ultra task? I attached a screenshot of my pipeline. In the highlighted XML Format snap, if I clear the Root Element field (as required by the in...

Resolved! Transforming denormalized data to a single message

I have CSV similar to: Id,FName,Lname,street,city,state 15,Mary,Smith,123 Main,Anytown,NY 15,Mary,Smith,456 Elm,Sometown,PA 22,Joe,Know,123 4th,BigTown,NJ 22,Joe,Know,456 Shade,NoTown,VA There can be any number of the id’s which means that any person...

SnapLogic - Integration Nation

Forum Posts

Script Snap Data Structures

Issue in parsing the date format using JSON parser

Json File generation from Redshift Table

Setting up Kerberos on SnapLogic groundplex for authentication to Cloudera - Hive account and snap pack

Pipeline failure when input json file has 0 records

S3 File as Email Attachment

Format to XML in an Ultra Pipeline?

Resolved! Transforming denormalized data to a single message

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

Best Approach for Handling CSV Import with Truncat...

Fetch dashboard/monitor details via a pipeline

mapValues returns null when adding certain conditi...