I have a CDS DMS job and got a validation error mismatch record. It has a datatype mismatch so I knew that was the problem. After fixing the datatype it still did not get solved.

I am currently migrating selected records from sql database to s3 bucket (parquet format) using aws DMS. I wanted to delete migrated records in source database after successful creation of paqrquet file in s3. Any thoughts on how to accomplish this?