Why can't Amazon Redshift Parse this Valid JSON string?
Ok, per this Redshift forum post this is a know bug, but there is no ETA for a fix. The forum recommends this workaround:
Replace:
json_extract_path_text(event_properties,'someValue')
with
json_extract_path_text(regexp_replace(event_properties,'\\\\.',''),'someValue')