noorbasha534
Valued Contributor II

@minhhung0507 as per documentation -

'The actual physical removal of deleted rows (the "hard delete") is deferred until the table is optimized with OPTIMIZE or when a VACUUM operation is run, cleaning up old files.'

So, based on this, try to optimize the table once the data load finishes & verify metrics in the next run.