Sample Header Ad - 728x90

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