DMS supports Super type for Redshift target with MongoDB source

For MongoDB collections that have documents with multiple nested-level, if use table mode will create a lot of columns, and if use document mode _doc field with a maximum varchar length is very limited. Is it possible to use Super type for the top-level fields in MongoDB or _doc field?

主題

遷移與現代化分析

標籤

AWS Database Migration Service Amazon Redshift

語言

English

AWS-User-3873036

已提問 2 年前檢視次數 666 次

1 個回答

最新
最多得票
最多評論

這些答案是否有幫助？支持正確答案，以幫助社區從您的知識中受益。

I have used DMS to create the initial table for MongoDB to Redshift migration using SUPER datatype in the target table. I just manually created the target table with SUPER and let DMS load it successfully.

專家

Sohaib Katariwala

已回答 2 年前

AWS-User-3873036
2 年前
Yes, I already did it. But if there are any changes from the source then it will be not replicated to the destination (Update cases)

DMS supports Super type for Redshift target with MongoDB source

相關內容