Querying JSON array in Redshift?
You could use nested JSON functions:
json_extract_path_text( json_extract_array_element_text( json_extract_path_text( myjson, 'sort_details' ), 0 ), 'sort_by')
JSON_EXTRACT_PATH_TEXT(myjson, 'sort_details', 0, 'sort_by')This also works, but it's not documented in AWS Doc