Hello everyone! Sorry if this is wrong channel for it but, I am making this post in case anyone else runs into the same error since I couldn't find mention of 'query_max_size' in the documentation. Our DBT jobs started failing during the on-run-end hook with the following error:

19:22:56  Database error while running on-run-end

19:22:56  Encountered an error:

Compilation Error in operation elementary-on-run-end-0 (./dbt_project.yml)

Row to be inserted exceeds var('query_max_size'). Consider increasing its value.

After some digging through Slack I found a thread mentioning the 'query_max_size' variable: https://elementary-community.slack.com/archives/C02CTC89LAX/p1675173737705399 I am not sure if this is an old bug creeping back up again but I ended up resolving the error by adding the following to our dbt_project.yml file vars.

vars:

query_max_size: 1000000

Hey @Ben Fude! Thank you for this note! I see there’s really no documentation for this flag, You can always contribute this if you’d like! If you’re interested there’s a guide here on how to contribute, if I’m not mistaken it should also have information about contributing documentation 🙂