Json with []


I have a column 'Data' as a json, in which I would like to get the "sku" numbers:


First I take what is inside the Stkiten "Data" ->> 'Stkiten', giving me back:


when I try to take from this new column I created (transforming it as a ::JSON), I can't, and I think is because of the '['.

Could somebody help me, please?

Thank you

Hi @Laura.dropp
Metabase currently doesn't support querying JSON blobs via the GUI:
https://github.com/metabase/metabase/issues/708 - upvote by clicking :+1: on the first post
You would have to work in SQL. Try searching the internet or ask in a forum specific to the database type you're using or try stackoverflow.com