my stakeholders are requesting that after each model that updates or inserts new data (through merge) into some table, a log table needs to be updated with something like this:

log_table:

TABLE_LOADED    INSERTED_ROWS     UPDATED_ROWS
TAB_1           1500              1000

Any idea on how to approach this? How to identifies maybe with a post hook or a package that counts the inserted rows and updated rows separately?

Thanks