CJ Johanson
05/09/2024, 7:01 PMCREATE OR REPLACE TABLE anomaly_detection_test_data
(
test_val int,
loaded_at timestamp
);
INSERT INTO anomaly_detection_test_data
select
uniform(1, 5, random(10002)) AS test_val,
dateadd(day, '-' || seq4(), current_timestamp()) AS loaded_at
from table(generator(rowcount=>10));
and i used the following configuration for me anomaly detection test:
version: 2
models:
- name: anomaly_detection_model
config:
elementary:
timestamp_column: "loaded_at"
columns:
- name: test_val
tests:
- elementary.column_anomalies:
column_anomalies:
- average
time_bucket:
period: day
count: 1
i built the model which ran the test and the test ran fine, which is what i expected because i have yet to introduce any anomalies to the dataset. when i took a look at the elementary dashboard, i was very confused by the graph. the minimum and maximum datetimes within my dataset are 2024-04-30 174156.523 and 2024-05-09 174156.523, respectively. the anomaly detection chart in the dashboard shows my first time bucket as being 2024-04-17 to 2024-04-18. how is this possible when those dates do not exist in my dataset?