Need help for this question please


please help if possible. i am trying to split this dictionairy {“status”: “completed”, “source”: {“country”: “US”, “state”: “CA”, “zip code”: 000000}, “paid”: false"} into smaller pieces.
Does anyone know what function to use here? I would like to only split the “CA” so i just want to have “CA” in a column.
I tried using the SELECT SPLIT() function but i seem to be off.
Does anyone know another way maybe?

please and thank you