dimension

{“what”:“Unique integer identifier for the dimension row.”,“why”:“Needed as a stable reference from fact tables and other metadata.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:55.339265114+00:00”}

{“what”:“Identifier of the source field this dimension is built from.”,“why”:“Links the dimension to its origin column; without it, the mapping is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:55.462814546+00:00”}

{“what”:“Human-readable label for the dimension, e.g., ‘Product Category’.”,“why”:“Used in reports and UI; without it, users cannot identify the dimension.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:55.494218680+00:00”}

{“what”:“Data type of the dimension values, e.g., ‘string’, ‘numeric’.”,“why”:“Determines formatting and aggregation rules; without it, processing is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:55.615967132+00:00”}

{“what”:“Identifier of a field that provides a readable label for the dimension’s values.”,“why”:“Enables mapping codes to display names; without it, only raw values are available.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:55.711893859+00:00”}

{“what”:“Timestamp (with time zone) when the dimension row was created.”,“why”:“Needed for auditing and tracking when dimensions were added.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:55.780200107+00:00”}

{“what”:“Timestamp (with time zone) of the last modification to the dimension row.”,“why”:“Shows staleness; without it, change detection is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:55.801137849+00:00”}

{“what”:“Identifier of the entity (e.g., table) this dimension belongs to.”,“why”:“Scopes dimensions to a specific entity; without it, dimensions from different entities could conflict.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:55.822623173+00:00”}