snowflake.snowpark.functions.st_distance

snowflake.snowpark.functions.st_distance(geography_or_geometry_expression_1: Union[snowflake.snowpark.column.Column, str], geography_or_geometry_expression_2: Union[snowflake.snowpark.column.Column, str]) → Column[source]

Returns the minimum geodesic distance between two GEOGRAPHY objects or the Euclidean distance between two GEOMETRY objects.

Parameters:

  • geography_or_geometry_expression_1 (ColumnOrName) – A GEOGRAPHY or GEOMETRY objects.

  • geography_or_geometry_expression_2 (ColumnOrName) – A GEOGRAPHY or GEOMETRY objects.

Returns:

The distance between the two geographic or geometric objects.

Return type:

Column

Examples

>>> df = session.sql("select TO_GEOGRAPHY('POINT(0 0)') as point1, TO_GEOGRAPHY('POINT(1 0)') as point2")
>>> df.select(st_distance(df.point1, df.point2).alias("distance")).collect()
[Row(DISTANCE=111195.10117748393)]