Hello all, i’m interrested in the subject, I have similar questions around array, json, jsonb dataype column in Postgres 9.6
So far my experience is unsuccessful in having Dremio (3.1.3 c.e.) import these datatypes without manipulation one side or another.
see Does Dremio supports native json jsonb types in Postgres source?.
As a workaround i build a postgrsql view using (::text) representation of my json column, then using CONVERT_FROM(column,‘JSON’) in Dremio 3.1.3 but it’s expensive operation.
If you have any information, thanks