我在dbt项目"base“、"table_1”、"table_2“、”table_3“中有一个子查询列表.

我想加入到一个共同的专栏，id。

我想通过使用for循环宏来避免重复。我的问题是，当我试图引用{ref}}中的子查询名{sub}}时，会出现语法错误。

这是我试过的密码。

{% set subs = ["table_1", "table_2", "table_3"] %}
SELECT
{% for sub in subs %}
    {{sub}}.* EXCEPT (id),
{% endfor %}
base.*
FROM {{ref('base')}} as base
{% for sub in subs %}
    LEFT JOIN {{ref({{sub}})}} as {{sub}}
    ON {{sub}}.id = base.id
{% endfor %}

我得到一个语法错误

expected token ':', got '}'

如果我改变到

LEFT JOIN {{ref("'"{{sub}}"'")}} as {{sub}}

我知道这个错误

expected token ',', got '{'

最后用

LEFT JOIN {{ref("{{sub}}")}} as {{sub}}

我得到了

Model depends on a node named '{{sub}}' which was not found

以下是我读过的几页，但找不到解决办法

Using a string as an argument in a Jinja macro in dbt

https://docs.getdbt.com/reference/dbt-jinja-functions/ref