# SQL Reference

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                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| --------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| clustering      | <p><a href="clustering#create_clusterkmeans">CREATE\_CLUSTERKMEANS</a><br><a href="clustering#st_clusterkmeans">ST\_CLUSTERKMEANS</a></p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| constructors    | <p><a href="constructors#st_bezierspline">ST\_BEZIERSPLINE</a><br><a href="constructors#st_makeellipse">ST\_MAKEELLIPSE</a><br><a href="constructors#st_makeenvelope">ST\_MAKEENVELOPE</a><br><a href="constructors#st_tileenvelope">ST\_TILEENVELOPE</a></p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| data            | <p><a href="data#enrich_grid">ENRICH\_GRID</a><br><a href="data#enrich_points">ENRICH\_POINTS</a><br><a href="data#enrich_polygons">ENRICH\_POLYGONS</a></p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |
| http\_request   | <p><a href="http_request#http_request">HTTP\_REQUEST</a><br><a href="http_request#get_http_request_quota_info">GET\_HTTP\_REQUEST\_QUOTA\_INFO</a></p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| import          | [IMPORT\_URL](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-redshift/import#import_url)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| lds             | <p><a href="lds#geocode_table">GEOCODE\_TABLE</a><br><a href="lds#geocode_reverse_table">GEOCODE\_REVERSE\_TABLE</a><br><a href="lds#create_isolines">CREATE\_ISOLINES</a><br><a href="lds#create_routes">CREATE\_ROUTES</a><br><a href="lds#geocode">GEOCODE</a><br><a href="lds#geocode_reverse">GEOCODE\_REVERSE</a><br><a href="lds#isoline">ISOLINE</a><br><a href="lds#create_h3_isolines">CREATE\_H3\_ISOLINES</a><br><a href="lds#create_routing_matrix">CREATE\_ROUTING\_MATRIX</a><br><a href="lds#h3_isoline">H3\_ISOLINE</a><br><a href="lds#lds_quota_info">LDS\_QUOTA\_INFO</a></p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| placekey        | <p><a href="placekey#placekey_ash3">PLACEKEY\_ASH3</a><br><a href="placekey#placekey_fromh3">PLACEKEY\_FROMH3</a><br><a href="placekey#placekey_isvalid">PLACEKEY\_ISVALID</a></p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| processing      | <p><a href="processing#st_delaunaylines">ST\_DELAUNAYLINES</a><br><a href="processing#st_delaunaypolygons">ST\_DELAUNAYPOLYGONS</a><br><a href="processing#st_polygonize">ST\_POLYGONIZE</a><br><a href="processing#st_voronoilines">ST\_VORONOILINES</a><br><a href="processing#st_voronoipolygons">ST\_VORONOIPOLYGONS</a></p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| quadbin         | <p><a href="quadbin#quadbin_bbox">QUADBIN\_BBOX</a><br><a href="quadbin#quadbin_boundary">QUADBIN\_BOUNDARY</a><br><a href="quadbin#quadbin_center">QUADBIN\_CENTER</a><br><a href="quadbin#quadbin_distance">QUADBIN\_DISTANCE</a><br><a href="quadbin#quadbin_fromgeogpoint">QUADBIN\_FROMGEOGPOINT</a><br><a href="quadbin#quadbin_fromlonglat">QUADBIN\_FROMLONGLAT</a><br><a href="quadbin#quadbin_fromquadkey">QUADBIN\_FROMQUADKEY</a><br><a href="quadbin#quadbin_fromzxy">QUADBIN\_FROMZXY</a><br><a href="quadbin#quadbin_isvalid">QUADBIN\_ISVALID</a><br><a href="quadbin#quadbin_kring">QUADBIN\_KRING</a><br><a href="quadbin#quadbin_kring_distances">QUADBIN\_KRING\_DISTANCES</a><br><a href="quadbin#quadbin_polyfill">QUADBIN\_POLYFILL</a><br><a href="quadbin#quadbin_resolution">QUADBIN\_RESOLUTION</a><br><a href="quadbin#quadbin_sibling">QUADBIN\_SIBLING</a><br><a href="quadbin#quadbin_tochildren">QUADBIN\_TOCHILDREN</a><br><a href="quadbin#quadbin_toparent">QUADBIN\_TOPARENT</a><br><a href="quadbin#quadbin_toquadkey">QUADBIN\_TOQUADKEY</a><br><a href="quadbin#quadbin_tozxy">QUADBIN\_TOZXY</a></p> |
| random          | [ST\_GENERATEPOINTS](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-redshift/random#st_generatepoints)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| s2              | <p><a href="s2#s2_boundary">S2\_BOUNDARY</a><br><a href="s2#s2_fromgeogpoint">S2\_FROMGEOGPOINT</a><br><a href="s2#s2_fromhilbertquadkey">S2\_FROMHILBERTQUADKEY</a><br><a href="s2#s2_fromlonglat">S2\_FROMLONGLAT</a><br><a href="s2#s2_fromtoken">S2\_FROMTOKEN</a><br><a href="s2#s2_fromuint64repr">S2\_FROMUINT64REPR</a><br><a href="s2#s2_polyfill_bbox">S2\_POLYFILL\_BBOX</a><br><a href="s2#s2_resolution">S2\_RESOLUTION</a><br><a href="s2#s2_tochildren">S2\_TOCHILDREN</a><br><a href="s2#s2_tohilbertquadkey">S2\_TOHILBERTQUADKEY</a><br><a href="s2#s2_toparent">S2\_TOPARENT</a><br><a href="s2#s2_totoken">S2\_TOTOKEN</a><br><a href="s2#s2_touint64repr">S2\_TOUINT64REPR</a></p>                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| statistics      | <p><a href="statistics#getis_ord_quadbin">GETIS\_ORD\_QUADBIN</a><br><a href="statistics#morans_i_quadbin">MORANS\_I\_QUADBIN</a><br><a href="statistics#p_value">P\_VALUE</a></p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| tiler           | <p><a href="tiler#create_simple_tileset">CREATE\_SIMPLE\_TILESET</a><br><a href="tiler#create_point_aggregation_tileset">CREATE\_POINT\_AGGREGATION\_TILESET</a><br><a href="tiler#create_spatial_index_tileset">CREATE\_SPATIAL\_INDEX\_TILESET</a></p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| transformations | <p><a href="transformations#st_centermean">ST\_CENTERMEAN</a><br><a href="transformations#st_centermedian">ST\_CENTERMEDIAN</a><br><a href="transformations#st_centerofmass">ST\_CENTEROFMASS</a><br><a href="transformations#st_centroid">ST\_CENTROID</a><br><a href="transformations#st_destination">ST\_DESTINATION</a><br><a href="transformations#st_greatcircle">ST\_GREATCIRCLE</a></p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |