> ## Documentation Index
> Fetch the complete documentation index at: https://elementary-more-explicit-webhook-instructions.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# where_expression

`where_expression: [sql expression]`

Filter the tested data using a valid sql expression.

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

<RequestExample>
  ```yml test
  models:
    - name: this_is_a_model
      tests:
        - elementary.volume_anomalies:
            where_expression: "user_name != 'test'"
  ```

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

  ```yml dbt_project.yml
  vars:
    where_expression: "loaded_at > '2022-01-01'"
  ```
</RequestExample>