Designing and Running Pipelines

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

Reading the Merged CSV Header and Data

Is there any way to read the merged column header and its corresponding data? Please refer to the screenshot below. Do we need to unmerge the column header to read the headers? If we unmerge how to merge back to normal using the snap without directl...

SnapLogic - Integration Nation

Forum Posts

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

Reading the Merged CSV Header and Data

Help to parse Json data into csv

Updating Salesforce contact object and Account Loo...

Slicing Data from JSON

Connecting Confluent Kafka using OAuth

Hexadecimal to binary conversion

array.map if field1 meets criteria, I want field2

Filter Array data

How to create timestamps and out put them only usi...

Do JSON mapping in a single mapper

Problem with nested mappings