The string function used to split a string into multiple substrings, based on some delimiter. Unlike other functions, STRING_SPLIT returns multiple rows, one per substring.
The STRING_SPLIT function requires two arguments. The first argument is the string to be split and it can be stated either as a string or as a column. The second argument is the character to split the string on.