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 Fivetran Documentation. If there is a record identified as being deleted in Quickbooks, the _fivetran_deleted column will be updated to true.
The 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 affected by this can be found in our Documentation.