DBT调用带有列表参数的后钩子宏

Question

我试图调用宏作为后钩子。问题是(我认为)我想传递一个列表到这个宏…知道这是怎么回事吗?我的理论是，我正在传递一个列表类型的参数。

-- models/table.sql
{{
config(
materialized = 'table',
post-hook = "{{ my_macro(this,'my_str', ['foo', 'bar']) }}"
)
}}
SELECT * FROM muh_tayble;

-- macros/my_macro.sql
{% macro my_macro(relation, string, list) %}
BLAH
{% endmacro %}

错误消息

Encountered an error:
Compilation Error in model table (models/table.sql)
invalid syntax for function call expression
line 2

Answer 1

新手犯的错误。用post-hook代替post_hook。问题解决了