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...
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.
Chloe Bennett explores the intersection of pop culture, streaming entertainment, digital trends, and contemporary lifestyle. Her weekly commentary reaches thousands of culture enthusiasts.
