Lets try to understand these functions with practical examples.
- When we fetch the JSON value without any parsing. Observe the output of the v_jsonval.
- Now comment the first part and enable the JSON.PARSE and observe the output.
A table gets created with JSON values.
In the end, someone can ask why we need these JSON.parse () and JSON.stringify() and we can achieve this with simple approach like this:
But I wanted to highlight above functions w.r.t to Snowflake Scripting procedure. We can follow above procedure as well.