> ## 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.

# column_anomalies

`elementary.column_anomalies`

Executes column level monitors and anomaly detection on the column.
Specific monitors are detailed in the table below and can be configured using the `columns_anomalies` configuration.

The test checks the data type of the column and only executes monitors that are relevant to it.

<Snippet file="column-metrics.mdx" />

### Test configuration

No mandatory configuration, however it is highly recommended to configure a `timestamp_column`.

{/* prettier-ignore */}

<pre>
  <code>
    tests:
      -- elementary.column\_anomalies:
        <a href="/data-tests/anomaly-detection-configuration/column-anomalies"><font color="#CD7D55">column\_anomalies: column monitors list</font></a>
        <a href="/data-tests/anomaly-detection-configuration/timestamp-column"><font color="#CD7D55">timestamp\_column: column name</font></a>
        <a href="/data-tests/anomaly-detection-configuration/where-expression"><font color="#CD7D55">where\_expression: sql expression</font></a>
        <a href="/data-tests/anomaly-detection-configuration/anomaly-sensitivity"><font color="#CD7D55">anomaly\_sensitivity: int</font></a>
        <a href="/data-tests/anomaly-detection-configuration/anomaly-direction"><font color="#CD7D55">anomaly\_direction: \[both | spike | drop]</font></a>
        <a href="/data-tests/anomaly-detection-configuration/detection-period"><font color="#CD7D55">detection\_period:</font></a>
          <a href="/data-tests/anomaly-detection-configuration/detection-period"><font color="#CD7D55">period: \[hour | day | week | month]</font></a>
          <a href="/data-tests/anomaly-detection-configuration/detection-period"><font color="#CD7D55">count: int</font></a>
        <a href="/data-tests/anomaly-detection-configuration/training-period"><font color="#CD7D55">training\_period:</font></a>
          <a href="/data-tests/anomaly-detection-configuration/training-period"><font color="#CD7D55">period: \[hour | day | week | month]</font></a>
          <a href="/data-tests/anomaly-detection-configuration/training-period"><font color="#CD7D55">count: int</font></a>
        <a href="/data-tests/anomaly-detection-configuration/time-bucket"><font color="#CD7D55">time\_bucket:</font></a>
          <a href="/data-tests/anomaly-detection-configuration/time-bucket"><font color="#CD7D55">period: \[hour | day | week | month]</font></a>
          <a href="/data-tests/anomaly-detection-configuration/time-bucket"><font color="#CD7D55">count: int</font></a>
        <a href="/data-tests/anomaly-detection-configuration/seasonality"><font color="#CD7D55">seasonality: day\_of\_week</font></a>
        <a href="/data-tests/anomaly-detection-configuration/detection-delay"><font color="#CD7D55">detection\_delay:</font></a>
          <a href="/data-tests/anomaly-detection-configuration/detection-delay"><font color="#CD7D55">period: \[hour | day | week | month]</font></a>
          <a href="/data-tests/anomaly-detection-configuration/detection-delay"><font color="#CD7D55">count: int</font></a>
        <a href="/data-tests/anomaly-detection-configuration/ignore_small_changes"><font color="#CD7D55">ignore\_small\_changes:</font></a>
          <a href="/data-tests/anomaly-detection-configuration/ignore_small_changes"><font color="#CD7D55">spike\_failure\_percent\_threshold: int</font></a>
          <a href="/data-tests/anomaly-detection-configuration/ignore_small_changes"><font color="#CD7D55">drop\_failure\_percent\_threshold: int</font></a>
        <a href="/data-tests/anomaly-detection-configuration/anomaly-exclude-metrics"><font color="#CD7D55">anomaly\_exclude\_metrics: \[SQL expression]</font></a>
  </code>
</pre>

<RequestExample>
  ```yml Models
  models:
    - name: < model name >
      config:
        elementary:
          timestamp_column: < timestamp column >
      columns:
        - name: < column name >
          tests:
            - elementary.column_anomalies:
                column_anomalies: < specific monitors, all if null >
                where_expression: < sql expression >
                time_bucket: # Daily by default
                  period: < time period >
                  count: < number of periods >

    - name: < model name >
      ## if no timestamp is configured, elementary will monitor without time filtering
      columns:
        - name: < column name >
          tests:
            - elementary.column_anomalies:
                column_anomalies: < specific monitors, all if null >
                where_expression: < sql expression >
  ```

  ```yml Models example

  models:
    - name: login_events
      config:
        elementary:
          timestamp_column: 'loaded_at'
      columns:
        - name: user_name
          tests:
            - elementary.column_anomalies:
                column_anomalies:
                  - missing_count
                  - min_length
                where_expression: "event_type in ('event_1', 'event_2') and country_name != 'unwanted country'"
                time_bucket:
                  period: day
                  count: 1
                tags: ['elementary']

    - name: users
      ## if no timestamp is configured, elementary will monitor without time filtering
      tests:
          elementary.volume_anomalies
            tags: ['elementary']
      columns:
        - name: user_id
          tests:
            - elementary.column_anomalies:
                tags: ['elementary']
                timestamp_column: 'updated_at'
                where_expression: "event_type in ('event_1', 'event_2') and country_name != 'unwanted country'"
                time_bucket:
                  period: < time period >
                  count: < number of periods >
        - name: user_name
          tests:
            - elementary.column_anomalies:
                column_anomalies:
                  - missing_count
                  - min_length
                tags: ['elementary']
  ```
</RequestExample>
