This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Adding system datetime when insert data into Redshift

yes1819
New Contributor III

a month ago

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

 

0 Kudos
1 REPLY 1

anilkumar
Employee
Employee

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

0 Kudos