AWS DMS table mapping remove specific columns and rename
0
votes
0
answers
49
views
I'm trying to run AWS DMS with specific table mapping where I have my source table, then I want to rename the table to a new name that matches the target table name as well as not migrate certain columns that I don't need anymore and don't want in the target table. How can I do that?
I tried this but it doesnt't work. Is this the correct approach?:
{
"rules": [
{
"rule-type": "selection",
"rule-id": "1",
"rule-name": "select-team_assignments",
"object-locator": {
"schema-name": "source_schema",
"table-name": "proj_team_assignments"
},
"rule-action": "include"
},
{
"rule-type": "transformation",
"rule-id": "2",
"rule-name": "rename-table",
"rule-action": "rename",
"object-locator": {
"schema-name": "source_schema",
"table-name": "proj_team_assignments"
},
"value": "team_assignments"
},
{
"rule-type": "transformation",
"rule-id": "3",
"rule-name": "drop-columns",
"rule-action": "remove-columns",
"object-locator": {
"schema-name": "source_schema",
"table-name": "proj_team_assignments"
},
"value": [
"team_relation_type",
"issue_tracking_id",
"analysis_skills",
"communication_oral",
"coaching_others",
"problem_solving",
"written_communication",
"standard_work_mgmt",
"recommendation_synthesis"
]
}
]
}
Also do column types have to match one to one or can they be a bit different in terms of like instead of text I want a json field for that or instead of int, I want a string?
Thanks!
Asked by Foobar
(1 rep)
May 6, 2025, 11:35 PM