OptionalaggregatesThe aggregate functions allowed on this field. Omit for none — a field nothing can be summed over, like a name.
OptionaldescriptionWhat the field means, and anything an agent would otherwise assume wrongly.
OptionalenumFor enum, the values it may hold. Rendered into the guide and enforced.
OptionalfilterableMay appear in filters. Default true.
OptionalgroupableMay appear in groupBy or be selected as a dimension. Default true.
OptionallabelHuman-facing name for the schema guide. Falls back to name.
The name an agent uses. Stable; it appears in prompts and saved queries.
One queryable field.
A field is not required to be a stored column. A host may declare a derived field — an age computed from a date of birth, a total computed from five columns — and translate it in its executor. Declaring it here is what keeps the arithmetic out of the model, which is the difference between an answer that is right and one that is plausible.