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?
asked a month ago12 views
1 Answers
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.
answered a month ago
Relevant questions
MongoDB Atlas vs DocumentDB
asked 3 months agoDMS not replicating addition of new columns to source
asked 5 days agomongoDB atlas scaling with AWS regions
asked 3 years agoDMS - How to retain non-ASCII values when running DMS task from MySQL source to Redshift target
asked a month agoWhich version of MongoDB driver supports 'ssl_ca_certs' parameter in URI?
asked 2 years agoDMS Sync Issues with nullable column and new columns
asked 5 months agoSyncing external mongodb database info with neptune database
asked 2 months agoCan DMS do mapping that is not simply 1-1 from source to target?
Accepted Answerasked 3 days agoHow to use the super type as a JSON-containing argument to a procedure and use the JSON elements in a FROM clause of a SELECT
asked 5 months agoDMS supports Super type for Redshift target with MongoDB source
asked a month 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)