Why are deleted records not removed from the warehouse?
Check the Quickbooks Features Documentation to confirm if your table captures deletes.
See the Cause section below.
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.