workspace_transform

{“what”:“Alphanumeric identifier for the transformation, unique per workspace.”,“why”:“Identifies the transformation in URLs or API calls; without it, the row cannot be uniquely addressed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:04.122502698+00:00”}

{“what”:“Numeric ID of the workspace that owns this transformation.”,“why”:“Scopes the transformation to a workspace; without it, the same ref_id could collide across workspaces.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:04.139550345+00:00”}

{“what”:“Optional numeric ID for a global counterpart, if this is a copy or reference.”,“why”:“Allows sharing or referencing a transformation across workspaces; without it, the transformation is workspace-only.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:04.165071508+00:00”}

{“what”:“Optional numeric ID of the collection this transformation belongs to.”,“why”:“Groups transformations into collections for organization; without it, the transformation is ungrouped.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:04.179405540+00:00”}

{“what”:“Numeric ID of the user who created this transformation.”,“why”:“Tracks ownership and audit; without it, the creator is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:04.207537126+00:00”}

{“what”:“Human-readable name of the transformation, e.g., ‘Daily Sales Rollup’.”,“why”:“Used for display and identification in UI; without it, users cannot distinguish transformations.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:04.226175854+00:00”}

{“what”:“Optional free-text description of the transformation’s purpose or logic.”,“why”:“Provides context for maintainers; without it, the transformation’s intent is undocumented.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:04.253218847+00:00”}

{“what”:“Definition of the source data or query, e.g., SQL or table name.”,“why”:“Defines where input data comes from; without it, the transformation has no input.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:04.274552135+00:00”}

{“what”:“Definition of the output destination or query, e.g., table name or file path.”,“why”:“Defines where results are written; without it, the transformation has no output.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:04.292062612+00:00”}

{“what”:“Optional identifier of a specific entity (e.g., row or object) this transformation applies to.”,“why”:“Narrows the transformation to a single entity; without it, the transformation applies to the whole source.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:04.318484738+00:00”}

{“what”:“Timestamp when the transformation was locked for editing, in UTC.”,“why”:“Prevents concurrent edits; without it, two users could overwrite each other.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:04.341455185+00:00”}

{“what”:“Timestamp when the transformation was soft-deleted, in UTC; null means active.”,“why”:“Allows recovery and audit; without it, deleted transformations are permanently lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:04.363608727+00:00”}

{“what”:“Timestamp when the transformation was created, in UTC.”,“why”:“Provides creation time for audit and ordering; without it, creation time is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:04.383247366+00:00”}

{“what”:“Timestamp of the last update to the transformation definition, in UTC.”,“why”:“Tracks modification time for conflict detection; without it, stale edits cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:04.400682636+00:00”}

{“what”:“Timestamp of the most recent execution attempt, in UTC; null if never run.”,“why”:“Shows execution recency; without it, users cannot know if the transformation is stale.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:04.420116151+00:00”}

{“what”:“Free-text message from the last execution, e.g., error or success details.”,“why”:“Provides execution feedback; without it, failures are silent.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:04.439176338+00:00”}

{“what”:“Status of the last execution, e.g., ‘success’, ‘failed’, ‘running’.”,“why”:“Indicates whether the last run succeeded; without it, the transformation’s health is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:04.531715934+00:00”}

{“what”:“Flag indicating whether the transformation definition changed since the last run; default true.”,“why”:“Triggers re-analysis on next run; without it, changes might be missed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:04.588668798+00:00”}

{“what”:“Version number of the analysis logic used for the transformation; increments on definition changes.”,“why”:“Tracks which analysis version produced results; without it, results cannot be matched to logic.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:04.701079458+00:00”}

{“what”:“Flag indicating whether the input data changed since the last run; default false.”,“why”:“Determines if a re-run is needed; without it, stale results may be used.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:04.758327776+00:00”}