Unable to normalize into existing tables in MS-SQL

[rubenatterbury]

Hi everyone.
I've been using Airbyte a ton for EL purpose between Postgres, Clickhouse and MS-SQL Server databases and although there's been the odd hiccup here and there, it's pretty much been smooth sailing.

Now we are busy with a complicated ERP migration and I'm trying to port information from a current Postgres database to our new MS-SQL server database for the ERP. The tables all exist in the new database and are empty, but have an existing structure and relations.

Specifically I was trying to put into the BLDG and BSQF tables via Airbyte and I went to great lengths to ensure the order of columns, length of columns, data type and everything match perfectly but now I'm encountering a normalization issue:
Completed with 2 errors and 0 warnings: 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)

Does this mean that Airbyte cannot load into existing tables at all? I can't delete the tables because they're part of the ERP (although they are empty).

[merttkarabulut]

I am encountering the same issue. It seems like airbyte cannot normalize the data into an existing table in MS SQL Server database.