dbt found two sources with the same name "XXX"

[idan-margalit]

Hi all :)

I have a python-repo that I am running in oracle (dbt-oracle).
One of the steps it performs is to invoke dbt-run.
When I am developing changes I am running it locally on my machine.
The version of dbt is: dbt-oracle 1.6.0 (dbt-core 1.6.6).
When I run it from Oracle Container Instance it works fine.
When I run it locally I get this error: ' dbt found two sources with the same name "XXX" '
In the error log (attached) it mentions the first model that is referenced in the sources.yml file.
If I change the order of the models in the sources.yml file it mentions a different model in the error - which is now the first model that is mentioned in the sources.yml.
Does anyone know what else can I do to make this error go away?

[idan-margalit]

Ok.
So it turns out that phrasing a question well is 50% of the solution.
Describing it helped me to rethink and identify the problem.
My sources.yml file had more than one parts that had the same schema name.
My fix was to add this field "schema" and give it the actual name of the schema, and I used the "name" field in order to give each part a different name.
So this issue is solved :)