Summary A guide to route optimization using Google BigQuery, a cloud-native & scalable alternative to PgRouting & Network Analyst. This post may describe functionality for an old version of CARTO. Find out about the latest and cloud-native version here. Computing distance metrics is a challenging problem in spatial analysis. When studying urban travel, calculating distances between two locations a
![Calculating Routes at Scale using SQL on BigQuery](https://cdn-ak-scissors.b.st-hatena.com/image/square/534c765cd20b5f520347e271b20ad5fc07c39113/height=288;version=1;width=512/https%3A%2F%2Fcdn.prod.website-files.com%2F63483ad423421bd16e7a7ae7%2F63e1157fe3707d0941ed3f22_Calculating%2520routes%2520at%2520scale%2520using%2520SQL%2520%2526%2520BigQuery%281%29.png)