DBT - write dbt test --store-failures to a specific table in my data warehouse

Good afternoon, I want to write the dbt test values to a specific table in my data warehouse. I have tested multiple schema inclusions in all the possible .yml files and I am not really finding the correct place to specify to which database I want the tests to be recorded. Nowadays, it always answers me with the error of not having the permissions to perform a glue:CreateDatabase action, which in fact is not what I want to do, but rather write to table specified by me. To conclude, what I am asking here is how can I specify where the dbt tests results are being written, instead of letting dbt create and store the values in the default schemas?If somebody could help me on this I would really appreciate it!

2 Answers

Well, I managed to fix it, I was almost throwing my computer away, because I didn't have more air to pull off, but basically we can specify the target database in the dbt_project.yml. To do that, just add to the dbt_project.yml

tests: +store_failures: true +schema: "path that you want"

I did not find any information in dbt documentation, neither community forums, so it was just an iterative process of testing possible approaches

I tried to add schema but it only created the tables under the new schema, and it makes sense, need to write some macro for it.