Skip to content

DBT: Monitors Runs

DBT model name: monitors_runs

Explore dependencies/lineage: link

Description

This is a view on data_monitoring_metrics that is used to determine when a specific anomaly detection test was last executed. Each anomaly detection test queries this view to decide on a start time for collecting metrics.

Details

Column Type Description

No data tests defined 🧐

Not referenced by any model or exposure.

Models

No called script or script source not found.

{{ config(materialized="view", bind=False) }}

with
    data_monitoring_metrics as (select * from {{ ref("data_monitoring_metrics") }}),

    max_bucket_end as (

        select
            full_table_name,
            column_name,
            metric_name,
            metric_properties,
            max(bucket_end) as last_bucket_end,
            min(bucket_end) as first_bucket_end
        from data_monitoring_metrics
        group by full_table_name, column_name, metric_name, metric_properties

    )

select *
from max_bucket_end