snowflake.snowpark.functions.array_to_string¶
- snowflake.snowpark.functions.array_to_string(array: ColumnOrName, separator: ColumnOrName) Column[source]¶
Returns an input ARRAY converted to a string by casting all values to strings (using TO_VARCHAR) and concatenating them (using the string from the second argument to separate the elements).
- Parameters:
array – Column containing the ARRAY of elements to convert to a string.
separator – Column containing the string to put between each element (e.g. a space, comma, or other human-readable separator).
- Example::
>>> from snowflake.snowpark import Row >>> df = session.create_dataframe([Row(a=[1, True, "s"])]) >>> df.select(array_to_string("a", lit(",")).alias("result")).show() ------------ |"RESULT" | ------------ |1,true,s | ------------