snowflake.snowpark.functions.sql_expr¶

snowflake.snowpark.functions.sql_expr(sql: str) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.30.0/snowpark-python/src/snowflake/snowpark/functions.py#L447-L467)¶

Creates a Column expression from raw SQL text. Note that the function does not interpret or check the SQL text.

Example::

CopyExpand

>>> df = session.create_dataframe([[1, 2], [3, 4]], schema=["A", "B"])
>>> df.select(sql_expr("a + 1").as_("c"), sql_expr("a = 1").as_("d")).collect()  # use SQL expression
[Row(C=2, D=True), Row(C=4, D=False)]

Show lessSee more

Scroll to top