https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html
I faced a problem while migrating a PSQL instance. It says that the format of json is invalid and the string input is ended unexpectedly. I could not believe it, since the data on the source instance was truly valid.
While debugging it, I found a stackoverflow post regarding this. I was advised to check the DMS configuration in terms of LOB. It says that the data type difference exists between PSQL and DMS.
Referring to the above table, DMS deals with JSON on PSQL as LOB(Large binary objects). It means that a type casting happens during a migration. In addition, the key point was - there is a maximum limit of size on each LOB object.
After I adjusted it, it worked successfully.
Author: Sin-Woo Bang