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.