Yp Xie
09/08/2022, 5:59 AMdbt found two resources with the name "tablename_ab1". Since these resources have the same name,
dbt will be unable to find the correct resource when ref("tablename_ab1") is used. To fix this,
change the name of one of these resources:
- model.airbyte_utils.tablename_ab1 (models/generated/airbyte_ctes/database1/tablename_ab1.sql)
- model.airbyte_utils.tablename_ab1 (models/generated/airbyte_ctes/database2/tablename_ab1.sql)
I know why this error happens, because I have 2 different tables, they are in 2 different source databases, but with the same tablename, so Airbyte use the same model name, which confuses dbt. so how can I solve this kind of error? please help me, thanks!