Converts value to the array type

ToArray("[1, 2, 3]") → [1, 2, 3]


ToArray(value, [replaceInvalidWith])

  • value - A column to convert into an array

  • [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 Array, but you can get it as a result of some nodes or functions, such as Split or Nest

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