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

snowflake.snowpark.functions.try_cast

snowflake.snowpark.functions.try_cast(column: ColumnOrName, to: str | DataType) Column[source]

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)]
Copy

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)]
Copy