Logging query id for failures

[u.bhatt]

The results.json captures the query id for successful model runs for snowflake materializations. However we don’t get the query id for failures. Is it possible to get the query id for failures ; if so how can we proceed ?

[Surya]

For failures u will not see query id in run results.json because dbt adds query id to the run_results.json only for successfully executions.

dbt logs query id in dbt.log file for failed executions.

U have to check the dbt.log file for queryid

[u.bhatt]

Could link to some reference/documentation for the same?

[Surya]

@u.bhatt
here is the GitHub issues which talked abt it

[CT-704] [CT-703] [Feature] Display the Query ID in the printed logs when dbt runs