Truncate table before insert


We have a third-party service where we manage some entries (bookings of our team), and need to keep it in sync with our database.
We have a Parabola flow that fetches those changes and upserts them into our DB, which works fine for new entries / entry changes, but doesn’t work when the entry is deleted.

Is it possible to run some kind of delete all / truncate step before inserting our data?


Ok, the solution we’ve found is to fetch all items from DB, mark them as ‘deleted’, then run the Upsert job marking all non-deleted entries as such.