2개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
1
Hi,
On first issue, to get before-image updates with Kafka, see https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TaskSettings.BeforeImage.html
On issue #2, you could try to remap you jsonb onto a CLOB to see if you get better results. See https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html.
MapJsonbAsClob
By default, AWS DMS maps JSONB to NCLOB. You can specify MapJsonbAsClob to let PostgreSQL migrate the
JSONB type as CLOB.
Example: --postgre-sql-settings='{"MapJsonbAsClob": "true"}'
Best,
Didier
Hi Didier, thanks for the response.
issue 1 is resolved after making the changes you specified.
issue 2, still i see the same issue. now the jsonb columns are showing up in before image , but not in data section. here are my endpoint settings. anything else i can do.
{ "CaptureDdls": false, "DatabaseName": "test", "HeartbeatFrequency": 3, "Port": 5432, "ServerName": "****", "Username": "*****", "MapJsonbAsClob": true }
Thanks,