Is there a way to load "multiple dimensions" of JSON data into flex tables efficiently?
Say I have a JSON file that has JSON structure within JSON structure. Is there a current way to get all of that JSON data into flex tables efficiently? Basically I'd want to create one main table for the highest level of json data then dimension tables for x inner json data. I have an algorithm thought up that I think would accomplish this but I wanted to ask before implementing an algorithm in case Vertica already has a way to do it. Note that I'm not adding an example b/c the point is to generalize the process of loading json data into flex tables. However, I will give a situation that I came across that was not satisfying (this is motivating my question).. I loaded a json file into a flex table but one of my columns did not parse the json data (the column still had json structure) b/c this was an inner-level of json structure. I hope this question makes sense and thanks in advance.