field_usage


Description

{“what”:“One row per field used in a query execution, with usage details.”,“why”:“Without it, there is no record of how fields are used across queries, making impact analysis of field changes impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:17.725639884+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null

{“what”:“Unique integer identifier for this usage row.”,“why”:“Without it, rows cannot be uniquely referenced for updates or deletions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:17.836308970+00:00”}

field_id int4 10 null
metabase_field.id fk_field_usage_field_id_metabase_field_id C

{“what”:“Identifier of the field that was used in the query.”,“why”:“Without it, you cannot know which field the usage record applies to.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:17.858166963+00:00”}

query_execution_id int4 10 null
query_execution.id fk_field_usage_query_execution_id C

{“what”:“Identifier of the query execution in which the field was used.”,“why”:“Without it, you cannot associate the usage with a specific query run.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:17.883618674+00:00”}

used_in varchar 25 null

{“what”:“Query section where the field appears: filter, aggregation, breakout, etc.”,“why”:“Without it, you cannot distinguish which part of the query the field influenced.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:17.904099343+00:00”}

filter_op varchar 25 √ null

{“what”:“Comparison operator used when the field is in a filter, e.g., =, >, contains.”,“why”:“Without it, filter usage lacks the operator, so you cannot analyze filter patterns or replicate the condition.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:17.927021128+00:00”}

aggregation_function varchar 25 √ null

{“what”:“Aggregate function applied to the field, e.g., sum, avg, count.”,“why”:“Without it, you cannot know how the field was aggregated, making usage analysis incomplete.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:17.948334403+00:00”}

breakout_temporal_unit varchar 25 √ null

{“what”:“Temporal unit for a breakout, e.g., day, week, month.”,“why”:“Without it, you cannot know the time granularity of a breakout, losing query intent.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:17.975831818+00:00”}

breakout_binning_strategy varchar 25 √ null

{“what”:“Binning strategy for a breakout, e.g., equal width, quantile.”,“why”:“Without it, you cannot know how numeric values were grouped, affecting analysis of usage.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:18.004176244+00:00”}

breakout_binning_num_bins int4 10 √ null

{“what”:“Number of bins used in the binning strategy.”,“why”:“Without it, the binning configuration is incomplete, so you cannot reproduce the breakout.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:18.029176846+00:00”}

breakout_binning_bin_width int4 10 √ null

{“what”:“Width of each bin in the binning strategy.”,“why”:“Without it, the binning configuration is incomplete, so you cannot reproduce the breakout.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:18.058812251+00:00”}

created_at timestamptz 35,6 now()

{“what”:“UTC timestamp of when the usage was recorded.”,“why”:“Without it, you cannot know when the usage occurred, losing temporal context for analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:18.093586527+00:00”}

Indexes

Constraint Name Type Sort Column(s)
field_usage_pkey Primary key Asc id
idx_field_usage_field_id Performance Asc field_id
idx_field_usage_query_execution_id Performance Asc query_execution_id

Relationships