How to apply routing functions in CARTO
In order to generate a route from one point to another, CARTO users can use the CARTO Data Services API. The routing functions will return the geometry, and also the trip duration (in seconds) and trip length (in kilometers).
If you have a table with latitude and longitude coordinates for both origin and destination, you can use a query like this one:
SELECT o.cartodb_id, o.origin, o.destination, r.duration/60 as minutes, r.length, r.shape as the_geom FROM table_name o, table_name d, cdb_route_point_to_point( cdb_latlng(o.lat_o, o.long_o), cdb_latlng(d.lat_d, d.long_d), 'car') as r WHERE o.cartodb_id = d.cartodb_id