Question
Why are deleted records not removed from the warehouse?
Environment
Connector: Quickbooks
Answer
Check the Quickbooks Features documentation to confirm if your table captures deletes.
See the Cause section below.
Cause
The Quickbooks connector only captures deletes for the table mentioned in https://fivetran.com/docs/applications/quickbooks#features. If there is a record identified as being deleted in Quickbooks, the _fivetran_deleted
column will be updated to true.
QuickBooks API does not support permanently removing objects. Instead there is an "ACTIVE" column in the following tables, which is used for marking deleted/inactive records. More info on tables effected by this at: https://fivetran.com/docs/applications/quickbooks#deletedrows.