Converts value to the object type

ToObject("{\\"key\\": 1}") → {"key":1}


ToObject(value, [replaceInvalidWith])

  • value - A value to convert into an object

  • [replaceInvalidWith] - [optional: null by default**]** - invalid values will be replaced with this parameter


We do not have a direct syntax in our expressions to create an Object, but you can get it as a result of some nodes, such as Nest or Unnest

Convert String columns to Object before using them in the Unnest node.