cancel
Showing results for 
Search instead for 
Did you mean: 

Adding system datetime when insert data into Redshift

yes1819
New Contributor III

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?

yes1819_1-1716574987172.png

yes1819_0-1716574957662.png

 

1 REPLY 1

anilkumar
Employee
Employee

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.