TIP for use: I needed to find our nearest customer for potential customers. A simple solution is offered by SQL function HAVERSINE, which calculates the distance between two geo points. 
In the first SELECT, you create an array of known points x unknown. Use the function to calculate the distance. In the Second SELECT, you sort by distances and select the nearest one. 
Special thanks to Samuel for help. 

Snowflake Documentation.