How to mask PII data using DMS without adding a column


I am replicating data from source db to target db within two different AWS accounts. I want to mask and replicate the column data to target db during ongoing replication in same column which contains PII data. I am using transformation rules for this but unable to do it. Because I don't want to add new column and delete the old one which contains PII data. Can anyone suggest me how to achieve this?

asked a month ago98 views
1 Answer


this blog post describes a solution to your need:



profile pictureAWS
answered a month ago
  • Hi Didier, Thanks for answering my question but this blog post is not helping me to achieve my goal. Because it doesn't have any approach to mask the replicated column data in real time in same column. Do you have any other solution for this?

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions