snowflake.snowpark.functions.collate¶

snowflake.snowpark.functions.collate(e: Column, collation_spec: str) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/release-v1.6.1/src/snowflake/snowpark/functions.py#L2591-L2609)¶

Returns a copy of the original Column with the specified collation_spec property, rather than the original collation specification property.

For details, see the Snowflake documentation on collation specifications.

Example::

CopyExpand

>>> df = session.create_dataframe(['ñ'], schema=['v'])
>>> df.select(df.v == lit('Ñ'), collate(df.v, 'sp-upper') == lit('Ñ')).show()
----------------------------------------------------------
|"(""V"" = 'Ñ')"  |"(COLLATE(""V"", 'SP-UPPER') = 'Ñ')"  |
----------------------------------------------------------
|False            |True                                  |
----------------------------------------------------------

Show lessSee more

Scroll to top