snowflake.snowpark.functions.is_double¶

snowflake.snowpark.functions.is_double(col: Union[Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/release-v1.6.1/src/snowflake/snowpark/functions.py#L3922-L3934)¶

Returns true if the specified VARIANT column contains a floating-point value, fixed-point decimal, or integer.

Examples:

CopyExpand

>>> from snowflake.snowpark.types import StructField, VariantType
>>> df = session.create_dataframe([[1.2, "X"]], schema=["a", "b"])
>>> df.select(is_double(to_variant(df["a"])).alias("double"), is_double(to_variant(df["b"])).alias("varchar")).collect()
[Row(DOUBLE=True, VARCHAR=False)]

Show lessSee more

Scroll to top