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 数据库迁移服务 Amazon Redshift

语言

English

AWS-User-3873036

已提问 2 年前665 查看次数

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

相关内容