I am using AWS DMS to migrate from SQL Server to DynamoDB. The issue is that when there is a column in my SQL server View that doesn’t have a value to it (ie a blank or null varchar) it removes it from the DyanmoDB row completely, it doesn’t exists rather then the attribute existing and having a blank value to it.
How do you keep blank or null columns in from the source SQL server database? I see DMS has DynamoDb expressions you could possibly use, or maybe a transform rule?
Has anybody come across this before?
It seems like based on this documentation: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.DynamoDB.html#CHAP_Target.DynamoDB.RDBMS2DynamoDB
NULL data from the source are ignored on the target.
This was my issue, I simply changed it from NULL to "NULL" for migration.