Snowflake provides a number of JSON related functions to convert string (varchar) to JSON object and extract JSON values from the object or flatten nested array, etc.
The code snippet shows an example of flattening the following JSON string using lateral flatten:
{
"a":"a",
"b":[
{
"c":"c1",
"d":[
1,
2,
3,
4,
5,
6,
7
]
},
{
"c":"c2",
"d":[
10,
20,
30,
40,
50,
60,
70
]
}
]
}