Currently you have to unnest JSON see this related question How to import JSON with nested array
If you can unnest the JSON before importing you can use the parseJson - Amazon QuickSight within DataPrep like this.
Example:
parseJson({jsonfield},'$.dict.name')
