Depending on your setup, Stitch can handle deleted rows in one of two ways:
For hard deleted rows - or rows physically removed from your database - we recommend using full table replication. This will essentially overwrite the table and remove the deleted rows.
To use incremental replication, we recommend using an
updated_at field as the replication key, along with deletion flags. Stitch will be able to grab both updated and deleted rows though rows won't be physically deleted from your data warehouse.
Additionally, if a table is append-only, we recommend using an auto-incrementing ID column as the replication key.