Semi-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).
The functions are grouped by type of operation performed:
Parsing JSON and XML data.
Extracting values from semi-structured data (e.g. from an ARRAY or OBJECT).
Converting/casting semi-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. |
||
Extraction |
||
Variation of GET. |
||
Extracts keys from key/value pairs in OBJECT. |
||
Conversion/Casting |
||
Type Predicates |
||