Custom Metric Syntax
Breakdown of the Arize Query Language
Custom metrics use an Arize SQL-like query language.
SELECT
< AGG_FUNC | METRIC_FUNC >(exprs)
[FILTER (WHERE exprs)]
[CASE WHEN ...END ]
[ <OPERATOR> { < AGG_FUNC | ARIZE_METRIC >(exprs) | constant }] …
FROM model
[WHERE (exprs) ]
Every query starts with a
SELECT
statement.The
FROM
statement should beFROM model
, where model
refers to the model that the custom metric was created under.A constant can be a number or string. Strings use single quotes like this:
'this is a string'
. Numbers can be floats or integers.dimension
constant
[ dimension | constant | (exprs) ] <OPERATOR> [ dimension | constant | (exprs) ]
An expression is a statement composed of simple math or boolean operators. An expression does not have an aggregation function within it. Expressions can include nested expressions, for example, A * (B + C). Expressions return the same number of rows as those that go into it.
A dimension is any feature, tag, prediction, or actual of a model. A dimension can either be of type string or of type numeric.
Type | Invocation | Description |
---|---|---|
Feature | feature_name or "feature name" | Features can be referenced directly or use double quotes. Note: if there are spaces in your feature name, you must use double quotes. |
Tag | tag_name or "tag name" | Tags can be referenced directly or use double quotes. Note: if there are spaces in your tag name, you must use double quotes. |
Prediction | categoricalPredictionLabel scorePredictionLabel numericPredictionLabel | For scored categorical models, there is categoricalPredictionLabel and scorePredictionLabel
For numeric models, there is only numericPredictionLabel |
Actual | categoricalActualLabel scoreActualLabel numericActualLabel | For scored categorical models, there is categoricalActualLabel and scoreActualLabel
For numeric models, there is only numericActualLabel |
Comments can be added to your query in one of two ways:
Single line comment (shortcut is
CMD + /
)-- This is a single line comment
Multi-line comments
/* This
* is a
* multiline comment
*/
Last modified 6mo ago