Adding system datetime when insert data into Redshift

Question

Hi,I've added mapper expression to add system datetime when I insert data to Redshift table.It ran ok, but the problem is, it inserted different time for each rows.How can I get date and time that only shows only one same date and time (either pipeline execution start time or end time) so that all rows those are being inserted at the same time will have the same date and timestamped?&nbsp;

anilkumar · Answer

Hi,Can you try replace Date.now() with pipe.startTime function in your expression and verify the Mapper output results once (Please disable the DB snap and verify in the Mapper output) .Hope this will help you. pipe.startTime will give you the start time of the Pipeline.

Forum Discussion

Adding system datetime when insert data into Redshift

Recent Discussions

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?

Multipart Reader failure - 'content-type' was not found