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.
• Creating and manipulating ARRAYs and OBJECTs.
• 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).