Skip to content

DBT: Alerts Dbt Tests

DBT model name: alerts_dbt_tests

Explore dependencies/lineage: link

Description

A view that is used by the Elementary CLI to generate dbt tests alerts, including all the fields the alert will include such as owner, tags, error message, etc. This view includes data about all dbt tests except elementary tests. It filters alerts according to configuration.

Details

Column Type Description

No data tests defined 🧐

Not referenced by any model or exposure.

Models

Macros

  • render_bool_config_var
  • get_config_var

No called script or script source not found.

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

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

    alerts_dbt_tests as (
        select
            id as alert_id,
            data_issue_id,
            test_execution_id,
            test_unique_id,
            model_unique_id,
            detected_at,
            database_name,
            schema_name,
            table_name,
            column_name,
            test_type as alert_type,
            test_sub_type as sub_type,
            test_results_description as alert_description,
            owners,
            tags,
            test_results_query as alert_results_query,
            other,
            test_name,
            test_short_name,
            test_params,
            severity,
            status,
            result_rows
        from elementary_test_results
        where
            {{ elementary.render_bool_config_var("disable_test_alerts", negate=true) }}
            and lower(status) != 'pass'
            {% if elementary.get_config_var("disable_warn_alerts") %}
                and lower(status) != 'warn'
            {% endif %}
            {% if elementary.get_config_var("disable_skipped_test_alerts") %}
                and lower(status) != 'skipped'
            {% endif %}
            and test_type = 'dbt_test'
    )

select *
from alerts_dbt_tests