The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a MongoDB source and an Amazon Redshift target:
MongoDB Source Data Type
Amazon Redshift Target Data Type
document(2147483647)
super
id(32)
character varying(128)
Note:
For a MongoDB source,
Database Ingestion and Replication
creates two columns on the target: an ID column, which provides an identifier similar to a primary key, and a Document column, which contains a JSON object containing an entire MongoDB record. Therefore, the mappings show the target data type associated with each of these columns.