Adding system datetime when insert data into Redshift

[yes1819]

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?

[anilkumar]

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.