By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

DMS supports Super type for Redshift target with MongoDB source

0

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?

Topics
Migration & ModernizationAnalytics
Tags
AWS Database Migration ServiceAmazon Redshift
Language
English
AWS-User-3873036
asked 2 years ago654 views
1 Answer
0

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.

profile pictureAWS
EXPERT
Sohaib Katariwala
answered 2 years ago
  • AWS-User-3873036
    2 years ago

    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)

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content