Summary
When deleting a record in the source MongoDB database, it is also deleted in the target BigQuery. User wants the record to remain with the field ‘ab_cdc_deleted_at’ active in the target database.
Question
Hello community !
Im using Airbyte v0.63.3 with UI.
I configured a connection with mongoDB as source and bigquery as target with incremental append + deduped.
The issu is when I delete a record in the source database, the record is deleted in the target bigquery.
I would like the record not to disappear but the field ab_cdc_deleted_at
to be active.
In the target bigquery database all records has the field ab_cdc_deleted_at
set to null.
Thank you for your time and help !
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.