when dbt runs all models , is there any log in ele...
# randomr
Ram
08/17/2023, 2:33 PMwhen dbt runs all models , is there any log in elementary table that can show time taken to complete for each model ? if yes whats the table name
r
Renee Cooper
08/17/2023, 2:45 PMelementary.dbt_run_results is what I use when I need to look up data and don't have the report handy. (otherwise the elementary report is the easiest way to view this)
Find the invocation id of the run you want using dbt_invocations and then use that to pull the rows from dbt_run_results.
r
Ram
08/17/2023, 3:10 PMI run dbt models via airflow , how do i get the invocation id for that run
r
Renee Cooper
08/17/2023, 3:18 PMIf you know when you ran it, search in dbt_invocations by date, or anything else that might distinguish that run from others.
r
Ram
08/17/2023, 3:19 PMYes just checked but it would be nice if table can store the user it was ran m example if airflow ran the job then its airflow or if any one ran manually in local then it has to be its own user
Ram
08/17/2023, 3:20 PMactually that is from snowflake user id , coz when running from airflow its has its own user id and when people run manually on local its their own user id
Ram
08/17/2023, 3:36 PMi see dbt_user is null in the dbt_invocations table , how to get this populated
example i have dbt running in airflow daily and team run manually in their local machine
So i want to capture the dbt_user to identify who has ran if it is airflow or users
27 Views