elementary.run_results_by_date

View over dbt_run_results left-joined to dbt_invocations. Extracts event_date and env from invocation_vars for trend analysis without JSON parsing.

Lineage

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

Columns

Column	Description	Formula
unique_id	Unique identifier for the run resource.	r.unique_id
invocation_id	Joins to dbt_invocations.	r.invocation_id
generated_at	Manifest-generation timestamp.	r.generated_at
created_at	Row-creation timestamp in Elementary.	r.created_at
name	Resource name.	r.name
message	dbt status / error message.	r.message
status	Run status (success/error/skipped).	r.status
resource_type	dbt resource type (model/test/…).	r.resource_type
execution_time	Execution time in seconds.	r.execution_time
execute_started_at	Execute step start.	r.execute_started_at
execute_completed_at	Execute step end.	r.execute_completed_at
compile_started_at	Compile step start.	r.compile_started_at
compile_completed_at	Compile step end.	r.compile_completed_at
rows_affected	Rows affected by the run.	r.rows_affected
full_refresh	Whether the run was a full refresh.	r.full_refresh
compiled_code	Compiled SQL.	r.compiled_code
failures	Failure count.	r.failures
query_id	ClickHouse query id.	r.query_id
thread_id	dbt worker thread.	r.thread_id
materialization	Materialisation kind.	r.materialization
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
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