Hi team, I am using airbyte to create a datapipeline from to trasfer data from Postgres to Clickhouse.
At that time, one table sync is getting failure due to dbt normalization. It is throwing the error like, id column is having duplicate values, due to that, dbt couldn't able to create the incremental model. But checked in the source DB, there is no duplicates in that particular column. Also that column is auto incremented column.
Requesting airbyte team and others to fix this issue.
Can anybody have suggestions and inputs, please share?
@Andy Yeo (Airbyte) @Davin Chia (Airbyte) @Davin Chia (Airbyte) @Andy Jih (Airbyte)