Add primary key information in a DMS CDC event.

0

We are streaming the CDC data using DMS and clients are consuming it. While consuming the DMS event, clients are unable to identify primary key in a DMS event. Do we have any transformation rule of DMS which can add primary key automatically to the DMS event?

3개 답변
0

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

profile pictureAWS
전문가
답변함 일 년 전
  • No we want to get the PK information for a row in the meta data info of DMS event irrespective of the operation.

0

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.

profile pictureAWS
전문가
답변함 일 년 전
0

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

AWS
답변함 일 년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠