Changelog

New SQL function string_to_array

04.21.2025

We've added support for a new SQL function string_to_array to our managed cloud.

string_to_array (docs) splits a string based on a delimiter and returns an array of the split elements.

1 > SELECT string_to_array('new Materialize SQL function is here!', 'SQL'); 
 sql

Output:

`1`	`string_to_array`
`2`	`-------------------------------------------`
`3`	`{"new Materialize "," function is here!"}`
`4`	`(1 row)`

text