dbt - 运行 dbt 种子时出现 "Tried to resolve a name to a reference that was unknown to the frame"错误

Question

数据库版本:0.20.1数据库:postgresql代码:https://github.com/josephmachado/simple_dbt_project

运行命令“dbt seed”时，出现错误:

Unhandled error while executing seed.tutorial.customer
Tried to resolve a name to a reference that was unknown to the frame ('column')
19:17:41 | 1 of 3 ERROR loading seed file tutorial.customer..................... [ERROR in 3.61s]
19:17:41 | 3 of 3 START seed file tutorial.state................................ [RUN]
Unhandled error while executing seed.tutorial.state
Tried to resolve a name to a reference that was unknown to the frame ('column')
19:17:41 | 3 of 3 ERROR loading seed file tutorial.state........................ [ERROR in 0.23s]
Unhandled error while executing seed.tutorial.orders
Tried to resolve a name to a reference that was unknown to the frame ('column')
19:17:51 | 2 of 3 ERROR loading seed file tutorial.orders....................... [ERROR in 14.37s]
19:17:51 |
19:17:51 | Finished running 3 seeds in 14.96s.

Completed with 3 errors and 0 warnings:

Tried to resolve a name to a reference that was unknown to the frame ('column')

Tried to resolve a name to a reference that was unknown to the frame ('column')

Tried to resolve a name to a reference that was unknown to 

the frame ('column')

我缺少任何设置吗？

Answer 1

你是如何安装 Jinja2 的？它应该是旧版本 2.x 通常，当您安装 dbt 包时，jinja 会附带正确的(旧)版本作为依赖项。根据命令检查你的神社版本:

pip freeze > temp.txt

如果它不是 2.x，您必须处理它。