Json with []

Hello,

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

{"ware":"AA","Stkiten":[{"sku":"1","requested":1,"available":0},{"sku":"2","requested":1,"available":0}]}

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

[{"sku":"1","requested":1,"available":0},{"sku":"2","requested":1,"available":0}]}

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