Column

default is the value that applies when nothing constrains this column: compile_query injects it as an op="=" condition unless the query already constrains the column (a conditions entry or a clause of a named filters entry, whatever the operator). Engine-neutral — it lands in WHERE on a SQL target and in the $filter / service-parameter segment on the OData ones — and its main use is a control parameter whose value never varies with the question (a SAP BW scaling/currency variable, visible=False so the LLM can neither see nor fill it). It is a canonical value, never a natural-language surface form: value linking runs before compile, so an injected default never passes through it.

nameName (string)필수

Physical column name, unless a computed expression in options.sql.expr replaces it for supported SQL targets.

kindKind (string)

Semantic column kind: categorical or time.

Possible values: [categorical, time]

기본값: categorical

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

Human-readable explanation of the column.

하나 이상(anyOf)

• string
• null

string

filterableFilterable (boolean)

Whether the column can be used in filter conditions.

기본값: true

sortableSortable (boolean)

Whether the column can be used for result ordering.

기본값: true

groupableGroupable (boolean)

Whether the column can be selected or used for grouping.

기본값: true

visibleVisible (boolean)

Whether the column is exposed in the semantic catalog. Hidden columns remain available to authored filters and templates.

기본값: true

synonymsstring[]

Alternative terms that may refer to the column.

valuesstring[]

Exhaustive values for a low-cardinality column. Omitted from semantic catalog output when dictionary is set.

samplesstring[]

Illustrative, non-exhaustive example values. Omitted from semantic catalog output when dictionary is set.

dictionary object

Dictionary used to resolve canonical values and surface-form synonyms.

하나 이상(anyOf)

• ColumnDictionary
• null

builtin object

하나 이상(anyOf)

• object
• null

object

external object

하나 이상(anyOf)

• string
• null

string

defaultDefault

options object

Target-specific column bindings, including an optional computed SQL expression.

하나 이상(anyOf)

• object
• null

object

Column

{
  "name": "string",
  "kind": "categorical",
  "data_type": {
    "name": "string",
    "unit": "s",
    "timezone": "string",
    "precision": 0,
    "scale": 0
  },
  "label": "string",
  "description": "string",
  "filterable": true,
  "sortable": true,
  "groupable": true,
  "visible": true,
  "synonyms": [
    "string"
  ],
  "values": [
    "string"
  ],
  "samples": [
    "string"
  ],
  "dictionary": {
    "builtin": {},
    "external": "string"
  },
  "options": {}
}