Minimize time without data in destination tables during "Full Refresh/Overwrite"

[nak7289]

We are setting up AirByte to perform “full refresh/overwrite” on each table in our configuration due to issues getting CDC to work reliably. The goal is to minimize the time that these refreshed tables in the destination have no data. In the past when “full refresh/overwrite” is run, it clears out the destination table and then inserts the data back in. During the loading phase, tables are without data leading to downstream errors.

I have two questions:

What is the best practice to perform a full reset that best minimizes downtime?

Is there a way to full refresh these tables one-by-one in order to limit the unavailability of the source data while it is being written to the destination?

Thanks in advance