DBT-将DBT测试写入我的数据仓库中的特定表

发布于 2025-02-03 05:05:30 字数 267 浏览 2 评论 0原文

下午好, 我想将 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 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(2

橙味迷妹 2025-02-10 05:05:30

好吧,我设法修复了它,我几乎把计算机扔掉了,因为我没有更多的空气可以启动,但是基本上我们可以在dbt_project.yml中指定目标数据库。为此,只需添加到dbt_project.yml,

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

我没有在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

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

白日梦 2025-02-10 05:05:30

我尝试添加模式,但它仅在新模式下创建了表,这是有道理的,需要为其编写一些宏。

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.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文