Hi 👋 is it correct that a MySQL (or other JDBC) destination with full refresh overwrite will truncate and then insert into the destination table? As opposed to doing something like insert into a tmp table and switch the tables atomically. If it’s correct, does this happen in one or two transactions? Context: I need to export data to MySQL and there’s a strict zero-downtime requirement, which is violated if the connector truncates and inserts in two transactions.

That's right, we truncate and copy. Both are done in a transaction. See here.

Thanks! That’s good news.