Skip to content

DBT: Alerts Schema Changes

DBT model name: alerts_schema_changes

Explore dependencies/lineage: link

Description

A view that is used by the Elementary CLI to generate alerts on schema changes detected using elementary tests. The view 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_schema_changes 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 = 'schema_change'
    )

select *
from alerts_schema_changes