elementary.test_results_by_date

View over elementary_test_results left-joined to dbt_invocations. Extracts event_date and env from invocation_vars so they’re queryable as plain columns.

Lineage

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

Columns

Column	Description	Formula
id	Unique identifier for the test result.	t.id
data_issue_id	Elementary data-issue id.	t.data_issue_id
test_execution_id	Elementary test-execution id.	t.test_execution_id
test_unique_id	Unique identifier for the test definition.	t.test_unique_id
model_unique_id	Unique identifier for the tested model.	t.model_unique_id
invocation_id	Joins to dbt_invocations.	t.invocation_id
detected_at	Timestamp the test result was detected.	t.detected_at
created_at	Row-creation timestamp in Elementary.	t.created_at
database_name	Test target database.	t.database_name
schema_name	Test target schema.	t.schema_name
table_name	Test target table.	t.table_name
column_name	Test target column (when applicable).	t.column_name
test_type	dbt_test / anomaly_detection / schema_change.	t.test_type
test_sub_type	Elementary sub-type.	t.test_sub_type
test_results_description	Human description from Elementary.	t.test_results_description
owners	Owner metadata.	t.owners
tags	Tag metadata.	t.tags
test_results_query	Compiled query that produced the result.	t.test_results_query
other	Catch-all blob from Elementary.	t.other
test_name	Name of the test.	t.test_name
test_params	Parameters passed to the test.	t.test_params
severity	Configured severity (warn/error).	t.severity
status	Result status (pass/fail/warn/error/skipped).	t.status
failures	Number of failures detected.	t.failures
test_short_name	Short alias for the test.	t.test_short_name
test_alias	Configured alias.	t.test_alias
result_rows	Sample failing rows (Elementary format).	t.result_rows
failed_row_count	Count of failing rows.	t.failed_row_count
event_date	Logical event date the run targeted.	JSONExtractString(i.invocation_vars, 'event_date')
env	Environment (dev/main/…).	JSONExtractString(i.invocation_vars, 'env')
command	dbt command executed.	i.command
dbt_version	dbt version that ran.	i.dbt_version
elementary_version	Elementary package version.	i.elementary_version
full_refresh	Whether the invocation was a full refresh.	i.full_refresh
target_name	dbt target name.	i.target_name
target_schema	dbt target schema.	i.target_schema
selected	dbt --select argument value.	i.selected
run_started_at	Invocation start.	i.run_started_at
run_completed_at	Invocation end.	i.run_completed_at