By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 1
| json_build_object |
|---|
| {"channel": "mobile", "country": "GB", "profile_groups": [{"profiles": ["profileA", "profileB"], "negativeProfiles": ["negativeA"]}, {"profiles": ["profileC"], "negativeProfiles": null}]} |
SELECT 1