where_expression

models:
  - name: this_is_a_model
    data_tests:
      - elementary.volume_anomalies:
          arguments:
            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'"

Generate your anomaly test with Elementary AI

Let our Slack chatbot create the anomaly test you need.

where_expression: [sql expression] Filter the tested data using a valid sql expression.

Default: None
Relevant tests: All anomaly detection tests

The where_expression is used to filter out the data that you want to test. For example, to only test weekdays for anomalies, you can filter on the day of the week:

where_expression: EXTRACT(DOW FROM timestamp_column) BETWEEN 2 AND 6 
#Test Monday through Friday

models:
  - name: this_is_a_model
    data_tests:
      - elementary.volume_anomalies:
          arguments:
            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'"

timestamp_column anomaly_sensitivity

Elementary dbt package

Elementary Data tests

Anomaly Detection Tests

Schema Tests

AI Data Tests (Beta)

Other Tests

dbt Package Release Notes

Generate your anomaly test with Elementary AI