Convert Varchar to json Array

Hi, the question is pretty simple.
I’m querying a parquet PDS, which has a column that looks like this:

empty text
empty text
empty text
'[ { "isActive" : true, "partner" : { "$oid" : "928jf983jf9020" }, "Types" : [ 2.0, 5.0 ], ... },{...}]'

It is a varchar, I want to convert it to a JSON array.

I’ve tried:

CONVERT_FROM(table.column,'JSON') as json_array 
from table



What are possible workarounds to this situation?

There seems to be some kind of incompatibility with parquet’s text datatype and the JSON converter.
I’ve tried the same thing with dremio’s native text datatype and a CSV PDS, it works fine.
So, the workaround would be to convert the text datatype to dremio’s native (either by binary or whatever)
and then convert it to JSON.

(Oh, and the JSON conversion also doesn’t work for VDS, because when querying a subquery, it cannot know the original SCHEMA).