timemillis

Resolved as the current Unix timestamp in milliseconds in load execution.

See also:

• load_start_timemillis

• Variables

Usage

<timemillis>

Notes

Supported in all loads.

Examples

Insert millisecond timestamp into target table with OVERRIDE

OVERRIDE load step in an example entity load:

insert into <target_schema>.<target_entity_name>
select
    ... ,
    '<timemillis>' as unix_time_in_milliseconds, 
    ...
;

Load executed in the target database:

insert into publish.D_EXAMPLE
select
    ... ,
    1729599161159 as unix_time_in_milliseconds,
    ...
;