Hi ,I have a requirement to join the array1 with array2 in the same document and fetch one column from array 2 into array1 if condition matches. I can do it by splitting the arrays and join them back again. I would like to to know if i can do it in m...
Hi,I have a requirement where we need to read 50 tables from oracle and put the data to postgres. there is no transformation logic in between . But issue is while loading to target the column names are slightly changing. for an instance , src_table1{...
Hi All,I have data type at input as a date fuction and expected same at output. But in mapping I need to keep as blank for the dates are invalid like 0001-01-01 or dates older than 2008-01-01. When I am trying to make an expression in mapper its not ...
In this pipeline im taking 2 parameters and using them in a SQL select statement in the where clause. . I can have 1 of 3 out comes. I will return 1 result, 2 results or no results. Im using the aggregate snap to evaluate how many results are return...
Hi Community, Is there a possibility to have cross-snap transactions in snaplogic, where we manage the transactions manually (e.g. by manually issuing commit or rollback at the end of the transaction)? for a usecase, we’d need to run multiple inserts...
Hi Everyone, Is there an option to configure an existing Postgres snap to perform an upsert to a given table? I am building a pipeline to create a daily feed to a postgres database and would like to capture records that have been modified or created ...
Hello everyone,I'm having this weird issue where I use a JSON generator to create a payload for the following HTTP client snap, but apparently all the values resulting are NULL, which is weird because the output of the JSON looks fine.This is what I ...
Hi,Hope you're well! Need your assistance here..My pipeline reads from one table (source) and write into another one (target).I get an error as below 'Cannot insert a NULL value into column sales_id'. i have double checked and i don't have any Nulls ...
