Amazon web services – AWS Redshift SQL – How to check if a Json object has values in it?
1/ I am using SQL on AWS and trying to detect quickly when a Json object has key-value in it. Anyone knows it? Thanks For example: A. {"context":{"abc":"123"} --> Yes B. {"context":{}} --> No Note that I don't know in…