I need help in splitting the below data into a table. I need to do that in snowflake. What would be the SQL for splitting this data format into multiple columns in the form of a table?
I just can't figure out how to do it.
data:
{"{"Locale": "England", "CourseId": "882d3d41-ab18-a87d-0b10-7d2ee0af95cf", "Currency": "GBP", "FeeState": "Provisional", "CourseFees": "9250", "AcademicYear": "2023", "CourseOptionId": "8391ff2c-8a16-4b5b-a1f4-2352fcf79b96", "FeeDurationPeriod": "Year 1"}","{"Locale": "Northern Ireland", "CourseId": "882d3d41-ab18-a87d-0b10-7d2ee0af95cf", "Currency": "GBP", "FeeState": "Provisional", "CourseFees": "9250", "AcademicYear": "2023", "CourseOptionId": "8391ff2c-8a16-4b5b-a1f4-2352fcf79b96", "FeeDurationPeriod": "Year 1"}","{"Locale": "Scotland", "CourseId": "882d3d41-ab18-a87d-0b10-7d2ee0af95cf", "Currency": "GBP", "FeeState": "Provisional", "CourseFees": "9250", "AcademicYear": "2023", "CourseOptionId": "8391ff2c-8a16-4b5b-a1f4-2352fcf79b96", "FeeDurationPeriod": "Year 1"}","{"Locale": "Wales", "CourseId": "882d3d41-ab18-a87d-0b10-7d2ee0af95cf", "Currency": "GBP", "FeeState": "Provisional", "CourseFees": "9250", "AcademicYear": "2023", "CourseOptionId": "8391ff2c-8a16-4b5b-a1f4-2352fcf79b96", "FeeDurationPeriod": "Year 1"}","{"Locale": "Channel Islands", "CourseId": "882d3d41-ab18-a87d-0b10-7d2ee0af95cf", "Currency": "GBP", "FeeState": "Provisional", "CourseFees": "9250", "AcademicYear": "2023", "CourseOptionId": "8391ff2c-8a16-4b5b-a1f4-2352fcf79b96", "FeeDurationPeriod": "Year 1"}","{"Locale": "Republic of Ireland", "CourseId": "882d3d41-ab18-a87d-0b10-7d2ee0af95cf", "Currency": "GBP", "FeeState": "Provisional", "CourseFees": "9250", "AcademicYear": "2023", "CourseOptionId": "8391ff2c-8a16-4b5b-a1f4-2352fcf79b96", "FeeDurationPeriod": "Year 1"}","{"Locale": "EU", "CourseId": "882d3d41-ab18-a87d-0b10-7d2ee0af95cf", "Currency": "GBP", "FeeState": "Provisional", "CourseFees": "17500", "AcademicYear": "2023", "CourseOptionId": "8391ff2c-8a16-4b5b-a1f4-2352fcf79b96", "FeeDurationPeriod": "Year 1"}","{"Locale": "International", "CourseId": "882d3d41-ab18-a87d-0b10-7d2ee0af95cf", "Currency": "GBP", "FeeState": "Provisional", "CourseFees": "17500", "AcademicYear": "2023", "CourseOptionId": "8391ff2c-8a16-4b5b-a1f4-2352fcf79b96", "FeeDurationPeriod": "Year 1"}"}
Table:
