DBT-将DBT测试写入我的数据仓库中的特定表
下午好, 我想将 dbt Test 值写入我的数据仓库中的特定表。 我已经在所有可能的文件中都测试了多个模式包含物,但我并没有真正找到正确的位置来指定我希望记录测试的数据库。 如今,它总是带着没有执行A glue的权限的错误来回答我:CreateAtabase Action实际上不是我想做的,而是我指定的表。 总而言之,我在这里问的是如何指定DBT测试结果的编写位置,而不是让DBT创建和存储值在默认模式中? 如果有人可以帮助我,我真的很感激!
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!
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
好吧,我设法修复了它,我几乎把计算机扔掉了,因为我没有更多的空气可以启动,但是基本上我们可以在dbt_project.yml中指定目标数据库。为此,只需添加到dbt_project.yml,
我没有在DBT文档中找到任何信息,也不是社区论坛,所以这只是测试可能方法的迭代过程
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
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.