maiven gateway · online··
manifest · 1d ago
Sign in
Back to catalog
elementarymodelelementary

dbt_run_results

observability incremental
Model notesexpand

Run results of dbt invocations, inserted at the end of each invocation. Each row is the invocation result of a single resource (model, test, snapshot, etc). New data is loaded to this model on an on-run-end hook named 'elementary.upload_run_results' from each invocation that produces a result object. This is an incremental model.

20 of 20
Column
Type
Description
Tests · PII
model_execution_id
string
Execution id generated by joining the unique_id of the resource and the invocation_id. This is the unique key of each row in this model.
unique_id
string
The unique id of the resource (would be similar for all executions of the same resource).
invocation_id
string
The unique id of the invocation (would be similar for all resources executed on the same invocation). FK to dbt_invocations.
generated_at
string
No description
name
string
Resource name.
message
string
Execution results message returned by dbt.
status
string
Execution result status (success, error, pass, fail)
resource_type
string
Resource type (model, test, snapshot, seed, etc)
execution_time
float
Resource execution duration in seconds.
execute_started_at
string
Start time of the execution.
execute_completed_at
string
End time of the execution.
compile_started_at
string
Start time of resource compile action.
compile_completed_at
string
End time of resource compile action.
rows_affected
bigint
No description
full_refresh
boolean
Was this a full refresh execution.
compiled_code
string
The compiled code (SQL / Python) executed against the database.
failures
bigint
Number of failures in this run.
query_id
string
Query ID in the data warehouse, if returned by the adapter (currently only supported in Snowflake, is null for any other adapter).
thread_id
string
Id of the thread of this resource run.
adapter_response
string
Response returned by the adapter (Fields will be different for each adapters).