There are a number of native PostgreSQL data types that seem not to be supported, including JSONB
. Is there an easy way to add JSONB
support, even if it’s just cast to TEXT
?
PostgreSQL supports a wide variety of data types, the easiest method today is to create a view in PG that casts columns of interest to a string type and have Dremio read from the view. This uses PG’s own casting logic and can be used to read the larger number of data types PG supports.