I want to test for elementary data test for column...
# ask-elementary-ai
s
I want to test for elementary data test for column_anomolies for a particular column in a table sales_refined4 column:"Amount Extended Price Base Currency" I want to check for this two errors . - name: sales_refined4 data_tests: - elementary.volume_anomalies: anomaly_direction: both ignore_small_changes: spike_failure_percent_threshold: 6 drop_failure_percent_threshold: 6 tags: ["elementary", "daily_elementary", "refined4", "common_refined4"] columns: - name: "salesbacklogskey" quote: true data_tests: - unique: config: severity: error error_if: ">1" warn_if: ">1" - not_null merge in this code
k
A message from kapa.ai
New message text here
s
Copy code
# Optionally specify which monitors to use, or leave blank for defaults
              # column_anomalies: [average, min, max]  # Example: monitor specific metrics
which should i give here what is meant by which monitoprs to use in the sense , column_anomolies , I need to ensure there is not much null for the amount field, so im asking for null_percent and null_count
Copy code
# Optionally specify which monitors to use, or leave blank for defaults
              # column_anomalies: [average, min, max]  # Example: monitor specific metrics
which should i give here what is meant by which monitoprs to use in the sense , column_anomolies , I need to ensure there is not much null for the amount field, so im asking for null_percent and null_count