'In superset, how do I exclude results where my field contains {} values?

In superset I have a NullType field unappliedcodes that has some values that look like {"BLAH":"Some info"} and others look like {}

My goal is to exclude the {} entries and I have tried WHERE NOT unappliedcodes = '{}' and it does not work.

How do I exclude {} from my results?

Note: our data source is prestodb



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source