For the trigger to work, it is necessary to alter the table structure to enable change tracking on an existing Azure Database for MySQL tables to use trigger bindings for an Azure function.

In general truncate and reload is the easiest option - for the reason that you don't have to worry about what's changed and any back door updates to the source database will be reflected in the ...