metric


Description

{“what”:“A metric definition: a named, computed measure on a data table.”,“why”:“Without it, there is no central catalog for metrics, leading to inconsistent calculations across reports.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:15.233759560+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
metric_important_field.metric_id fk_metric_important_field_metric_id C

{“what”:“Unique integer identifier for each metric row.”,“why”:“Without it, metrics cannot be uniquely referenced for joins, updates, or deletes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:15.315225489+00:00”}

table_id int4 10 null
metabase_table.id fk_metric_ref_table_id C

{“what”:“ID of the data table this metric is defined against.”,“why”:“Without it, the metric’s source table is unknown, so its definition cannot be executed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:15.525099382+00:00”}

creator_id int4 10 null
core_user.id fk_metric_ref_creator_id C

{“what”:“ID of the user who created this metric.”,“why”:“Without it, ownership and audit trail for metric changes is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:15.545476096+00:00”}

name varchar 254 null

{“what”:“Short human-readable metric name, e.g., ‘Revenue’.”,“why”:“Without it, metrics cannot be displayed or referenced in UI and reports.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:15.992454093+00:00”}

description text 2147483647 √ null

{“what”:“Free-text explanation of the metric’s meaning and use.”,“why”:“Without it, consumers cannot understand the metric’s intent, leading to misuse.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:16.599958857+00:00”}

archived bool 1 false

{“what”:“Flag indicating whether the metric is hidden from active use; true means archived.”,“why”:“Without it, retired metrics would still appear in lists and be used, causing confusion.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:16.838781128+00:00”}

definition text 2147483647 null

{“what”:“SQL expression or formula that computes the metric value.”,“why”:“Without it, the metric cannot be calculated or validated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:17.474573138+00:00”}

created_at timestamptz 35,6 null

{“what”:“Timestamp when the metric row was created, in UTC.”,“why”:“Without it, audit history and ordering of metric creation is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:17.485666468+00:00”}

updated_at timestamptz 35,6 null

{“what”:“Timestamp of the last modification to this metric row.”,“why”:“Without it, stale or conflicting edits cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:17.676500035+00:00”}

points_of_interest text 2147483647 √ null

{“what”:“Free-text notes highlighting notable aspects or anomalies in the metric.”,“why”:“Without it, analysts miss context about unusual data patterns.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:17.794196467+00:00”}

caveats text 2147483647 √ null

{“what”:“Free-text warnings about limitations or conditions affecting metric interpretation.”,“why”:“Without it, users may misinterpret metric values under certain conditions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:18.239509304+00:00”}

how_is_this_calculated text 2147483647 √ null

{“what”:“Plain-language explanation of the calculation steps behind the metric.”,“why”:“Without it, non-technical users cannot trust or verify the metric’s methodology.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:18.294149805+00:00”}

show_in_getting_started bool 1 false

{“what”:“Flag indicating whether the metric appears in the getting-started guide for new users.”,“why”:“Without it, onboarding content cannot be curated to highlight key metrics.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:18.434907380+00:00”}

entity_id bpchar 21 √ null

{“what”:“Single-character code identifying the entity type this metric applies to.”,“why”:“Without it, metrics cannot be filtered by entity type, making cross-entity comparisons ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:18.510655107+00:00”}

Indexes

Constraint Name Type Sort Column(s)
metric_pkey Primary key Asc id
idx_metric_creator_id Performance Asc creator_id
idx_metric_show_in_getting_started Performance Asc show_in_getting_started
idx_metric_table_id Performance Asc table_id
metric_entity_id_key Must be unique Asc entity_id

Relationships