Designing and Running Pipelines
Discuss how to use the SnapLogic platform.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! Changing the key names dynamically

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

sravan by New Contributor II
  • 2370 Views
  • 2 replies
  • 1 kudos

Date format issue.

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

sshaikh by New Contributor
  • 979 Views
  • 0 replies
  • 0 kudos

Transactions with sqlserver

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

Matthias by New Contributor III
  • 2402 Views
  • 3 replies
  • 1 kudos

Cannot insert a NULL value into column error

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

asl23_0-1699281513866.png asl23_1-1699281665188.png
asl23 by New Contributor
  • 1500 Views
  • 1 replies
  • 0 kudos

Resolved! Referencing an earlier Snap

Hello.I'm trying to pass a JSON as a pipeline parameter, and I've prefixed my pipeline with a Mapper Snap to "parse" the JSON and the output of the Mapper is a JSON object I can reference later in my pipeline. A sample of this JSON is such:{"extract"...

rriley99_1-1698947079487.png rriley99_4-1698947565998.png
rriley99 by New Contributor III
  • 2373 Views
  • 3 replies
  • 1 kudos