DBT: Elementary Test Results

DBT model name: elementary_test_results

Explore dependencies/lineage: link

---

Description

Run results of all dbt tests, with fields and metadata needed to produce the Elementary report UI. Each row is the result of a single test, including native dbt tests, packages tests and elementary tests. New data is loaded to this model on an on-run-end hook named elementary.handle_tests_results.

---

Details

ColumnsData TestsReferenced ByDepends OnModel codeDBT details

Column	Type	Description

No data tests defined 🧐

Models

• alerts_anomaly_detection
• alerts_dbt_tests
• alerts_schema_changes
• test_result_rows
• dbt_entity_tags

Macros

• get_config_var
• get_default_table_type
• get_default_incremental_strategy
• get_indexes_for_model
• empty_elementary_test_results

No called script or script source not found.

{{
    config(
        materialized="incremental",
        unique_key="id",
        on_schema_change="append_new_columns",
        full_refresh=elementary.get_config_var("elementary_full_refresh"),
        meta={
            "timestamp_column": "created_at",
            "prev_timestamp_column": "detected_at",
        },
        table_type=elementary.get_default_table_type(),
        incremental_strategy=elementary.get_default_incremental_strategy(),
        indexes=elementary.get_indexes_for_model(
            "elementary_test_results",
            [
                {"columns": ["id"]},
                {"columns": ["test_unique_id", "detected_at"]},
            ],
        ),
    )
}}

{{ elementary.empty_elementary_test_results() }}

• Dbt path: trase_ducklake.main_elementary.elementary_test_results

• Containing yaml link: trase/data_pipeline/models/run_results.yml

• Model file: trase/data_pipeline/models/edr/run_results/elementary_test_results.sql

• Original dbt_docs