[Question] How can I query a JSON field from Superset?

[almirb]

Hello!

Our OpenDistro has a field with JSON content. How can I filter the JSON values of this field using queries in Superset?

The field looks like:

{ "browser" : "Android", "device_vendor": "Samsung" }
{ "browser" : "Safari", "device_vendor": "Apple" }

And I want to filter all rows that are belonging to Android or iOS.

PS.: In PostgreSQL, we usually filter them with: and my_field ->> 'browser' = 'Android'. But It didn't work when querying OpenDistro.

Thanks!