How to use parse_json in redash i have try multiple function but they don't help on redash

parse_json(xyz):data:“search value”::string as filed

What database are you using? Not all databases support parse_json.