Amazon web services – In AWS redshift, the json_extract_path_text function return empty string instead NU
In AWS Redshift, I am using json_extract_path_text function to parse simple Json. I deliberately try to find non exists element in the Json so the function should return NULL. If I use the function in 'standalone' select, the function return…