snowflake.snowpark.functions.st_isvalid¶

snowflake.snowpark.functions.st_isvalid(geography_or_geometry_expression: Union[snowflake.snowpark.column.Column, str]) → Column[source]¶

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