Legacy (Deprecated)

This documentation is for the legacy JAR-based Analytics Toolbox. These functions require cluster-based installation with Apache Sedona and are not available in the SQL Warehouse approach.

For new installations, please use the SQL Warehouse installation which provides LDS functions via Unity Catalog.

The CARTO Analytics Toolbox's functions are organized in modules based on the functionality they offer. On this page you will find the full list with direct links to their definition.

Module	Function or Procedure
lds	GEOCODE_TABLE GEOCODE_REVERSE_TABLE CREATE_ISOLINES CREATE_ROUTES GEOCODE GEOCODE_REVERSE ISOLINE GET_LDS_QUOTA_INFO CREATE_ROUTING_MATRIX
tiler	CREATE_VECTOR_TILESET CREATE_POINT_AGG_TILESET CREATE_H3_AGG_TILESET CREATE_QUADBIN_AGG_TILESET

Apache Sedona

The CARTO Analytics Toolbox for Databricks includes Apache Sedona and makes all functions from "Sedona with Apache Spark" available in your Databricks all-purpose compute cluster.

The current version included is 1.5.1 and you can find the complete reference here.

All functions should be used with the prefix sedona_ , for example:

SELECT sedona_ST_Point(double(1.2345), 2.3456)
-- OUTPUT: POINT (1.2345 2.3456)