# Release Notes

## March 27th, 2026 (1.23.0)

**Module data**

New

* Added [ENRICH\_POLYGONS\_WEIGHTED](https://docs.carto.com/data-and-analysis/sql-reference/data#enrich_polygons_weighted) procedure for Snowflake, supporting weighted enrichment of polygon geometries.

**Module lds**

Fix

* Updated [CREATE\_H3\_ISOLINES](https://docs.carto.com/data-and-analysis/sql-reference/lds#create_h3_isolines) procedure to fix edge cases that didn't allow preview in workflows.
* Improved error logging when routes and responses exceed size limits.

## January 30th, 2026 (1.22.1)

**Module lds**

Fix

* Added a fix to [GEOCODE\_TABLE](https://docs.carto.com/data-and-analysis/sql-reference/lds#geocode_table) procedure, that was not correctly sanitizing line breaks in addresses strings when using TomTom as provider.

## December 31st, 2025 (v1.22.0)

**Module lds**

New

* Add [H3\_ISOLINE](https://docs.carto.com/data-and-analysis/sql-reference/lds#h3_isoline) function and [CREATE\_H3\_ISOLINES](https://docs.carto.com/data-and-analysis/sql-reference/lds#create_h3_isolines) procedure in order to calculate H3 isochrones from a given point by using [Traveltime](https://docs.traveltime.com/api/reference/h3) services.

## November 28th, 2025 (v1.21.4)

**Module data**

Fix

* Updated `turf.js` library version to avoid crashes produced by overlapping polygons in [`ENRICH_POLYGONS`](https://docs.carto.com/data-and-analysis/sql-reference/data#enrich_polygons) procedure.

**Module tiler**

Fix

* Introduced a change to use `CREATE OR REPLACE` for temporal tables in order to improve [`CREATE_SIMPLE_TILESET`](https://docs.carto.com/data-and-analysis/sql-reference/tiler#create_simple_tileset) stability.

## September 11th, 2025 (v1.21.0)

**Module tiler**

Improvement

* [CREATE\_SIMPLE\_TILESET](https://docs.carto.com/data-and-analysis/sql-reference/tiler#create_simple_tileset) and [CREATE\_POINT\_AGGREGATION\_TILESET](https://docs.carto.com/data-and-analysis/sql-reference/tiler#create_point_aggregation_tileset) create tiles in MVT format instead of the previous GeoJson format, which makes them faster to process and serve by Maps API and render client-side.

## August 25th, 2025 (v1.20.2)

**Module tiler**

New

* Added option `max_categories_limit` that controls the maximum number of categories from string columns included in metadata for every tiler procedure.

## July 8th, 2025 (v1.20.1)

**Module lds**

New

* Add a debug parameter to all the procedures in order to improve debugging capabilities.

Fix

* Added a change to avoid additional calls to remote functions in LDS procedures when updating the output table, which was causing some procedures to crash.

**Module tiler**

Fix

* Added fixes to [CREATE\_SPATIAL\_INDEX\_TILESET](https://docs.carto.com/data-and-analysis/sql-reference/tiler#create_spatial_index_tileset) to start dropping temporal tables and printing success messages.

## May 14th, 2025 (v1.20.0)

**Module lds**

New

* Added [CREATE\_ROUTING\_MATRIX](https://docs.carto.com/data-and-analysis/sql-reference/lds#create_routing_matrix) which computes route data between a set of origin and destination points and generates a table adding the distance and time of each pair of values.

## May 6th, 2025 (v1.19.0)

**Module raster**

Fix

* Added a fix to keep the original geometry column from the vector input in [RASTER\_AGG\_VALUES](https://docs.carto.com/data-and-analysis/sql-reference/raster#raster_agg_values) procedure.

**Module lds**

Fix

* Added a fix to have better handling of null values in all procedures

**Module clustering**

Fix

* Added a fix to prevent the [ST\_CLUSTERKMEANS](https://docs.carto.com/data-and-analysis/sql-reference/clustering#st_clusterkmeans) procedure from throwing an error when encountering null values in Geography columns

## January 30th, 2025 (v1.18.0)

**Module raster**

Improvement

* Added support for compressed raster tables in [RASTER\_VALUES](https://docs.carto.com/data-and-analysis/sql-reference/raster#raster_values) and [RASTER\_AGG\_VALUES](https://docs.carto.com/data-and-analysis/sql-reference/raster#raster_agg_values).

**Module statistics**

Fix

* Fixed [TIME\_SERIES\_CLUSTERING](https://docs.carto.com/data-and-analysis/sql-reference/statistics#time_series_clustering), [CREATE\_SPATIAL\_COMPOSITE\_SUPERVISED](https://docs.carto.com/data-and-analysis/sql-reference/statistics#create_spatial_composite_supervised), and [CREATE\_SPATIAL\_COMPOSITE\_UNSUPERVISED](https://docs.carto.com/data-and-analysis/sql-reference/statistics#create_spatial_composite_unsupervised) procedures when using Snowpark ML in connections where there is no default schema set.
* Fixed [CREATE\_SPATIAL\_COMPOSITE\_SUPERVISED](https://docs.carto.com/data-and-analysis/sql-reference/statistics#create_spatial_composite_supervised), [CREATE\_SPATIAL\_COMPOSITE\_UNSUPERVISED](https://docs.carto.com/data-and-analysis/sql-reference/statistics#create_spatial_composite_unsupervised) procedures returning buckets of non-equal size (when bucketize method is “EQUAL\_INTERVALS” or “EQUAL\_INTERVALS\_ZERO\_CENTERED”).

## December 19th, 2024 (v1.17.0)

**Module lds**

Improvement

* Added a verification of AT Gateway parameters during the `SETUP` process to ensure availability of resources.

## November 27th, 2024 (v1.16.0)

**Module data**

New

* Added [ENRICH\_POLYGONS\_WEIGHTED](https://docs.carto.com/data-and-analysis/sql-reference/data#enrich_polygons_weighted) procedure.

**Module lds**

Fix

* Fixed an issue that produced redundant calls in [CREATE\_ROUTES](https://docs.carto.com/data-and-analysis/sql-reference/lds#create_routes) procedure.

## October 28th, 2024 (v1.15.0)

**Module lds**

Improvement

* Added async batch routing services support for TomTom, providing a 2x-3x preformance improvement in processing speed.

**Module statistics**

New

* New [TIME\_SERIES\_CLUSTERING](https://docs.carto.com/data-and-analysis/sql-reference/statistics#time_series_clustering) procedure, which expects a table containing time series (indexed by a time step column and a unique series identifier) and can group the time series in as many clusters as the user requests.
* New [SPACETIME\_HOTSPOTS\_CLASSIFICATION](https://docs.carto.com/data-and-analysis/sql-reference/statistics#spacetime_hotspots_classification) procedure. This procedure is designed to analyze spatio-temporal data in order to identify and categorize locations based on their hotspot or coldspot status over time. Utilizing z-score values generated by the Space-Time Getis-Ord function.

## September 24th, 2024 (v1.14.0)

**Module tiler**

New

* Add `tile_resolution` to all [tileset](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/sql-reference/tiler) creation options. This new setting allows controlling the size of the tiles when rendered in a map. Higher values produce larger tiles.

**Module statistics**

Fix

* Update python version from 3.8 to 3.9 on [CREATE\_SPATIAL\_COMPOSITE\_SUPERVISED](https://docs.carto.com/data-and-analysis/sql-reference/statistics#create_spatial_composite_supervised) and [CREATE\_SPATIAL\_COMPOSITE\_UNSUPERVISED](https://docs.carto.com/analytics-toolbox-for-bigquery/sql-reference/statistics#create_spatial_composite_unsupervised) procedures, as version 3.8 is getting deprecated.

## August 23rd, 2024 (v1.13.1)

**Module statistics**

Fix

* Fixed an issue with [GETIS\_ORD\_SPACETIME\_H3](https://docs.carto.com/data-and-analysis/sql-reference/statistics#getis_ord_spacetime_h3) and [GETIS\_ORD\_SPACETIME\_QUADBIN](https://docs.carto.com/data-and-analysis/sql-reference/statistics#getis_ord_spacetime_quadbin) procedures, that were returning wrong results when “time\_freq” was passed as lower case.

## July 2nd, 2024 (v1.13.0)

**Module raster**

New

* Adjustments to use only full-resolution data when the raster table has overviews (blocks of resolution smaller than the block\_resolution stated in the metadata)
* We can now specify per-band no-data values for raster datasets. Rasters bands also now have a ‘`colorInterp`’ metadata attribute with possible values of red, green, blue, alpha or unknown.

Improvement

* Replaced some of the `IFF` logic checks for NODATA values with `NULLIF` and arithmetic operations. This allows Snowflake's planner to better optimize queries and improves performance.
* Optimized raster procedures ([`RASTER_VALUES`](https://docs.carto.com/data-and-analysis/sql-reference/raster#raster_values), [`RASTER_AGG_VALUES`](https://docs.carto.com/data-and-analysis/sql-reference/raster#raster_agg_values)) to manage bigger data sources.
* New options in [`RASTER_AGG_VALUES`](https://docs.carto.com/data-and-analysis/sql-reference/raster#raster_agg_values): `groupby_vector_columns` and `groupby_raster_columns` to have finer control over the aggregation.

**Module import**

Fix

* Import functions in AT Gateway now raise an exception when there is an error. This replaces the previous status message.

## May 22nd, 2024 (v1.12.0)

**Module h3**

Improvement

* Avoid memory limit exceeded in [H3\_POLYFILL\_TABLE](https://docs.carto.com/data-and-analysis/sql-reference/h3#h3_polyfill_table-beta)

**Module statistics**

Fix

* Include all numeric types for unsupervised composite score validation in [CREATE\_SPATIAL\_COMPOSITE\_UNSUPERVISED](https://docs.carto.com/data-and-analysis/sql-reference/statistics#create_spatial_composite_unsupervised).

**Module http\_request**

New

* We have a new module named “http\_request”. It allows making requests to external endpoints through the function [`HTTP_REQUEST`](https://docs.carto.com/data-and-analysis/sql-reference/http_request#http_request)

**Module import**

New

* We have a new module named “import”. It allows importing tables for a given URL containing a file in any of the formats supported by the CARTO Import API. The procedure in charge of this import is [`IMPORT_URL`](https://docs.carto.com/data-and-analysis/sql-reference/import#import_url).

## April 18th, 2024 (v1.11.0)

**Module raster**

New

* Added new `RASTER_VALUES` and `RASTER_AGG_VALUES` procedures:
  * `RASTER_VALUES` obtains pixel values from a raster where it overlaps with an optional vector data input. It accepts SQL expressions, including operations between bands.
  * `RASTER_AGG_VALUES` obtains aggregated values from a raster's pixel values where it intersects with a vector data input. It accepts any SQL aggregation expression.

**Module clustering**

Fix

* Update [ST\_CLUSTERKMEANS](https://docs.carto.com/data-and-analysis/sql-reference/clustering#st_clusterkmeans) in order to avoid generating fewer clusters than requested. The maximum number of clusters now will be equal to the number of different points passed.

**Module h3**

Improvement

* Functions in the h3 module now use [Snowflake's native H3 functions](https://docs.snowflake.com/sql-reference/data-types-geospatial#label-data-types-geospatial-h3) internally. This change improves performance as it leverages native Snowflake optimization capabilities.

**Module lds**

Fix

* [`GEOCODE_TABLE`](https://docs.carto.com/data-and-analysis/sql-reference/lds#geocode_table) not working properly for “`geom_column`” parameters value different from “`geom`”.

## March 21st, 2024 (v1.10.0)

**Module lds**

New

* All external functions (including those used by the procedures in the lds module) now use a single, unified endpoint. This also simplifies the manual installation of the Analytics Toolbox.
* [GEOCODE\_TABLE](https://docs.carto.com/data-and-analysis/sql-reference/lds#geocode_table) now uses async batch geocoding with TomTom, boosting the geocoding speed considerably. Also matching by rows is applied ensuring that the address that reaches the TomTom endpoints is as similar as possible as the table value.

**Module statistics**

Fix

* Updated output table schema for the procedures [CREATE\_SPATIAL\_COMPOSITE\_SUPERVISED](https://docs.carto.com/data-and-analysis/sql-reference/statistics#create_spatial_composite_supervised) and [CREATE\_SPATIAL\_COMPOSITE\_UNSUPERVISED](https://docs.carto.com/data-and-analysis/sql-reference/statistics#create_spatial_composite_unsupervised).

## February 16th, 2024 (v1.9.0)

**Module raster**

New

* Add [RASTER\_VALUE](https://docs.carto.com/data-and-analysis/sql-reference/raster#raster_value) and [RASTER\_VALUE\_TABLE](https://docs.carto.com/data-and-analysis/sql-reference/raster#raster_value_table) procedures: work with CARTO raster tables, with support for custom operations, including multi-band and aggregation expressions.
* [Raster loader v0.5.0](https://raster-loader.readthedocs.io/en/latest/user_guide/cli.html#using-the-raster-loader-with-snowflake): adding support for Snowflake.

**Module statistics**

Fix

* Fixes in [CREATE\_SPATIAL\_COMPOSITE\_UNSUPERVISED](https://docs.carto.com/data-and-analysis/sql-reference/statistics#create_spatial_composite_unsupervised), [GETIS\_ORD\_SPACETIME](https://docs.carto.com/data-and-analysis/sql-reference/statistics#getis_ord_spacetime_quadbin) procedures.
* Add warning to [Moran's I](https://docs.carto.com/data-and-analysis/sql-reference/statistics#morans_i_h3) procedures when no cells have neighbors.

**Module lds**

Fix

* Sanitize queries in [GEOCODE\_TABLE](https://docs.carto.com/data-and-analysis/sql-reference/lds#geocode_table) so addresses with special characters are geocoded.

**Module quadbin**

Fix

* Fix [QUADBIN\_TOPARENT](https://docs.carto.com/data-and-analysis/sql-reference/quadbin#quadbin_toparent) so it can work with views.

**Module random**

Fix

* Fix [ST\_GENERATEPOINTS](https://docs.carto.com/data-and-analysis/sql-reference/random#st_generatepoints) to accept column names and increase performance.

## January 18th, 2024 (v1.8.0)

**Module quadbin**

New

* New [QUADBIN\_DISTANCE](https://docs.carto.com/data-and-analysis/sql-reference/quadbin#quadbin_distance) function that returns the distance (number of cells) between two quadbin cells.

Fix

* Improved precision when calculating cell indexes from latitudes close to the poles (±90º).
* [QUADBIN](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/sql-reference/quadbin) functions now return NULL when NULL parameters are passed.

**Module transformations**

New

* New [ST\_POINTONSURFACE](https://docs.carto.com/data-and-analysis/sql-reference/transformations#st_pointonsurface) function.

**Module tiler**

Fix

* Fixed a problem that caused [CREATE\_SIMPLE\_TILESET](https://docs.carto.com/data-and-analysis/sql-reference/tiler#create_simple_tileset) procedure crashing for zooms higher than 13.
* Improved tile precision when creating tilesets from geographies containing points with latitudes close to the poles (±90º) using [CREATE\_SIMPLE\_TILESET](https://docs.carto.com/data-and-analysis/sql-reference/tiler#create_simple_tileset) or [CREATE\_POINT\_AGGREGATION\_TILESET](https://docs.carto.com/data-and-analysis/sql-reference/tiler#create_point_aggregation_tileset).

**Module data**

Fix

* Fixed an issue when using AVG aggregation, that was not correctly computed when “data\_query” contained NULL values.
* Output tables are now correctly prepared to work with Snowflake's [Search Optimization Service](https://docs.snowflake.com/en/user-guide/search-optimization-service).

**Module lds**

Fix

* Output tables are now correctly prepared to work with Snowflake's [Search Optimization Service](https://docs.snowflake.com/en/user-guide/search-optimization-service).

**Module statistics**

New

* New [CREATE\_SPATIAL\_COMPOSITE\_SUPERVISED](https://docs.carto.com/data-and-analysis/sql-reference/statistics#create_spatial_composite_supervised), [CREATE\_SPATIAL\_COMPOSITE\_UNSUPERVISED](https://docs.carto.com/data-and-analysis/sql-reference/statistics#create_spatial_composite_unsupervised) and [CRONBACH\_ALPHA\_COEFFICIENT](https://docs.carto.com/data-and-analysis/sql-reference/statistics#cronbach_alpha_coefficient) procedures.

Fix

* Replaced “index” as column name in the output tables with “h3” or “quadbin”, for easier use of the results in Builder for [Moran’s](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/sql-reference/statistics), [GETIS\_ORD\_](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/sql-reference/statistics)\* and [GWR\_GRID](https://docs.carto.com/data-and-analysis/sql-reference/statistics#gwr_grid) procedures.
* Output tables are now correctly prepared to work with Snowflake's [Search Optimization Service](https://docs.snowflake.com/en/user-guide/search-optimization-service).

## December 21, 2023 (v1.7.1)

**Module statistics**

Fix

* Change output types of [`GWR_GRID`](https://docs.carto.com/data-and-analysis/sql-reference/statistics#gwr_grid) from Variant to the corresponding ones
* Added `EXECUTE AS CALLER` option to [`GETIS_ORD_SPACETIME_QUADBIN`](https://docs.carto.com/data-and-analysis/sql-reference/statistics#getis_ord_spacetime_quadbin) and [`GETIS_ORD_SPACETIME_H3`](https://docs.carto.com/data-and-analysis/sql-reference/statistics#getis_ord_spacetime_h3) procedures. This fixes a previous issue when trying to use the procedures with a role different than the owner.

**Module retail**

New

* Introduced the new [retail](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/sql-reference/retail) module for Snowflake, aimed to solve specific retail analytics use cases.
* New [COMMERCIAL\_HOTSPOTS](https://docs.carto.com/data-and-analysis/sql-reference/retail#commercial_hotspots) procedure, which can be used to locate hotspot areas by calculating a combined Getis-Ord Gi\* statistic over several variables.

## November 13, 2013 (v1.7.0)

**Module lds**

New

* Add [SETUP](https://docs.carto.com/data-and-analysis/sql-reference/lds#setup) procedure. This procedure allows configuring credentials and endpoints for a custom installation of the Analytics Toolbox. Check [this documentation](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/getting-access/advanced) for more information about this topic.
* Replace LDS\_QUOTA\_INFO by [GET\_LDS\_QUOTA\_INFO](https://docs.carto.com/data-and-analysis/sql-reference/lds#get_lds_quota_info) function. This new function allows checking your currently consumed quota with a single query, without the need to store the result as a table.

**Module statistics**

New

* Added [`LOCAL_MORANS_I_H3`](https://docs.carto.com/data-and-analysis/sql-reference/statistics#local_morans_i_h3), [`LOCAL_MORANS_I_QUADBIN`](https://docs.carto.com/data-and-analysis/sql-reference/statistics#local_morans_i_quadbin) procedures. These procedures allows computing the spatial autocorrelation locally.
* Added [`GWR_GRID`](https://docs.carto.com/data-and-analysis/sql-reference/statistics#gwr_grid) procedure. This procedure allows computing a Geographically Weighed Regression on an spatial index grid.
* Added [`GETIS_ORD_SPACETIME_H3`](https://docs.carto.com/data-and-analysis/sql-reference/statistics#getis_ord_spacetime_h3), [`GETIS_ORD_SPACETIME_QUADBIN`](https://docs.carto.com/data-and-analysis/sql-reference/statistics#getis_ord_spacetime_quadbin) procedures. These procedures allow computing the space temporal Getis-Ord Gi\* statistic for each H3 index and each datetime timestamp according to the method described in this [paper](https://doi.org/10.1080/00330124.2019.1709215).

Fix

* Added missing `EXECUTE AS CALLER` command in the procedures of this module, which was causing an error when the role that ran the procedure was not the owner.

## October 13, 2023 (v1.6.1)

**Module lds**

Improvement

* New batch service for [CREATE\_ISOLINES](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/sql-reference/lds#create_isolines). Used automatically by the procedure. No changes required.

## September 8, 2023 (v1.6.0)

**Module statistics**

New

* The new version of the following procedures now expects a **table as input**, overcoming previous performance limitations:
  * [GETIS\_ORD\_H3](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/sql-reference/statistics#getis_ord_h3)
  * [GETIS\_ORD\_QUADBIN](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/sql-reference/statistics#getis_ord_quadbin)
  * [MORANS\_I\_H3](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/sql-reference/statistics#morans_i_h3)
  * [MORANS\_I\_QUADBIN](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/sql-reference/statistics#morans_i_quadbin)

{% hint style="warning" %}
This is a **breaking change** from the previous version of the functions that expected an ARRAY as input. Please make sure that you make the necessary changes if you are using this functions.
{% endhint %}

**Module lds**

New

* We have added optional parameters: `api_base_url`, `lds_token` to every function/procedure

Fix

* Fix `CREATE_ROUTES` fails if `geom_column` is not named `geom`

## July 14, 2023 (v1.4.0)

**Module lds**

New

* We are now allowing users to send any of the parameter options supported by the isolines service provider in [CREATE\_ISOLINES](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/lds#create_isolines).
* We have improved our logging of results in [GEOCODE\_TABLE](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/sql-reference/lds#geocode_table) so more information about processed and geocoded rows is provided to the user. Also the new option “carto\_force\_geocode” allows the re-geocoding of already geocoded rows.

## June 6, 2023 (v1.3.0)

**Module lds**

New

* We have created a new procedure named [CREATE\_ROUTES](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/sql-reference/lds#create_routes), which calculates the routes (returned as linestrings) between a set of given origins and destinations (points) in a query. It supports different transport modes and advanced options as the other functions of the lds module.

## May 5, 2023 (v1.2.0)

**Module statistics**

New

We have added a new module named “statistics” in the Analytics Toolbox for Snowflake which has a set of geostatistics functions to compute the Getis-Ord Gi\* statistic and the Moran’s I spatial autocorrelation:

* Getis-Ord Gi\* functions:
  * [GETIS\_ORD\_QUADBIN](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/sql-reference/statistics#getis_ord_quadbin)
  * [GETIS\_ORD\_H3](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/sql-reference/statistics#getis_ord_h3)
  * [P\_VALUE](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/sql-reference/statistics#p_value)
* Moran’s I functions:
  * [MORANS\_I\_QUADBIN](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/sql-reference/statistics#morans_i_quadbin)
  * [MORANS\_I\_H3](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/sql-reference/statistics#morans_i_h3)

**Module h3**

New

We have incorporated two new functions to the “h3” module of the Analytics Toolbox, namely [H3\_CENTER](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/sql-reference/h3#h3_center), which returns the center of an H3 cell as a GEOGRAPHY point, and [H3\_RESOLUTION](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/sql-reference/h3#h3_resolution) which returns the H3 cell resolution as an integer.

**Module transformations**

New

We have added support for the [ST\_CONVEXHULL](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/sql-reference/transformations#st_convexhull) function, which computes the convex hull of the input geographies (the smallest convex geography that covers all the input ones)

## April 4, 2023 (v1.1.1)

**Module lds**

Improvement

* We have improved the performance in [CREATE\_ISOLINES](https://docs.carto.com/analytics-toolbox-for-redshift/sql-reference/lds#create_isolines), benefiting now from parallelizing requests to the API.

Change

* We have updated the [LDS module](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-snowflake/sql-reference/lds) to be aligned with the new [usage quota](https://docs.carto.com/carto-user-manual/settings/understanding-your-organization-quotas#usage-quota) model, working as an annual budget and combining consumption across all supported LDS services.

## March 7, 2023 (v1.1.0)

**Module lds**

New

* We have added object type support for the options parameter also maintaining string type support as until now in [GEOCODE\_TABLE](https://docs.carto.com/data-and-analysis/sql-reference/lds#geocode_table), [GEOCODE\_REVERSE\_TABLE](https://docs.carto.com/data-and-analysis/sql-reference/lds#geocode_reverse_table), [CREATE\_ISOLINES](https://docs.carto.com/data-and-analysis/sql-reference/lds#create_isolines), , [GEOCODE](https://docs.carto.com/data-and-analysis/sql-reference/lds#geocode), [GEOCODE\_REVERSE](https://docs.carto.com/data-and-analysis/sql-reference/lds#geocode_reverse), and [ISOLINE](https://docs.carto.com/data-and-analysis/sql-reference/lds#isoline).

## January 31, 2023 (v1.0.0)

**Module tiler**

Improvement

* Update default zoom values: geo, quadbin, h3 (12, 12, 6).
* Fix spatial index tiler with empty properties.

## December 22, 2022 <a href="#december-22-2022" id="december-22-2022"></a>

### **Module lds**

Improvement

* We have added the possibility to configure more options as parameters when executing the functions to [CREATE\_ISOLINES](https://docs.carto.com/data-and-analysis/sql-reference/lds#create_isolines). These new options, which depend on the LDS service provider, allow the user to configure more transportation modes such as truck or bike, the possibility of specifying departure or arrival times allowing the creation of reverse isolines, and other options like different routing modes.
* Added new confidence/relevance metadata to the results of the geocoding function [GEOCODE\_TABLE](https://docs.carto.com/sql-reference/lds/#geocode_table).

### **Module quadbin**

New

* Quadbin/quadkey conversion functions have been added to ease the conversion from [quadbin](https://docs.carto.com/sql-reference/quadbin/) to quadkey and from quadkey to quadbin indexes.

### **Module h3**

* The [H3\_BOUNDARY](https://docs.carto.com/sql-reference/h3/#h3_boundary) function for invalid geographies has been fixed.

## November 1, 2022 <a href="#november-1-2022" id="november-1-2022"></a>

### **All modules**

Feature

* Create release workflows

## October 24, 2022 <a href="#october-24-2022" id="october-24-2022"></a>

### **Module processing**

Fix

* Prevent error in ST\_VORONOIPOLYGONS, ST\_VORONOILINES, ST\_VORONOIPOLYGONS, ST\_DELAUNAYLINES when points where too close together by rounding input coordinates to 5 decimal places

#### October 7, 2022 <a href="#october-7-2022" id="october-7-2022"></a>

### **Module clustering**

Feature

* Move ST\_CLUSTERKMEANS function to core.

### **Module random**

Feature

* Move ST\_GENERATEPOINTS function to core.

## October 4, 2022 <a href="#october-4-2022" id="october-4-2022"></a>

### **Module lds**

Improvement

* CREATE\_ISOLINES output is ordered by geometry to be compliant with Snowflake Search Optimization Service.

## September 30, 2022 <a href="#september-30-2022" id="september-30-2022"></a>

### **Module lds**

Improvement

* Rename `LDS_API_URL` to `API_BASE_URL`.

## September 28, 2022 <a href="#september-28-2022" id="september-28-2022"></a>

### **Module data**

Improvement

* Optimize DATAOBS\_ENRICH\_GRID, DATAOBS\_ENRICH\_GRID\_RAW when the enrich data is a grid compatible with the input.
* Remove support for s2, geohash in all enrich procedures.
* Optimize performance of all enrich result tables by ordering or clusterizing them.

## September 19, 2022 <a href="#september-19-2022" id="september-19-2022"></a>

### **Module tiler**

Improvement

* Set `version` field in tilers metadata compliant with AT version.

## August 11, 2022 <a href="#august-11-2022" id="august-11-2022"></a>

### **Module tiler**

Improvement

* Unify `extra_metadata` into `metadata` in tiler metadata.

## July 13, 2022 <a href="#july-13-2022" id="july-13-2022"></a>

### **Module data**

Feature

* Add quadbin support to module.

## July 12, 2022 <a href="#july-12-2022" id="july-12-2022"></a>

### **Module tiler**

Fix

* Fix quoting and letter case in spatial index tiler.

## July 8, 2022 <a href="#july-8-2022" id="july-8-2022"></a>

### **Module tiler**

Fix

* Fix wrong uppercase in spatial index tiler.

Improvement

* Use core functions to convert H3 from int to string.

## July 7, 2022 <a href="#july-7-2022" id="july-7-2022"></a>

### **Module h3**

Fix

* Correctly handle large polygons in H3\_POLYFILL.
* Fixed wrong uppercase for quadbin and h3 tile ids

## June 24, 2022 <a href="#june-24-2022" id="june-24-2022"></a>

### **Module quadbin**

Feature

* Add QUADBIN\_BBOX function.
* Add QUADBIN\_BOUNDARY function.
* Add QUADBIN\_CENTER function.
* Add QUADBIN\_FROMGEOGPOINT function.
* Add QUADBIN\_FROMLONGLAT function.
* Add QUADBIN\_FROMZXY function.
* Add QUADBIN\_ISVALID function.
* Add QUADBIN\_KRING function.
* Add QUADBIN\_KRING\_DISTANCES function.
* Add QUADBIN\_POLYFILL function.
* Add QUADBIN\_RESOLUTION function.
* Add QUADBIN\_SIBLINGS function.
* Add QUADBIN\_TOCHILDREN function.
* Add QUADBIN\_TOPARENT function.
* Add QUADBIN\_TOZXY function.

## June 23, 2022 <a href="#june-23-2022" id="june-23-2022"></a>

### **Module tiler**

Improvement

* Add CREATE\_SPATIAL\_INDEX\_TILESET procedure.

## June 15, 2022 <a href="#june-15-2022" id="june-15-2022"></a>

### **Module data**

Improvement

* ENRICH\_ procedures require all the enrich data query rows to be of the same geometry kind (points/lines/polygons) .
* Various optimizations for performance and preventing out-of-memory errors

Improvement

* Errors used to be reported with a procedure result message. Now they raise exceptions.

## May 19, 2022 <a href="#may-19-2022" id="may-19-2022"></a>

### **Module lds**

Improvement

* Add optional `language` parameter to GEOCODE\_REVERSE function.

## May 6, 2022 <a href="#may-6-2022" id="may-6-2022"></a>

### **Module data**

Improvement

* Errors used to be reported with a procedure result message. Now they raise exceptions.

## April 28, 2022 <a href="#april-28-2022" id="april-28-2022"></a>

### **Module data**

Feature

* Allow using tables as input, not just queries.
* Add in place enrichment.

## April 21, 2022 <a href="#april-21-2022" id="april-21-2022"></a>

### **Module tiler**

Improvement

* Add support for non-uppercase column names

## April 20, 2022 <a href="#april-20-2022" id="april-20-2022"></a>

### **Module tiler**

Improvement

* Errors used to be reported with a procedure result message. Now they raise exceptions.

## April 7, 2022 <a href="#april-7-2022" id="april-7-2022"></a>

### **Module transformations**

Feature

* Add ST\_BUFFER function.

## March 25, 2022 <a href="#march-25-2022" id="march-25-2022"></a>

### **Module tiler**

Improvement

* Run the simple tiler in a single query.
* Add `fraction_dropped_per_zoom` to the metadata.

Fix

* Fix empty properties causing errors.
* Fix `drop_fraction_as_needed` in the simple tiler.
* Fix problems with GeometryCollections received after ST\_Simplify.

## March 21, 2022 <a href="#march-21-2022" id="march-21-2022"></a>

### **Module transformations**

Improvement

* ST\_CONCAVEHULL now allows arrays with one/two points as input.

## February 24, 2022 <a href="#february-24-2022" id="february-24-2022"></a>

### **Module tiler**

Feature

* Add CREATE\_SIMPLE\_TILESET procedure.

## February 18, 2022 <a href="#february-18-2022" id="february-18-2022"></a>

### **Module lds**

Feature

* Add GEOCODE\_TABLE procedure.
* Add GEOCODE function.
* Add GEOCODE\_REVERSE function.
* Add ISOLINE function.
* Add LDS\_QUOTA\_INFO function.

## February 16, 2022 <a href="#february-16-2022" id="february-16-2022"></a>

### **Module tiler**

Feature

* Create tiler module.
* Add CREATE\_POINT\_AGGREGATION\_TILESET procedure.

## January 10, 2022 <a href="#january-10-2022" id="january-10-2022"></a>

### **Module data**

Feature

* Add DATAOBS\_SUBSCRIPTIONS procedure.
* Add DATABOS\_SUBSCRIPTION\_VARIABLES procedure.

Improvement

* Read spatial\_catalog tables in source.

## December 15, 2021 <a href="#december-15-2021" id="december-15-2021"></a>

### **Module data**

Improvement

* Missing subscriptions are reported by name in DATAOBS\_ENRICH\_\* procedures

## December 10, 2021 <a href="#december-10-2021" id="december-10-2021"></a>

### **Module random**

Improvement

* ST\_GENERATEPOINTS now uses a spherically uniform distribution. Previously used to by uniform on projection.

## December 3, 2021 <a href="#december-3-2021" id="december-3-2021"></a>

### **Module accessors**

Improvement

* Deployment schema “carto” instead of “accessors”.
* Rename ST\_ENVELOPE function to ST\_ENVELOPE\_ARR.

Removed

* Remove VERSION function.

### **Module constructors**

Improvement

* Deployment schema “carto” instead of “constructors”.

Removed

* Remove VERSION function.

### **Module h3**

Improvement

* Deployment schema “carto” instead of “h3”.
* Rename ST\_ASH3 function to H3\_FROMGEOGPOINT.
* Rename LONGLAT\_ASH3 function to H3\_FROMLONGLAT.
* Rename ST\_ASH3\_POLYFILL function to H3\_POLYFILL.
* Rename ST\_BOUNDARY function to H3\_BOUNDARY.
* Rename ISVALID function to H3\_ISVALID.
* Rename COMPACT function to H3\_COMPACT.
* Rename UNCOMPACT function to H3\_UNCOMPACT.
* Rename TOPARENT function to H3\_TOPARENT.
* Rename TOCHILDREN function to H3\_TOCHILDREN.
* Rename ISPENTAGON function to H3\_ISPENTAGON.
* Rename DISTANCE function to H3\_DISTANCE.
* Rename KRING function to H3\_KRING.
* Rename KRING\_DISTANCES function to H3\_KRING\_DISTANCES.
* Rename HEXRING function to H3\_HEXRING.

Removed

* Remove VERSION function.

### **Module measurements**

Improvement

* Deployment schema “carto” instead of “measurements”.

Removed

* Remove ST\_ANGLE, already present in Snowflake.
* Remove ST\_AZIMUTH, already present in Snowflake.
* Remove VERSION function.

### **Module placekey**

Improvement

* Deployment schema “carto” instead of “placekey”.
* Rename H3\_ASPLACEKEY function to PLACEKEY\_FROMH3.
* Rename PLACEKEY\_ASH3 function to PLACEKEY\_TOH3.
* Rename ISVALID function to PLACEKEY\_ISVALID.

Removed

* Remove VERSION function.

### **Module processing**

Improvement

* Deployment schema “carto” instead of “processing”.

Removed

* Remove VERSION function.

### **Module s2**

Improvement

* Deployment schema “carto” instead of “s2”.
* Rename ID\_FROMHILBERTQUADKEY function to S2\_FROMHILBERTQUADKEY.
* Rename HILBERTQUADKEY\_FROMID function to S2\_TOHILBERTQUADKEY.
* Rename LONGLAT\_ASID function to S2\_FROMLONGLAT.
* Rename ST\_ASID function to S2\_FROMGEOGPOINT.
* Rename ST\_BOUNDARY function to S2\_BOUNDARY.

Removed

* Remove VERSION function.

### **Module transformations**

Improvement

* Deployment schema “carto” instead of “transformations”.

Removed

* Remove VERSION function.

### **Module clustering**

Improvement

* Deployment schema “carto” instead of “clustering”.

Removed

* Remove VERSION function.

### **Module data**

Improvement

* Deployment schema “carto” instead of “data”.

Removed

* Remove VERSION function.

### **Module random**

Improvement

* Deployment schema “carto” instead of “random”.

Removed

* Remove VERSION function.

## November 25, 2021 <a href="#november-25-2021" id="november-25-2021"></a>

### **Module clustering**

Improvement

* Deployment schema “carto” instead of “clustering”.
* Remove VERSION function.

### **Module data**

Improvement

* Deployment schema “carto” instead of “data”.
* Remove VERSION function.

### **Module random**

Improvement

* Deployment schema “carto” instead of “random”.
* Remove VERSION function.

## November 24, 2021 <a href="#november-24-2021" id="november-24-2021"></a>

### **Module data**

Feature

* Add DATAOBS\_ENRICH\_POINTS procedure.
* Add DATAOBS\_ENRICH\_POINTS\_RAW procedure.
* Add DATAOBS\_ENRICH\_POLYGON procedure.
* Add DATAOBS\_ENRICH\_POLYGON\_RAW procedure.
* Add DATAOBS\_ENRICH\_GRID procedure.
* Add DATAOBS\_ENRICH\_GRID\_RAW procedure.

## November 5, 2021 <a href="#november-5-2021" id="november-5-2021"></a>

### **Module data**

Changes

* Fields named `dimension`, `total`, `intersection` and `input_area` are now `__carto_dimension`, `__carto_total` and `__carto_intersection` and `__carto_input_area`. Also the column `_carto_enrichment_` is now `__carto_enrichment`. This affects all the *raw* enrichment procedures: `ENRICH_POINTS_RAW`, `ENRICH_POLYGONS_RAW`, `ENRICH_GRID_RAW`.

Fix

* User provided queries can now have columns named `dimension`, `total`, `intersection`, `input_area`, `_nonglobal`, which could have collided previously with internal columns. All internal columns are now prefixed with `__carto_`. This affects all the enrichment procedures: `ENRICH_POINTS`, `ENRICH_POLYGONS`, `ENRICH_GRID`, `ENRICH_POINTS_RAW`, `ENRICH_POLYGONS_RAW`, `ENRICH_GRID_RAW`.

## November 4, 2021 <a href="#november-4-2021" id="november-4-2021"></a>

### **Module data**

Feature

* Create data module.
* Add VERSION function.
* Add ENRICH\_POINTS procedure.
* Add ENRICH\_POINTS\_RAW procedure.
* Add ENRICH\_POLYGON procedure.
* Add ENRICH\_POLYGON\_RAW procedure.
* Add ENRICH\_GRID procedure.
* Add ENRICH\_GRID\_RAW procedure.

## September 22, 2021 <a href="#september-22-2021" id="september-22-2021"></a>

### **Module h3**

Feature

* Add KRING\_DISTANCES function.

Improvement

* Review HEXRING, KRING functions.

## September 14, 2021 <a href="#september-14-2021" id="september-14-2021"></a>

### **Module s2**

Changes

* Compute ST\_BOUNDARY from WKT.

## August 24, 2021 <a href="#august-24-2021" id="august-24-2021"></a>

### **Module h3**

Fix

* Support GEOMETRYCOLLECTION from ST\_ASH3\_POLYFILL.

## June 2, 2021 <a href="#june-2-2021" id="june-2-2021"></a>

### **Module h3**

Improvement

* Reduce bundle size for every function.

## May 26, 2021 <a href="#may-26-2021" id="may-26-2021"></a>

### **Module processing**

Feature

* Create processing module.
* Add ST\_VORONOIPOLYGONS function.
* Add ST\_VORONOILINES function.
* Add ST\_DELAUNAYPOLYGONS function.
* Add ST\_DELAUNAYLINES function.
* Add ST\_POLYGONIZE function.
* Add VERSION function.

## May 24, 2021 <a href="#may-24-2021" id="may-24-2021"></a>

### **Module clustering**

Feature

* Create clustering module.
* Add VERSION function.
* Add ST\_CLUSTERKMEANS function.

### **Module random**

Feature

* Create random module.
* Add ST\_GENERATEPOINTS function.
* Add VERSION function.

## May 21, 2021 <a href="#may-21-2021" id="may-21-2021"></a>

### **Module accessors**

Feature

* Create accessors module.
* Add ST\_ENVELOPE function.
* Add VERSION function.

## May 20, 2021 <a href="#may-20-2021" id="may-20-2021"></a>

### **Module constructors**

Feature

* Create constructors module.
* Add ST\_BEZIERSPLINE function.
* Add ST\_MAKEELLIPSE function.
* Add ST\_MAKEENVELOPE function.
* Add ST\_TILEENVELOPE function.
* Add VERSION function.

### **Module measurements**

Feature

* Create measurements module.
* Add ST\_ANGLE function.
* Add ST\_AZIMUTH function.
* Add ST\_MINKOWSKIDISTANCE function.
* Add VERSION function.

### **Module transformations**

Feature

* Create transformations module.
* Add ST\_CENTERMEAN function.
* Add ST\_CENTERMEDIAN function.
* Add ST\_CENTEROFMASS function.
* Add ST\_CONCAVEHULL function.
* Add ST\_DESTINATION function.
* Add ST\_GREATCIRCLE function.
* Add ST\_LINE\_INTERPOLATE\_POINT function.
* Add VERSION function.

## April 16, 2021 <a href="#april-16-2021" id="april-16-2021"></a>

### **Module placekey**

Feature

* Create placekey module.
* Add H3\_ASPLACEKEY function.
* Add PLACEKEY\_ASH3 function.
* Add ISVALID function.
* Add VERSION function.

## April 12, 2021 <a href="#april-12-2021" id="april-12-2021"></a>

### **Module s2**

Feature

* Create s2 module.
* Add ID\_FROMHILBERTQUADKEY function.
* Add HILBERTQUADKEY\_FROMID function.
* Add LONGLAT\_ASID function.
* Add ST\_ASID function.
* Add ST\_BOUNDARY function.
* Add VERSION function.

## April 7, 2021 <a href="#april-7-2021" id="april-7-2021"></a>

### **Module h3**

Feature

* Create h3 module.
* Add ST\_ASH3 function.
* Add LONGLAT\_ASH3 function.
* Add ST\_ASH3\_POLYFILL function.
* Add ST\_BOUNDARY function.
* Add ISVALID function.
* Add COMPACT function.
* Add UNCOMPACT function.
* Add TOPARENT function.
* Add TOCHILDREN function.
* Add ISPENTAGON function.
* Add DISTANCE function.
* Add KRING function.
* Add HEXRING function.
* Add VERSION function.