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 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.