[ https://issues.jboss.org/browse/TEIID-2848?page=com.atlassian.jira.plugin... ] Ivan Chan commented on TEIID-2848: ---------------------------------- Yes, Object[] is a good solution. And maybe you guys can also consider to provide 2 different ways to handle mongoDB array object. 1. map mongoDB array to java object array 2. flatten the data to create separate column for each array element (similar to unwind): CREATE FOREIGN TABLE Sample ( CustomerId integer PRIMARY KEY, name varchar(25), array_0 varchar(25), array_1 integer, array_2, timestamp, array_3, integer, num varchar(6), ) OPTIONS(UPDATABLE 'TRUE'); -- This message was sent by Atlassian JIRA (v6.2.3#6260)