KATER__IS_EQUAL_TO

Family: Conditions

Syntax

1
KATER__IS_EQUAL_TO(field, value)

Arguments

Returns

TRUE or FALSE. It is NULL where the field is empty, so a filter leaves that row out.

Usage notes

• On a timestamp, it matches one exact instant, not a whole day. To match a day, test KATER__DATE(field).

Example

This Sandbox query reads the sample shop’s orders. The table shows the rows that Kater gave.

1
SELECT
2
  orders.currency AS "Currency",
3
  EVAL(orders.count_distinct__order_id) AS "Orders"
4
FROM kater_dataset.orders AS orders
5
WHERE
6
  KATER__IS_EQUAL_TO(orders.currency, 'EUR')
7
GROUP BY
8
  orders.currency
9
ORDER BY
10
  1

Compiles to

The call compiles to the same SQL on DuckDB and on Snowflake.

1
orders.currency = 'EUR'

See also

• Filters and parameters
• Other functions in Conditions: KATER__IS_NOT_EQUAL_TO, KATER__IS_GREATER_THAN, KATER__IS_AT_LEAST, KATER__IS_LESS_THAN, KATER__IS_AT_MOST, KATER__IS_BETWEEN, KATER__IS_ONE_OF, KATER__IS_NOT_ONE_OF, KATER__TEXT_CONTAINS, KATER__TEXT_DOES_NOT_CONTAIN, KATER__IS_NULL, KATER__IS_NOT_NULL