Use null operators to test whether a value is null.
Null operators can return true or false.
| is null |
is null |
True when the value is null. |
| is not null |
is not null |
True when the value is not null. |
is null and is not
null can be used in projections, and in post-projection filters.
These are valid examples:
This is not a valid example: