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

snowflake.snowpark.functions.try_cast¶

snowflake.snowpark.functions.try_cast(column: Union[Column, str], to: Union[str, DataType]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.16.0/src/snowflake/snowpark/functions.py#L6024-L6046)¶

A special version of CAST for a subset of data type conversions. It performs the same operation (i.e. converts a value of one data type into another data type), but returns a NULL value instead of raising an error when the conversion can not be performed.

The column argument must be a string column in Snowflake.

Example:

>>> from snowflake.snowpark.types import IntegerType, FloatType
>>> df = session.create_dataframe(['0', '-12', '22', '1001'], schema=["a"])
>>> df.select(try_cast(col("a"), IntegerType()).as_('ans')).collect()
[Row(ANS=0), Row(ANS=-12), Row(ANS=22), Row(ANS=1001)]

Example:

>>> df = session.create_dataframe(['0.12', 'USD 27.90', '13.97 USD', '€97.0', '17,-'], schema=["a"])
>>> df.select(try_cast(col("a"), FloatType()).as_('ans')).collect()
[Row(ANS=0.12), Row(ANS=None), Row(ANS=None), Row(ANS=None), Row(ANS=None)]