Skip to main content
Preview Snowflake semi-structured and structured data functions in Snowflake compatibility mode.

Limitations

PARSE_JSON returns the value as text rather than as a VARIANT. The : path operator, :: casts and json_extract all work on that text, so ordinary path access behaves as expected, but two functions differ: SPLIT, ARRAY_AGG and the ARRAY_* family return a typed array rather than a VARIANT array. The elements are the same; the rendering differs, which matters if a client parses the output text. ARRAY_SLICE is rejected with a negative index, because counting from the end of the array has no direct equivalent. It is also rejected with a computed bound, because the rewrite needs literal bounds.