How to do trim columns when loading data using AWS DMS

0
votes

I have to migrate tables using AWS DMS. While loading I have to trim the columns in source table and load it to target. I was not able to find any transformation rule for trim in AWS DMS. How it can be achieved?

1
aws-dmsdms
What is AWS DMS? Are you referring to "RedShift" ? – Geoff Griswald
@GeoffGriswald AWS Database Migration Service – Rajesh

1 Answers

0
votes

Could you perform a remove-prefix and remove-suffix as a means to trim your data? Guide on how to do that here.

Alternatively you can trigger a Lambda to do trimming, every time new data are added to your target location.