Designing and Running Pipelines

Redshift Unload Directly to Parquet

Hi, Has anyone figured out a way to Unload data directly to parquet format from Redshift? The Redshift Unload snap does not have parquet format as an option (just delimited and fixed width files). I have tried to circumvent this by using a Redshift E...

Video: Extract Load Transform (ELT), August 2020

In this video, learn how you can push workloads to your favorite cloud data warehouse with the new ELT feature in the SnapLogic Intelligent Integration Platform.

Resolved! Remove json object conditionally

I have the following document with question responses. When the response is “-”, I would like to remove the question and answer text. Is there a way to do this in a mapper or conditional step? Before: [{ “Questions”: [ { “answerText”: “John”, “Que...

Resolved! Using the parsed Float value in string

I have double value coming from the source as a string. Source value: “NTGEW” : “3.400” I am using parseFloat() function to convert the string into double value. parseFloat($NTGEW) ===> 3.4 The parseFloat function is working as expected when it is th...

Extraction of binary objects (BLOB) like images and pdf from Oracle table

Does Oracle Select Snap fetch the BLOB data from a table as actual document/image? I would like to fetch those docs from database and store them in FTP location. Here, I’m looking for specific example of pipeline. I’ve not seen any special mention...

SoapExecute Workday Read Get Course Sections fails with error message 'Course_Section_Reference is required' when it actually exists in the request

I am attempting to get a web service response from workday, but hitting an error which does not make sense to me error: Course_Section_Reference’ is required, on internal element 'Course Section Request References There is no ‘Course Section Request...

Describe table_name is not working in oracle execute snap

Hi, I am trying to execute the sql query “describe table_name” but it is not working in oracle execute snap. Getting an error like " Filed to execute query. Reason: ORA-00900: invalid SQL statement , Resolution: Please check sql query" Any suggestio...

Issue: Mapper object array incorrect in to Workday Write output

We are building a boomerang integration, which gets values from workday, adds/changes some of the data, and resubmits the data back to workday. In the mapper, I want to grab an entire section and rewrite it back to the submit without changes. this...

SnapLogic - Integration Nation

Forum Posts

Redshift Unload Directly to Parquet

Video: Extract Load Transform (ELT), August 2020

Resolved! Remove json object conditionally

Resolved! Using the parsed Float value in string

Extraction of binary objects (BLOB) like images and pdf from Oracle table

SoapExecute Workday Read Get Course Sections fails with error message 'Course_Section_Reference is required' when it actually exists in the request

Describe table_name is not working in oracle execute snap

Issue: Mapper object array incorrect in to Workday Write output

Nest the document under another document

optional field on mapper

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