Forum Discussion

yes1819's avatar
yes1819
New Contributor III
2 years ago

Adding system datetime when insert data into Redshift

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?

 

1 Reply

  • anilkumar's avatar
    anilkumar
    Employee
    2 years ago

    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.