So, this is a bit misleading as the status shows success, but the sink has not completed/committed the batched changes. Due to performance reasons, it was taking 2.5 hours to insert the 720k+ records, but was still indicating success. Seems the status should have remained "in progress" until the sink was complete.