Add primary key information in a DMS CDC event.

What are you trying to achieve: detect if the PK of a given row is among the data that was updated?

AFAIK, for sake of efficiency, cdc does not supply structural information like PK in its updates. It is something that you have to manage on the receiving end: you can for example create a trigger on this receiving table. This trigger executes the specific action that you want when the PK is about to be updated: this trigger could even refuse the update if such is your purpose or do anything else you need when PK is updated.

Hello, Your question is not clear. I am assuming you would like to add a column value which can behave like primary key. But CDC is possible if you have primary key or unique key (without Nulls) on the table.

Below is one of the blog which talk about one of the dms feature to manipulate data which is getting replicated. https://aws.amazon.com/blogs/database/data-masking-using-aws-dms/

Hope this can help. Thanks JItender