DMS data validation

Unfortunately, there is no feature to validate data with S3 as target . Whenever you try to compare records between any source and target using DMS, DMS runs a SELECT query on both Source and Target, and then compares the values retrieved from both ends. Since its not possible on S3 to run a SELECT query for comparison as its not a database, validation is not supported with S3 as target.

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Valida You can only use validation, when you use AWS DMS with the below endpoints as Source or Target:

Oracle PostgreSQL-compatible database (PostgreSQL or Amazon Aurora PostgreSQL) MySQL-compatible database (MySQL, MariaDB, or Amazon Aurora MySQL) Microsoft SQL Server IBM Db2 LUWting.html

It should be possible with DMS 3.5.1 https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Validating_S3.html