elementary.daily_test_summary

Aggregates Elementary test results by event_date × env × target_name. Filters out invocations with an empty event_date and orders descending by date.

Lineage

flowchart LR
el1[(elementary.elementary_test_results)] --> me[/elementary.daily_test_summary/]
el2[(elementary.dbt_invocations)] --> me
me -.-> none((terminal — consumed by dashboards))

Columns

Column	Description	Formula
event_date	Logical event date being tested.	JSONExtractString(i.invocation_vars, 'event_date')
env	Environment (dev/main/…).	JSONExtractString(i.invocation_vars, 'env')
target_name	dbt target name.	i.target_name
total_tests	Total tests executed for this date/env.	COUNT(*)
tests_passed	Number of tests that passed.	SUM(CASE WHEN t.status = 'pass' THEN 1 ELSE 0 END)
tests_failed	Number of tests that failed.	SUM(CASE WHEN t.status = 'fail' THEN 1 ELSE 0 END)
tests_warned	Tests that returned warn.	SUM(CASE WHEN t.status = 'warn' THEN 1 ELSE 0 END)
tests_errored	Tests that errored.	SUM(CASE WHEN t.status = 'error' THEN 1 ELSE 0 END)
tests_skipped	Tests that were skipped.	SUM(CASE WHEN t.status = 'skipped' THEN 1 ELSE 0 END)
total_failures	Sum of failure counts across tests.	SUM(t.failures)
total_failed_rows	Sum of failed-row counts across tests.	SUM(t.failed_row_count)
anomaly_tests	Count of anomaly-detection tests.	SUM(CASE WHEN t.test_type = 'anomaly_detection' THEN 1 ELSE 0 END)
schema_tests	Count of schema-change tests.	SUM(CASE WHEN t.test_type = 'schema_change' THEN 1 ELSE 0 END)
dbt_tests	Count of regular dbt tests.	SUM(CASE WHEN t.test_type = 'dbt_test' THEN 1 ELSE 0 END)
first_test_at	Earliest test detection timestamp.	MIN(t.detected_at)
last_test_at	Latest test detection timestamp.	MAX(t.detected_at)
invocation_count	Number of distinct dbt invocations.	COUNT(DISTINCT t.invocation_id)
latest_run_completed_at	Latest invocation end-time.	MAX(i.run_completed_at)