We have a table with a field which is a json string, and the structure of the json is complex with multiple levels of nesting, and also the structure is not uniform across rows. We would like to be able to extract json path expressions (e.g., extract_json_path(str,‘$.topLevel.nextLevel.field’) as strings instead of using convert_from(str,JSON) as this is trying to apply a fixed structure across all rows and is failing in case of any differences.
1 Like
Please shard a example of your data, also error that you mention, include query profile