The Distance function calculates the minimum distance between two geographies, in specified units.

You can use the Distance function on Snowflake and BigQuery connections.

Distance is one of Sigma's Geography functions.

Syntax

Distance(units, geog1, geog2)

The function arguments are:

units
Required
The unit of measurement for the distance
Valid values are "kilometers", "meters", and "miles".
geog1
Required
First geography of the pair between which we calculate the distance
Must be in valid Geography format.
To work from known latitude and longitude values, use the MakePoint or MakeLine functions.
geog2
Required
Second geography of the pair between which we calculate the distance
Must be in valid Geography format.
To work from known latitude and longitude values, use the MakePoint or MakeLine functions.

Examples

Distance("kilometers", [Coordinates], MakePoint(0, 0))
Distance("miles", [Coordinates], MakePoint(0, 0))

The Distance function returns the following values for the Coordinates column, when specifying distance in either kilometers or miles from coordinates (0, 0):

Related functions


Was this page helpful?
Yes No