Truncate table before insert

Ask a question
1

Greetings!

Problem:
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?

Thanks

2

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.