Missing uuid and jsonb attributes from postgres


I added a postgres database to the sources. I noticed that when I open one of its tables, the attributes with types uuid and jsonb are missing. Of course, I am not able to query them.
Is any of you experiencing the same problem?
Is there a way to solve this issue without changing the types in the original table?
I am using Dremio 3.0 and PostgreSQL 10.0

1 Like

As Dremio currently doesn’t have support for uuid and jsonb types internally, columns with those type are being masked and considered non-queryable.

As a workaround, you can create a view in postgres to convert those columns into their string representation, and use the view instead of the table in your Dremio queries.

1 Like