It may be possible to use AWS DMS for your case but you may be better off using a Stored Procedure or an ETL tool (if you are already using one) instead.
The ideal tool will depend on factors such as
- Is the source and target PostgreSQL instance the same?
- Is this a one-time or an ongoing process?
- Are the smaller tables a subset of the rows of the larger tables? Or is it a subset of the columns? Or is it a more complex logic?
- Are you already using AWS DMS for something else or are you planning to introduce DMS just for this activity?
Split one table into multiple tables using AWS DMS?asked 23 days ago
Multiple tables in one Data Pipeline?Accepted Answerasked 2 years ago
Lambda that parses data into attributes?asked 7 months ago
Cognito User Attributes Modified Lambda Triggerasked 2 months ago
Component Reflect custom attributes?Accepted Answerasked 5 years ago
Unable to map AWS SSO Attributes to SAML Assertion valuesAccepted Answerasked a year ago
How do you get custom Cognito Attributes into Amplify Back-End?asked 10 months ago
WorkDocs Error - "Missing Attributes. This page requires several GET attributes and/or cookies to be set"asked 6 months ago
Accessing an event's attributes in Pinpoint template through front-end using Amplify JSasked 9 months ago
Cognito Identity Pools Attribute-based access control - dynamic attributesasked 10 months ago