Snowflake PARSE_JSON Function Reference (2026)

Official Snowflake reference for the PARSE_JSON function.

Key facts surfaced (2026-05-19):

• Syntax: PARSE_JSON(<expr> [, '<parameter>']) — converts JSON string to VARIANT.
• Default parameter 's' enforces strict key uniqueness; 'd' allows duplicate keys.
• Returns NULL (not error) for empty or whitespace-only input strings.
• Enables dot-notation access to nested JSON fields in VARIANT columns (e.g., col:field.nested).
• Curriculum reference: composable CDP equivalent of AEP XDM dot-notation field access for GA4 nested JSON normalization (Module 4 / Module 12).