want to be able to inspect the time series data fo...
# community-support
s
want to be able to inspect the time series data for a given anomaly test and chart it like the image below. I had to go through the following steps to generate the below image: • Run the test • Go into Databricks Query History and inspect the code that ran • Copy the code and paste it into a separate query editor • Run the query and graph from there Is this really the simplest way to inspect a time series for a given anomaly test? I don't see the time series data stored anywhere in the elementary tables
o
Hi @Samuel Garfield, i believe you will find the data you are looking for in the
data_monitoring_metrics
table in your elementary schema
s
Thanks @Ofek Weiss but unless I'm missing something
data_monitoring_metrics
doesn't have
min_metric_score
and
max_metric_score
so it's impossible to reproduce the chart I shared above without manually checking the anomaly threshold in the test config and computing the
min_metric_score
and
max_metric_score
, right?
o
Hi @Samuel Garfield, you are right, i missed it in the image you shared, the metics with all the data regarding the anomaly score can be found in the
test_result_rows
in your elementary schema