ValidationSettings are not supported for 's3' endpoint

0

we are using Terraform as CICD, I want to migrate a PostgressSQL Database to S3 bucket, I need CDC and Data validation, when I run the terraform, I have this error: ValidationSettings are not supported for 's3' endpoint I don't see anywhere in the AWS documentation that saying S3 endpoint can't do data validation. How to solve this issue? Can I do or not the data validation with S3 as target?

已提問 2 年前檢視次數 729 次
2 個答案
0

While using S3 as the DMS target , validation is not supported. + https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Validating.html

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 LUW

Unfortunately, there is no feature to validate data with S3 as target at this moment. And that's because of the validation works with DMS. 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.

You should think of working on a custom solution to compare the records between PostgreSQL and S3.

AWS
D-Rao
已回答 2 年前
0

AWS Database Migration Service (AWS DMS) now supports validation to ensure that data is migrated accurately to S3.

If data validation is enabled for the migration then validation begins immediately after a full load is performed for a table. In the CDC phase, data validation compares the incremental changes as they occur. During data validation, AWS DMS compares each row in the source with its corresponding row at the target, verifies the rows contain the same data, and reports any mismatches.

Amazon S3 target data validation - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Validating_S3.html

AWS
支援工程師
Arnab_S
已回答 3 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南