How to parse JSON in Snowflake

Example:

select parse_json(json_column):json_field
from foo.bars
;

This is useful for analyzing semi-structured data that happens to be stored as JSON.

Resources:

• JSON Data Parsing in Snowflake
• PARSE_JSON Snowflake Documentation
• GET_PATH , : Snowflake Documentation