https://slingdata.io logo
Hi, In our ETLs the customer wants a
# sling-help
i
Hi, In our ETLs the customer wants a column of timestamp for all the tables target, sling has SLING_EXEC_ID_COLUMN . but that is a UUID . If I understand correctly SLING_LOADED_AT_COLUMN is the now() of each insert / update . is there a variable of the exec_id_timestamp ? the begin timestamp ? the end timestamp ? Thanks
f
hey @itamar s
SLING_LOADED_AT_COLUMN
is what you're looking for. It is now() yes, but only computed once (at the start), so all the rows have the same timestamp value for that execution. Also, you can use [transforms](https://docs.slingdata.io/concepts/replication/transforms) to do this too, in hooks the
execution.start_time
is available (see [here](https://docs.slingdata.io/concepts/hooks#nested-fields))
i
Thanks 🙂