Summary
When loading Oracle Netsuite data to Postgresql using Airbyte, deleted records are not being handled properly. The user is looking for assistance in identifying deleted records as there is no specific field or column indicating deletions.
Question
Hello @here,
I use the Airbyte community version to load Oracle Netsuite (community) data to my local Postgresql db. While setting up the connection I did not see any settings related to the deleted records. What is happening is that some SalesOrders are deleted from the Netsuite platform but their entries are still in the Postgresql db table. I checked all fields of the salesorder table but did not find any field indicating whether the record was deleted from the platform. Also, the is_deleted column is not present in the tables.
Could you please help us with this issue?
Thanks!
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.