Summary
Error message indicates that there is a compilation error when normalizing tables BLDG and BSQF due to approximate match found in the relations. Suggested solution is to delete or rename the existing tables to avoid ambiguity.
Question
Hey everyone. Really struggling with this issue:
I’m trying to copy over existing tables BLDG and BSQF. I don’t have the option to delete the tables because its backend tables for an ERP system. But when trying to normalize into those tables I’m not able to:
2024-04-10 13:50:11 normalization > Compilation Error in model bsqf (models/generated/airbyte_tables/dbo/bsqf.sql)
2024-04-10 13:50:11 normalization > When searching for a relation, dbt found an approximate match. Instead of guessing
2024-04-10 13:50:11 normalization > which relation to use, dbt will move on. Please delete "IS8099900001"."dbo"."BSQF", or rename it to be less ambiguous.
2024-04-10 13:50:11 normalization > Searched for: "IS8099900001"."dbo"."bsqf"
2024-04-10 13:50:11 normalization > Found: "IS8099900001"."dbo"."BSQF"
2024-04-10 13:50:11 normalization >
2024-04-10 13:50:11 normalization > > in macro materialization_table_default (macros/materializations/models/table/table.sql)
2024-04-10 13:50:11 normalization > > called by model bsqf (models/generated/airbyte_tables/dbo/bsqf.sql)
2024-04-10 13:50:11 normalization > Compilation Error in model bldg (models/generated/airbyte_tables/dbo/bldg.sql)
2024-04-10 13:50:11 normalization > When searching for a relation, dbt found an approximate match. Instead of guessing
2024-04-10 13:50:11 normalization > which relation to use, dbt will move on. Please delete "IS8099900001"."dbo"."BLDG", or rename it to be less ambiguous.
2024-04-10 13:50:11 normalization > Searched for: "IS8099900001"."dbo"."bldg"
2024-04-10 13:50:11 normalization > Found: "IS8099900001"."dbo"."BLDG"
2024-04-10 13:50:11 normalization >
2024-04-10 13:50:11 normalization > > in macro materialization_table_default (macros/materializations/models/table/table.sql)```
<br>
---
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1712758518544679) if you want to access the original thread.
[Join the conversation on Slack](https://slack.airbyte.com)
<sub>
["error", "normalizing-tables", "compilation-error", "relation-match", "delete-tables", "rename-tables"]
</sub>