Use conditional functions to branch query logic based on evaluated predicates. They let you map values to labels, define alert tiers, or apply different transformations to different rows in a single expression.
List of functions
| Function | Description |
|---|---|
| case | Evaluates a list of conditions and returns the value paired with the first condition that's true. |
| iff | Evaluates a single predicate and returns one of two values. iif is an alias. |