Replicate PostgreSQL View As Source and DynamoDB as Target Using Amazon DMS

Viewed 33

I am trying to migrate PostgreSQL view to a DynamoDB table using Amazon DMS. Here's my table mapping for the DMS task:

    {
        "rules": [
            {
                "rule-type": "selection",
                "rule-id": "1",
                "rule-name": "1",
                "object-locator": {
                    "schema-name": "schema-name",
                    "table-name": "view-name",
                    "table-type": "view"
                },
                "rule-action": "include"
            },
            {
                "rule-type": "object-mapping",
                "rule-id": "2",
                "rule-name": "TransformToDDB",
                "rule-action": "map-record-to-record",
                "object-locator": {
                    "schema-name": "schema-name",
                    "table-name": "view-name"
                },
                "target-table-name": "dynamodb-table",
                "mapping-parameters": {
                    "partition-key-name": "pk",
                   
                    "attribute-mappings": [
                        {
                            "target-attribute-name": "pk",
                            "attribute-type": "scalar",
                            "attribute-sub-type": "string",
                            "value": "${col1}-${col2}"
                        }
                    ]
                }
            }
        ]
    }

The task completes successfully but no records are created in DynamoDB table. No errors in CloudWatch logs either.

Thanks for your help.

0 Answers
Related