Metric

A named, reusable number selected by the LLM. The aggregation is inlined per type (no separate Measure layer):

nameName (string)필수

typeType (string)필수

Possible values: [simple, ratio, derived, cumulative, conversion]

data_type object

하나 이상(anyOf)

• ArrowFieldType
• null

nameName (string)필수

Arrow type name, e.g. 'int64', 'utf8', 'decimal'

unit object

하나 이상(anyOf)

• string
• null

string

Possible values: [s, ms, us, ns]

timezone object

하나 이상(anyOf)

• string
• null

string

precision object

하나 이상(anyOf)

• integer
• null

integer

Possible values: >= 1 and <= 76

scale object

하나 이상(anyOf)

• integer
• null

integer

Possible values: >= 0

label object

하나 이상(anyOf)

• string
• null

string

description object

하나 이상(anyOf)

• string
• null

string

synonymsstring[]

sortableSortable (boolean)

기본값: true

visibleVisible (boolean)

기본값: true

options object

하나 이상(anyOf)

• object
• null

object

agg object

하나 이상(anyOf)

• string
• null

string

Possible values: [sum, avg, min, max, count, count_distinct, median, percentile]

expr object

하나 이상(anyOf)

• string
• null

string

percentile object

하나 이상(anyOf)

• number
• null

number

clauses object[]

Array [

columnColumn (string)필수

Semantic column definition. Capability flags control filtering, sorting, grouping, and catalog visibility; values is exhaustive, samples is illustrative, and dictionary-backed columns suppress both value lists from semantic catalog output.

opOp (string)필수

valueValue

granularity object

하나 이상(anyOf)

• string
• null

string

Possible values: [minute, hour, day, week, month, quarter, year]

]

window object

하나 이상(anyOf)

• string
• null

string

grain_to_date object

하나 이상(anyOf)

• string
• null

string

Possible values: [minute, hour, day, week, month, quarter, year]

numerator object

하나 이상(anyOf)

• AggSpec
• null

aggAgg (string)필수

Possible values: [sum, avg, min, max, count, count_distinct, median, percentile]

expr object

하나 이상(anyOf)

• string
• null

string

percentile object

하나 이상(anyOf)

• number
• null

number

clauses object[]

Array [

columnColumn (string)필수

Semantic column definition. Capability flags control filtering, sorting, grouping, and catalog visibility; values is exhaustive, samples is illustrative, and dictionary-backed columns suppress both value lists from semantic catalog output.

opOp (string)필수

valueValue

granularity object

하나 이상(anyOf)

• string
• null

string

Possible values: [minute, hour, day, week, month, quarter, year]

]

denominator object

하나 이상(anyOf)

• AggSpec
• null

aggAgg (string)필수

Possible values: [sum, avg, min, max, count, count_distinct, median, percentile]

expr object

하나 이상(anyOf)

• string
• null

string

percentile object

하나 이상(anyOf)

• number
• null

number

clauses object[]

Array [

columnColumn (string)필수

Semantic column definition. Capability flags control filtering, sorting, grouping, and catalog visibility; values is exhaustive, samples is illustrative, and dictionary-backed columns suppress both value lists from semantic catalog output.

opOp (string)필수

valueValue

granularity object

하나 이상(anyOf)

• string
• null

string

Possible values: [minute, hour, day, week, month, quarter, year]

]

base object

하나 이상(anyOf)

• AggSpec
• null

aggAgg (string)필수

Possible values: [sum, avg, min, max, count, count_distinct, median, percentile]

expr object

하나 이상(anyOf)

• string
• null

string

percentile object

하나 이상(anyOf)

• number
• null

number

clauses object[]

Array [

columnColumn (string)필수

Semantic column definition. Capability flags control filtering, sorting, grouping, and catalog visibility; values is exhaustive, samples is illustrative, and dictionary-backed columns suppress both value lists from semantic catalog output.

opOp (string)필수

valueValue

granularity object

하나 이상(anyOf)

• string
• null

string

Possible values: [minute, hour, day, week, month, quarter, year]

]

conversion object

하나 이상(anyOf)

• AggSpec
• null

aggAgg (string)필수

Possible values: [sum, avg, min, max, count, count_distinct, median, percentile]

expr object

하나 이상(anyOf)

• string
• null

string

percentile object

하나 이상(anyOf)

• number
• null

number

clauses object[]

Array [

columnColumn (string)필수

Semantic column definition. Capability flags control filtering, sorting, grouping, and catalog visibility; values is exhaustive, samples is illustrative, and dictionary-backed columns suppress both value lists from semantic catalog output.

opOp (string)필수

valueValue

granularity object

하나 이상(anyOf)

• string
• null

string

Possible values: [minute, hour, day, week, month, quarter, year]

]

entity object

하나 이상(anyOf)

• string
• null

string

metrics object[]

Array [

nameName (string)필수

alias object

하나 이상(anyOf)

• string
• null

string

offset_window object

하나 이상(anyOf)

• string
• null

string

]

Metric

{
  "name": "string",
  "type": "simple",
  "data_type": {
    "name": "string",
    "unit": "s",
    "timezone": "string",
    "precision": 0,
    "scale": 0
  },
  "label": "string",
  "description": "string",
  "synonyms": [
    "string"
  ],
  "sortable": true,
  "visible": true,
  "options": {},
  "agg": "sum",
  "expr": "string",
  "percentile": 0,
  "clauses": [
    {
      "column": "string",
      "op": "string",
      "granularity": "minute"
    }
  ],
  "window": "string",
  "grain_to_date": "minute",
  "numerator": {
    "agg": "sum",
    "expr": "string",
    "percentile": 0,
    "clauses": [
      {
        "column": "string",
        "op": "string",
        "granularity": "minute"
      }
    ]
  },
  "denominator": {
    "agg": "sum",
    "expr": "string",
    "percentile": 0,
    "clauses": [
      {
        "column": "string",
        "op": "string",
        "granularity": "minute"
      }
    ]
  },
  "base": {
    "agg": "sum",
    "expr": "string",
    "percentile": 0,
    "clauses": [
      {
        "column": "string",
        "op": "string",
        "granularity": "minute"
      }
    ]
  },
  "conversion": {
    "agg": "sum",
    "expr": "string",
    "percentile": 0,
    "clauses": [
      {
        "column": "string",
        "op": "string",
        "granularity": "minute"
      }
    ]
  },
  "entity": "string",
  "metrics": [
    {
      "name": "string",
      "alias": "string",
      "offset_window": "string"
    }
  ]
}