where_expression

where_expression: [sql expression]

Filter the tested data using a valid sql expression.

• Default: None
• Relevant tests: All anomaly detection tests

test

models:
  - name: this_is_a_model
    tests:
      - elementary.volume_anomalies:
          where_expression: "user_name != 'test'"

models:
  - name: this_is_a_model
    config:
      elementary:
        where_expression: "loaded_at is not null"

vars:
  where_expression: "loaded_at > '2022-01-01'"