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 | ||