transform_run


Description

{“what”:“A single execution attempt of a transformation job.”,“why”:“Without it, there is no record of when or how a transform ran, so audit and debugging are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:59.921159003+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
transform_run_cancelation.run_id fk_transform_run_cancelation_transform_run_run_id C

{“what”:“Unique numeric identifier for this run record.”,“why”:“Without it, runs cannot be referenced or linked to other tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:59.938653412+00:00”}

transform_id int4 10 √ null
transform.id fk_transform_run_transform_id N

{“what”:“Identifier of the transform definition this run belongs to.”,“why”:“Without it, you cannot tell which transform was executed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:59.964632937+00:00”}

run_method varchar 255 null

{“what”:“Method used to trigger the run, e.g. manual, scheduled, API.”,“why”:“Without it, you cannot distinguish automated from manual runs for auditing or debugging.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:59.982643620+00:00”}

status varchar 50 null

{“what”:“Current state of the run, e.g. running, succeeded, failed.”,“why”:“Without it, you cannot know if the run completed successfully or is still in progress.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.001137707+00:00”}

is_active bool 1 √ null

{“what”:“Flag indicating whether this run is the latest active one for its transform.”,“why”:“Without it, you cannot filter to the current run when multiple runs exist.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.018592618+00:00”}

start_time timestamptz 35,6 now()

{“what”:“Timestamp when the run started, in UTC with timezone.”,“why”:“Without it, you cannot measure run duration or order runs chronologically.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.042197140+00:00”}

end_time timestamptz 35,6 √ null

{“what”:“Timestamp when the run finished, null if still running.”,“why”:“Without it, you cannot compute duration or know if the run completed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.063393005+00:00”}

message text 2147483647 √ null

{“what”:“Free-text log or error message from the run.”,“why”:“Without it, you lose diagnostic details needed to debug failures.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.081639644+00:00”}

user_id int4 10 √ null
core_user.id fk_transform_run_user_id N

{“what”:“Identifier of the user who triggered the run, if any.”,“why”:“Without it, you cannot attribute runs to users for audit or access control.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.104709023+00:00”}

transform_name varchar 254 √ null

{“what”:“Snapshot of the transform’s name at run time.”,“why”:“Without it, the run’s meaning is lost if the transform is later renamed or deleted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.122183008+00:00”}

transform_entity_id bpchar 21 √ null

{“what”:“Identifier of the entity the transform operates on, as a character string.”,“why”:“Without it, you cannot know which data entity was processed by this run.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.136956440+00:00”}

checkpoint_filter_field_id int4 10 √ null

{“what”:“Identifier of the field used as the checkpoint filter for incremental runs.”,“why”:“Without it, you cannot know which field determined the incremental range.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.149072700+00:00”}

checkpoint_lo_value text 2147483647 √ null

{“what”:“Lower bound value of the checkpoint filter range, as text.”,“why”:“Without it, the start of the processed data range is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.162012388+00:00”}

checkpoint_hi_value text 2147483647 √ null

{“what”:“Upper bound value of the checkpoint filter range, as text.”,“why”:“Without it, the end of the processed data range is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:00.186152135+00:00”}

Indexes

Constraint Name Type Sort Column(s)
transform_run_pkey Primary key Asc id
idx_transform_run_active_runs Performance Asc/Asc is_active + transform_id
idx_transform_run_last_run_idx Performance Asc/Desc transform_id + start_time
idx_transform_run_user_id Performance Asc user_id
idx_unique_active_transform_run Must be unique Asc/Asc transform_id + is_active

Relationships