snowflake.snowpark.functions.st_npoints¶

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

Returns the number of points in a GEOGRAPHY or GEOMETRY object.

Parameters:: geography_or_geometry_expression (ColumnOrName) – A GEOGRAPHY or GEOMETRY objects.
Returns:: The number of points in the input object.
Return type:: Column

Examples::

>>> from snowflake.snowpark.functions import col, to_geometry
>>> df = session.create_dataframe([
...     ['POINT(66 12)'],
...     ['POLYGON((17 17, 17 30, 30 30, 30 17, 17 17))'],
...     ['LINESTRING(40 60, 50 50, 60 40)']
... ], schema=["geom"])
>>> df.select(st_npoints(to_geometry(df["geom"])).alias("npoints")).collect()
[Row(NPOINTS=1), Row(NPOINTS=5), Row(NPOINTS=3)]