Meltano

Screenshot 2023-07-24 at 1.41.57 PM.png

among other queries, a delete query is also run, why ? and how can I change it,

You're using `LOG_BASED` replication method and here in <https://github.com/transferwise/pipelinewise-tap-mysql/blob/a9d18f35bac109c37d866c8509ed2c9e5b3be431/tap_mysql/sync_strategies/binlog.py#L757|tap> It's looking for delete events as well. Can you try `INCREMENTAL` instead?

How to disable delete events while using Log based replication, any idea ?

Also, this was initial sync which is done by running query therefore no point of delete event here

There is no option in tap so you can fork it and make the changes