You are viewing documentation about an older version (1.3.0). View latest version

snowflake.snowpark.functions.lower

snowflake.snowpark.functions.lower(e: ColumnOrName) Column[source]

Returns the input string with all characters converted to lowercase.

Example:

>>> df = session.create_dataframe(['abc', 'Abc', 'aBC', 'Anführungszeichen', '14.95 €'], schema=["a"])
>>> df.select(lower(col("a"))).collect()
[Row(LOWER("A")='abc'), Row(LOWER("A")='abc'), Row(LOWER("A")='abc'), Row(LOWER("A")='anführungszeichen'), Row(LOWER("A")='14.95 €')]
Copy