transform

{“what”:“Unique integer identifier for the transform row.”,“why”:“Without it, rows cannot be referenced or joined uniquely.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:10.065663729+00:00”}

{“what”:“Human-readable name of the transform, e.g., ‘Daily Sales Rollup’.”,“why”:“Without it, users cannot identify or select a transform in UI or logs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:10.082712959+00:00”}

{“what”:“Free-form explanation of the transform’s purpose or logic.”,“why”:“Without it, future maintainers lack context for why the transform exists.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:10.098688287+00:00”}

{“what”:“Source table or query string that the transform reads from.”,“why”:“Without it, the input data is unknown, so the transform cannot be executed or validated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:10.114381614+00:00”}

{“what”:“Destination table or output location where transformed data is written.”,“why”:“Without it, the output destination is unknown, so results cannot be stored or consumed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:10.131964993+00:00”}

{“what”:“Identifier of the business entity this transform applies to, e.g., account or product ID.”,“why”:“Without it, transforms cannot be scoped to a specific entity, causing cross-entity data mixing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:10.144748655+00:00”}

{“what”:“UTC timestamp when the transform row was first inserted.”,“why”:“Without it, audit trails and ordering of transform creation are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:10.165412336+00:00”}

{“what”:“UTC timestamp of the last update to this transform row.”,“why”:“Without it, stale or concurrent modifications cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:10.178682586+00:00”}

{“what”:“Version number of the dependency analysis algorithm used for this transform.”,“why”:“Without it, results from different analysis versions become indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:10.196120157+00:00”}

{“what”:“Type of source, e.g., ‘table’, ‘query’, ‘file’.”,“why”:“Without it, the parser cannot interpret the source string correctly.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:10.220849766+00:00”}

{“what”:“User ID of the person who created this transform; default is system user.”,“why”:“Without it, ownership and accountability for the transform are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:10.234097794+00:00”}

{“what”:“ID of the database where the source data resides.”,“why”:“Without it, the source connection cannot be resolved, breaking execution.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:10.268629957+00:00”}

{“what”:“ID of the collection or folder this transform belongs to, if any.”,“why”:“Without it, transforms cannot be grouped or filtered by collection.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:10.280121269+00:00”}

{“what”:“User ID of the current owner responsible for this transform.”,“why”:“Without it, responsibility for maintenance and approvals is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:10.301453720+00:00”}

{“what”:“Email address of the owner, denormalized for quick contact.”,“why”:“Without it, contacting the owner requires a join to user table.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:10.322658165+00:00”}

{“what”:“ID of the database where the target output is written; null if same as source.”,“why”:“Without it, the output connection is unknown, preventing writes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:10.347992668+00:00”}

{“what”:“Last processed value (e.g., watermark) used for incremental transforms.”,“why”:“Without it, incremental runs cannot resume from the correct position.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:10.370723196+00:00”}