Designing and Running Pipelines

Directory Browser vs File Poller snap

Hi, I am new to Snaplogic. I would like to read all the files in a specific directory at specific intervals. I am evaluating two options. Would like to know the pros and cons of each. Option 1: Directory Browser snap with Task Option 2: File Poller s...

Snowflake execute (select SQL)- Capture results

Hi, We are using Snowflake execute snap to run a metadata query against Snowflake and using the output of it in mapper snap. Snowflake execute snap- preview data shows expected data from sql. In the mapper snap, input schema is not available for snow...

How to use join snap to get NOT a match data

I’m using join snap to with a condition NOT, surprisingly the validation is giving me output, but when i’m running the pipeline it is giving me an error, Can someone please help me understand what i’m doing wrong ERROR message: Not comparable object...

Parent pipeline executing different child pipelines based on condition

Hi, I have an existing parent pipeline that calls a child pipeline. I have to add another call to another child pipeline. I have to update the parent pipeline so it can call any of the two different child pipelines based on conditions. I tried to use...

How to truncate data with BigQuery Snaps

How do I truncate date from a BigQuery Table using the BigQuery Snaps?

Is there Upsert Capability for BigQuery

Hi, Is there Upsert capability for any of the biqquery snaps?

Resolved! Create statements based on the count

HI , We have a requirement where , we hit api and get the count. Based on the count we need to create some sql statements. for example if count is 500 we to create a statements like below select * from table where columcount between 100 and 200 selec...

Writing flat file

Hi Team For my current use case, I need to write a flat-file. I am using the following pipeline to write csv. Input to JSON formatter is a document of arrays each having different no of properties. Can you please suggest a way to generate CSV file...

SnapLogic - Integration Nation

Forum Posts

Directory Browser vs File Poller snap

Snowflake execute (select SQL)- Capture results

How to use join snap to get NOT a match data

Parent pipeline executing different child pipelines based on condition

How to truncate data with BigQuery Snaps

Is there Upsert Capability for BigQuery

Resolved! Create statements based on the count

Writing flat file

What account should be used for API with query par...

How to dynamically update an account?

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