snowflake.snowpark.functions.st_isvalid¶

snowflake.snowpark.functions.st_isvalid(geography_or_geometry_expression: Union[snowflake.snowpark.column.Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.41.0/src/snowflake/snowpark/_functions/scalar_functions.py#L2632-L2652)¶

Returns TRUE if the input GEOGRAPHY or GEOMETRY object is valid, FALSE otherwise.

Parameters:

geography_or_geometry_expression (ColumnOrName) – A column containing GEOGRAPHY or GEOMETRY objects to validate.

Returns:

A column of boolean values indicating whether each geography or geometry object is valid.

Return type:

Column

Examples::

>>> from snowflake.snowpark.functions import to_geography
>>> df = session.create_dataframe([["POLYGON((-93.086 37.557,-86.699 37.497,-93.198 35.123,-93.086 37.557))"]],schema=["geom"])
>>> df.select(st_isvalid(to_geography(df["geom"])).alias("is_valid")).collect()
[Row(IS_VALID=True)]

Copy