How to do trim columns when loading data using AWS DMS

Question

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?

What is AWS DMS? Are you referring to "RedShift" ? – Geoff Griswald May 19 '21 at 13:30 — Geoff Griswald, May 19 '21 at 13:30
@GeoffGriswald AWS Database Migration Service – Rajesh May 19 '21 at 15:53 — Rajesh, May 19 '21 at 15:53

Theofanis · Answer 1 · 2021-05-26T16:22:26.483

0

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.

edited May 26 '21 at 16:22

answered May 26 '21 at 16:15

Theofanis

303
2
5

How to do trim columns when loading data using AWS DMS

1 Answers1