Semi-structured and structured data functions¶
These functions are used with:
Semi-structured data formats (including JSON, Avro, and XML)
Semi-structured data types (including VARIANT, OBJECT, and ARRAY)
Structured data types (including structured OBJECT, structured ARRAY, and MAP)
List of semi-structured and structured data functions¶
The functions are grouped by type of operation performed:
Parsing JSON and XML data.
Extracting values from semi-structured and structured data (e.g. from an ARRAY, OBJECT, or MAP).
Converting/casting semi-structured data types and structured data types to/from other data types.
Determining the data type for values in semi-structured data (i.e. type predicates).
Sub-category |
Function |
Notes |
|---|---|---|
JSON and XML Parsing |
||
Array/Object Creation and Manipulation |
See also Aggregate functions. |
|
See also Aggregate functions. |
||
See also Aggregate functions. |
||
See also Aggregate functions. |
||
Higher-order |
See also Use lambda functions on data with Snowflake higher-order functions. |
|
See also Use lambda functions on data with Snowflake higher-order functions. |
||
See also Use lambda functions on data with Snowflake higher-order functions. |
||
Map Creation and Manipulation |
||
Extraction |
||
Variation of GET. |
||
Extracts keys from key/value pairs in OBJECT. |
||
Conversion/Casting |
||
Type Predicates |
||