When you schedule a job to run, is there a way to append a column that contains the run date?

[Trifacta_Alumni · Accepted solution]

Hi Jenna!

You can apply a New formula [derive] and use the NOW( ) function (https://docs.trifacta.com/display/PE/NOW+Function) or the TODAY( ) function (https://docs.trifacta.com/display/PE/TODAY+Function). This will return a new column with the result of the function you chose at the moment the job is triggered by the schedule.

The difference between the two is that:

• TODAY( ) will return today's date at the time of job run.
• NOW( ) will return the date and timestamp at the time of job run.

Both functions accept an optional timezone parameter to specify the region of interest. You can see a full list of the supported timezones here (https://docs.trifacta.com/display/PE/Supported+Time+Zone+Values).

[Conner_Tri]

Awesome. I saw those functions but wasn't sure if their results would update every time the job ran. Glad to know that is the behavior.

[Trifacta_Alumni]

Here are the current doc links:

https://docs.trifacta.com/display/SS/NOW+Function

https://docs.trifacta.com/display/SS/TODAY+Function

https://docs.trifacta.com/display/SS/Supported+Time+Zone+Values