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.