adapter_response in run_results.json always blank for dbt run in Snowflake

Question

I am looking for the query_id and other snowflake metadata (rows returned, etc) from a dbt run.

I see that adapter_response exists in the run_results.json to return this stuff from a database, but I cannot find any examples of it and Snowflake never returns anything.

This is the same for both snapshots and models.

Is there some configuration setting I'm missing either in Snowflake or dbt?

Answer 1

The query_id was only added to the adapter_response for Snowflake in adapter v1.1 (see release notes and the associated PR). You will have to upgrade to dbt-snowflake 1.1.0