snowflake.snowpark.functions.split¶

snowflake.snowpark.functions.split(str: Union[Column, str], pattern: Union[Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/release-v1.6.1/src/snowflake/snowpark/functions.py#L2322-L2352)¶

Splits a given string with a given separator and returns the result in an array of strings. To specify a string separator, use the lit() function.

Example::

CopyExpand

>>> df = session.create_dataframe(
...     [["many-many-words", "-"], ["hello--hello", "--"]],
...     schema=["V", "D"],
... ).select(split(col("V"), col("D")))
>>> df.show()
-------------------------
|"SPLIT(""V"", ""D"")"  |
-------------------------
|[                      |
|  "many",              |
|  "many",              |
|  "words"              |
|]                      |
|[                      |
|  "hello",             |
|  "hello"              |
|]                      |
-------------------------

Show lessSee more

Scroll to top