Good afternoon, I need to write the dbt test values to a specific table in my data warehouse. I've examined multiple schema inclusions in the entire imaginable .yml information and It's not that i am in reality finding the right kind position to specify to which database I would like the checks to be recorded. Nowadays, it at all times solutions me with the error of not having the permissions to carry out a glue:CreateDatabase action, which in fact is not what I would like to do, but moderately write to table specified by me. To conclude, what I am asking here is how can I specify the place the dbt tests results are being written, as an alternative of letting dbt create and store the values in the default schemas? If anyone may just assist me on this I might really admire it!
12 Answers
Well, I managed to repair it, I used to be virtually throwing my pc away, as a result of I did not have extra air to pull off, but principally we will be able to specify the objective database in the dbt_project.yml. To do that, simply upload to the dbt_project.yml
tests: +store_failures: true +schema: "path that you want" I did not in finding any knowledge in dbt documentation, neither community boards, so it was simply an iterative process of trying out possible approaches
5I tried to upload schema however it handiest created the tables beneath the new schema, and it makes sense, need to write some macro for it.
ncG1vNJzZmirpJawrLvVnqmfpJ%2Bse6S7zGiorp2jqbawutJobmtsZWWAeoKOnZmtZaentrWxjJ2ZrWWkmsC1edKtpqudXZuuqrjUq5ysZaSkeqJ50qmcnKGWnrBuwMCbo55lmaN6rsWMnZitmV2srrOxx6isrJ0%3D