On this page
Kater SQL Language
What each model allows
Which Kater SQL calls each kind of model, query and test can hold.
| Call | Kater dataset | Custom SQL dataset | Semantic model | Workspace root | Query |
|---|---|---|---|---|---|
DIMENSION, MEASURE, EVAL | Yes | Yes | Yes | Yes | Yes |
CUSTOM_CALCULATION | No | No | No | No | Yes |
| Windows | As a dimension | As a dimension | As a dimension | No | Yes |
RELATIONSHIP | No | Yes | Yes | No | Yes |
OPTIONAL_FILTER, parameters | No | No | No | Yes | Yes |
REQUIRED_FILTER | Yes | Yes | Yes | Yes | Yes |
EXCEL | No | No | No | No | Yes |
Tests compile as queries. A chart’s SQL reads only its parent query and declares no fields. A scratch file in the Sandbox allows plain joins, parameters, optional filters and custom calculations.