Hello everyone! I am getting this message: Additio...
# replication-troubleshooting
j
Hello everyone! I am getting this message: Additional Failure Information: When searching for a relation, dbt found an approximate match. Instead of guessing which relation to use, dbt will move on. Please delete "CIMED"."PUBLIC"."order", or rename it to be less ambiguous Someone can help me?
n
Hi Joviano! Could you provide your full logs?
j
The error occurred when creating new connection that does the same that the other connection but with a different source. I had a connection that replicated some tables including that and I created a new connection with the same target table but a different source.
n
I see the error you're referring to:
Copy code
ompilation Error in model ORDER (models/generated/airbyte_tables/PUBLIC/ORDER.sql)[0m
2023-01-26 21:55:36 [42mnormalization[0m >   When searching for a relation, dbt found an approximate match. Instead of guessing 
2023-01-26 21:55:36 [42mnormalization[0m >   which relation to use, dbt will move on. Please delete "CIMED"."PUBLIC"."order", or rename it to be less ambiguous.
2023-01-26 21:55:36 [42mnormalization[0m >   Searched for: CIMED.PUBLIC.ORDER
2023-01-26 21:55:36 [42mnormalization[0m >   Found: "CIMED"."PUBLIC"."order"
Could you try renaming the 'order' table? Looks like it's looking for
ORDER
but finding
order
👍 1
j
Thank's @Nataly Merezhuk (Airbyte) with fresh mind today I have observed this thing.
u
Let me know if you need any other help!