Does elementary table capture success runs even if one of the dbt model is failed I run all dbt models via airflow , but it has failed due to timeout , is there any table which captures all those that has completed successfully We want to analyze which one took more time to complete

Hi! Replied in the dbt community but writing here as well - Yes, in Elementary you have a table called model_run_results which captures all the model run results including execution times, status, error message, owner, tags and many more. You can also see it in the Elementary report under Model Runs tab

But i dont see it coz airflow dag failed due to timeout

Got it, dbt exposes the results only at the end of the run so if dbt doesn't finish we can't get access to this info

Shouldnot we capture all those completed runs instead of waiting for entire to complete and then capture

Yeah but unfortunately it's not possible, dbt provides the results info only at the end of the run.. In this case I'd run it locally and use the model_run_result to see what is the bottle neck