JSON, variant, CSV, and XML functions - Firebolt Documentation

Preview Spark JSON, variant, CSV, and XML functions in SparkSQL and Databricks compatibility modes. Both modes share these functions. Support is one of: Supported, With limitations, or Not supported. Supported means every example in the Spark reference returns what Spark returns; a note under With limitations quotes a call that differs.

JSON functions

Function	Support	Notes
`JSON_OBJECT_KEYS`	Supported
`JSON_ARRAY_LENGTH`	With limitations	`json_array_length('[1,2')` raises an error, where Spark returns `NULL`.
`TO_JSON`	With limitations	Returns `JSON`, where Spark returns `TEXT`. `MAP` arguments are not supported.
`FROM_JSON`, `GET_JSON_OBJECT`, `JSON_TUPLE`, `SCHEMA_OF_JSON`	Not supported

Variant functions

Function	Support	Notes
`IS_VARIANT_NULL`, `PARSE_JSON`, `SCHEMA_OF_VARIANT`, `SCHEMA_OF_VARIANT_AGG`, `TO_VARIANT_OBJECT`, `TRY_PARSE_JSON`, `TRY_VARIANT_GET`, `VARIANT_EXPLODE`, `VARIANT_EXPLODE_OUTER`, `VARIANT_GET`	Not supported

CSV functions

Function	Support	Notes
`FROM_CSV`, `SCHEMA_OF_CSV`, `TO_CSV`	Not supported

XML functions

Function	Support	Notes
`FROM_XML`, `SCHEMA_OF_XML`, `TO_XML`, `XPATH`, `XPATH_BOOLEAN`, `XPATH_DOUBLE`, `XPATH_FLOAT`, `XPATH_INT`, `XPATH_LONG`, `XPATH_NUMBER`, `XPATH_SHORT`, `XPATH_STRING`	Not supported