There is an easier way to do it, in the Query Editor on the column you want to read as a json:
- Right click on the column
- Select Transform>JSON
then the column becomes a Record that you can split in every property of the json using the button on the top right corner.
