snowflake.snowpark.functions.contains¶

snowflake.snowpark.functions.contains(col: Union[Column, str], string: Union[Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/release-v1.6.1/src/snowflake/snowpark/functions.py#L2702-L2719)¶

Returns if col contains string for each row. See CONTAINS <https://docs.snowflake.com/en/sql-reference/functions/contains>

Example

CopyExpand

>>> df = session.create_dataframe([[1,2], [3,4], [5,5] ], schema=["a","b"])
>>> df.select(contains(col("a"), col("b")).alias("result")).show()
------------
|"RESULT"  |
------------
|False     |
|False     |
|True      |
------------

Show lessSee more

Scroll to top