# Release notes

## March 27th, 2026 (v1.23.1)

**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.

**Module s2**

Fix

* [S2\_TOTOKEN](https://docs.carto.com/data-and-analysis/sql-reference/s2#s2_totoken) and [S2\_FROMTOKEN](https://docs.carto.com/data-and-analysis/sql-reference/s2#s2_fromtoken) now produce standard 16-character tokens, fixing an issue where non-standard tokens were generated.

## December 31st, 205 (v1.23.0)

**Module data**

New

* A new version of the [ENRICH\_POLYGONS\_WEIGHTED](https://docs.carto.com/data-and-analysis/sql-reference/data#enrich_polygons_weighted) procedure has been created in order to allow both weighted sources and weighted targets.

{% hint style="info" %}
This version of the Analytics Toolbox introduces a breaking change in `ENRICH_POLYGONS_WEIGHTED`. In order to keep using the same signature and functionality of the previous version, there is a `ENRICH_POLYGONS_WEIGHTED_LEGACY` procedure that can still be used.
{% endhint %}

**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.22.4)

**Module data**

New

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

{% hint style="warning" %}
The upcoming **December release** will contain a **breaking change** in `ENRICH_POLYGONS_WEIGHTED` that will modify the procedure's signature but will substantially increase performance.\
If you have any analysis that uses the procedure, make sure it is using `ENRICH_POLYGONS_WEIGHTED_LEGACY`, which will continue using the previous signature.
{% endhint %}

## October 24th, 2025 (v1.22.3)

**Module data**

Fix

* Updated [ENRICH\_POLYGONS\_WEIGHTED](https://docs.carto.com/data-and-analysis/sql-reference/data#enrich_polygons_weighted) in order to avoid creating rows that exceed 100MB, improving performance and avoiding errors.

**Module statistics**

Fix

* Updated [GWR\_GRID](https://docs.carto.com/data-and-analysis/sql-reference/statistics#gwr_grid) detection algorithm in order to support working with both input queries and tables.

## August 25th, 2025 (v1.22.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.

**Module data**

Fix

* Enrichment procedures now use `ST_ASBINARY` for geometry comparison in replacement of `ST_EQUALS` which was creating more rows than there were contained in the input data.

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

**Module lds**

Fix

* Adjusted coordinates precision in [CREATE\_ISOLINES](https://docs.carto.com/data-and-analysis/sql-reference/lds#create_isolines) to be able to update the output table successfully, avoiding null values in it.
* Added a change to avoid additional calls to remote functions in LDS procedures when updating the output table. It was causing some procedures to crash and making it easier to reach the BigQuery concurrent remote functions limit.

New

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

## May 14th, 2025 (v1.22.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.21.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 statistics**

Improvement

* Added a new KMEANS\_INIT\_METHOD option to [TIME\_SERIES\_CLUSTERING](https://docs.carto.com/data-and-analysis/sql-reference/statistics#time_series_clustering) procedure.

**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

## February 27th, 2025 (v1.20.1)

**Module lds**

Fix

* Fixed an issue with [GEOCODE\_TABLE](https://docs.carto.com/data-and-analysis/sql-reference/lds#geocode_table) and [CREATE\_ROUTES](https://docs.carto.com/data-and-analysis/sql-reference/lds#create_routes) procedure to avoid losing already calculated results when the process is interrupted when using TomTom as provider.

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

**Module h3**

Fix

* Fixed an issue with [H3\_POLYFILL](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/h3#h3_polyfill), [H3\_POLYFILL\_MODE](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/h3#h3_polyfill_mode), and [H3\_POLYFILL\_TABLE](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/h3#h3_polyfill_table-beta) that was not working with geographies containing holes.

**Module quadbin**

Fix

* Fixed an issue with [QUADBIN\_POLYFILL](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/quadbin#quadbin_polyfill), [QUADBIN\_POLYFILL\_MODE](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/quadbin#quadbin_polyfill_mode) and [QUADBIN\_POLYFILL\_TABLE](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/quadbin#quadbin_polyfill_table-beta) that was not working with geographies containing holes.

**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 an issue with the [CREATE\_SPATIAL\_COMPOSITE\_UNSUPERVISED](https://docs.carto.com/data-and-analysis/sql-reference/statistics#create_spatial_composite_unsupervised) procedure that was returning a “Resources exceeded during query execution error” when “scaling” was set to “RANKING”.

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

**Module lds**

Improvement

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

Fix

* Fixed an issue with [CREATE\_ROUTES](https://docs.carto.com/data-and-analysis/sql-reference/lds#create_routes) that prevented working with duplicate routes.

**Module cpg**

Fix

* Fixed an issue with [CUSTOMER\_SEGMENTATION\_ANALYSIS\_DATA](https://docs.carto.com/data-and-analysis/sql-reference/cpg#customer_segmentation_analysis_data) and [RUN\_CUSTOMER\_SEGMENTATION](https://docs.carto.com/data-and-analysis/sql-reference/cpg#run_customer_segmentation) procedures that pevented them from working on a VPC environment.

**Module data**

Fix

* Fixed an issue with [DATAOBS\_ENRICH\_GRID\_WEIGHTED](https://docs.carto.com/data-and-analysis/sql-reference/data#dataobs_enrich_grid_weighted), [DATAOBS\_ENRICH\_POLYGONS\_WEIGHTED](https://docs.carto.com/data-and-analysis/sql-reference/data#dataobs_enrich_polygons_weighted) and [ENRICH\_POLYGONS\_WEIGHTED](https://docs.carto.com/data-and-analysis/sql-reference/data#enrich_polygons_weighted) procedures procedures that pevented them from working on a VPC environment. .

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

**Module statistics**

New

* Added [KRING](https://docs.carto.com/data-and-analysis/sql-reference/statistics#kring_spacetime_aggregate) procedures for aggregation & smoothing of spatial index datasets.

**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.

**Module data**

Fix

* Fixed a problem with [ENRICH\_POLYGONS\_WEIGHTED](https://docs.carto.com/data-and-analysis/sql-reference/data#enrich_polygons_weighted) that prevented [Enrich Polygons with weights](https://docs.carto.com/carto-user-manual/workflows/components/data-enrichment#enrich-polygons-with-weights) component in Workflows from working with more than one component per workflow.

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

**Module data**

Fix

* Fixed a problem with [DATAOBS\_ENRICH\_POLYGONS\_WEIGHTED](https://docs.carto.com/data-and-analysis/sql-reference/data#dataobs_enrich_polygons_weighted) and [ENRICH\_POLYGONS\_WEIGHTED](https://docs.carto.com/data-and-analysis/sql-reference/data#enrich_polygons_weighted) that caused an issue when min, max, or count were used as aggregation methods for weight variables.

**Module lds**

Improvement

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

**Module cpg**

Fix

* Modify [RUN\_CUSTOMER\_SEGMENTATION](https://docs.carto.com/data-and-analysis/sql-reference/cpg#run_customer_segmentation) procedures to overwrite internal temp tables and avoid crashing when called twice in the same session.

**Module retail**

Fix

* Modify [COMMERCIAL\_HOTSPOTS](https://docs.carto.com/data-and-analysis/sql-reference/retail#commercial_hotspots), [FIND\_TWIN\_AREAS](https://docs.carto.com/data-and-analysis/sql-reference/retail#find_twin_areas), FIND\_TWIN\_AREAS\_V1 (discontinued version), [FIND\_TWIN\_AREAS\_WEIGHTED](https://docs.carto.com/data-and-analysis/sql-reference/retail#find_twin_areas_weighted) and FIND\_TWIN\_AREAS\_WEIGHTED\_V1 (discontinued version) procedures to overwrite internal temp tables and and avoid crashing when called twice in the same session.

**Module statistics**

Fix

* Modify [AREA\_OF\_APPLICABILITY](https://docs.carto.com/data-and-analysis/sql-reference/statistics#area_of_applicability), [ORDINARY\_KRIGING\_TABLE](https://docs.carto.com/data-and-analysis/sql-reference/statistics#ordinary_kriging_table), [SMOOTHING\_MRF\_H3](https://docs.carto.com/data-and-analysis/sql-reference/statistics#smoothing_mrf_h3), [SMOOTHING\_MRF\_QUADBIN](https://docs.carto.com/data-and-analysis/sql-reference/statistics#smoothing_mrf_quadbin) and SMOOTHING\_MRF\_QUADINT (discontinued version) procedures to overwrite internal temp tables and avoid crashing when called twice in the same session.

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

**Module tiler**

New

* Add `tile_resolution` to all [tileset](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/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**

New

* Add [DETECT\_SPATIAL\_ANOMALIES](https://docs.carto.com/data-and-analysis/sql-reference/statistics#detect_spatial_anomalies) and [DETECT\_SPACETIME\_ANOMALIES](https://docs.carto.com/data-and-analysis/sql-reference/statistics#detect_spacetime_anomalies) procedures for detecting anomalous space-time regions in the data. This new capability allows for uncovering unusual patterns in historical spatial or space-time data and for accurately identifying emerging anomalous patterns in space and time.

Fix

* Modify [GETIS\_ORD\_SPACETIME\_QUADBIN\_TABLE](https://docs.carto.com/data-and-analysis/sql-reference/statistics#getis_ord_spacetime_quadbin_table) and [GETIS\_ORD\_SPACETIME\_H3\_TABLE](https://docs.carto.com/data-and-analysis/sql-reference/statistics#getis_ord_spacetime_h3_table) procedures to overwrite internal temp tables and not crash when called twice in the same session.

**Module telco**

Fix

* Fix input format of `terrain_raster_band` in [TELCO\_PATH\_PROFILE\_RASTER](https://docs.carto.com/data-and-analysis/sql-reference/telco#telco_path_profile_raster) procedure.

## August 23rd, 2024 (v1.15.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.15.0)

**Module lds**

Fix

* Fixed a bug where there was more than one matching row in the target for each row in the source. [`GEOCODE_REVERSE_TABLE`](https://docs.carto.com/data-and-analysis/sql-reference/lds#geocode_reverse_table) now use `ST_DISTINCT` to solve this issue

**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

* 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. Additionally, the option `intersect_center` is supported in both procedures to use the centroid of the pixel instead of the contour, in order to speed up the extraction/aggregation for relatively big polygons.
* 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.

**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.

**Module telco**

New

* New [`TELCO_PATH_PROFILE`](https://docs.carto.com/data-and-analysis/sql-reference/telco#telco_path_profile) procedure, that finds the path between the transmitter (Tx) and receiver (Rx), the obstacles that exist along the propagation path, i.e. those that intersect with the propagation line, and then it evaluates the impact of each obstacle's height
* New [`TELCO_PATH_PROFILE_RASTER`](https://docs.carto.com/data-and-analysis/sql-reference/telco#telco_path_profile_raster) procedure, an optimised version of the nominal TELCO\_PATH\_PROFILE procedure which only accepts as inputs a clutter and a terrain elevation rasters loaded using CARTO raster loader or Import API.
* New [`CLOSE_IN`](https://docs.carto.com/data-and-analysis/sql-reference/telco#close_in): This procedure implements a statistical propagation model that describes large-scale propagation path loss over distance at all relevant frequencies in a certain outdor scenario.
* New [`EXTENDED_HATA`](https://docs.carto.com/data-and-analysis/sql-reference/telco#extended_hata): This new procedure implements the empirical propagation model **Extended HATA** for radio propagation path loss for the range of frequencies 30 MHz - 3000 MHz in an outdoor scenario.

**Module quadbin**

Improvement

* Improved [QUADBIN\_POLYFILL\_MODE](https://docs.carto.com/data-and-analysis/sql-reference/quadbin#quadbin_polyfill_mode) and [QUADBIN\_POLYFILL\_TABLE](https://docs.carto.com/data-and-analysis/sql-reference/quadbin#quadbin_polyfill_table-beta) performance with big polygons on high-resolution cells.

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

**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.13.0)

**Module raster**

New

* Added new [`RASTER_VALUES`](https://docs.carto.com/analytics-toolbox-for-snowflake/sql-reference/raster#raster_values) and [`RASTER_AGG_VALUES`](https://docs.carto.com/data-and-analysis/sql-reference/raster#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 lds**

Fix

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

## March 21st, 2024 (v1.12.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 data**

New

* Add [ENRICH\_POLYGONS\_WEIGHTED](https://docs.carto.com/data-and-analysis/sql-reference/data#enrich_polygons_weighted) procedure. This new procedure enables users to enrich polygons with a provided data query by taking into account the ratio of a specified feature between the intersected and original areas in a way to weigh the contribution of each feature in the enrichment. Note that the original methods only use the geographic area of intersection for this weight.

**Module statistics**

Fix

* Fix output table schema on the SQL Reference 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/analytics-toolbox-for-snowflake/sql-reference/statistics#create_spatial_composite_unsupervised).
* Add support in the [CRONBACH\_ALPHA\_COEFFICIENT](https://docs.carto.com/data-and-analysis/sql-reference/statistics#cronbach_alpha_coefficient) procedure for supporting ‘`NUMERIC`’, ‘`BIGNUMERIC`’.

**Module random**

Fix

* [ST\_GENERATEPOINTS](https://docs.carto.com/data-and-analysis/sql-reference/random#st_generatepoints) now guarantees to return the exact number of points requested.

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

**Module retail**

Fix

* Fixed aggregation column name suffix in [BUILD\_CANNIBALIZATION\_DATA](https://docs.carto.com/data-and-analysis/sql-reference/retail#build_cannibalization_data).

**Module statistics**

Fix

* Set null weights to 0 to standarize results in all [Moran's I](https://docs.carto.com/data-and-analysis/sql-reference/statistics#morans_i_h3_table) and [Local Moran's I](https://docs.carto.com/data-and-analysis/sql-reference/statistics#local_morans_i_h3_table).
* Add warning to [Moran's I](https://docs.carto.com/data-and-analysis/sql-reference/statistics#morans_i_h3_table) procedures when no cells have neighbors.

## January 18th, 2024 (v1.11.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º).

**Module h3**

Fix

* Fixed an issue with the [H3\_POLYFILL\_TABLE](https://docs.carto.com/data-and-analysis/sql-reference/h3#h3_polyfill_table-beta) procedure that was not working due to a broken function reference.

**Module transformations**

New

* New [ST\_POINTONSURFACE](https://docs.carto.com/data-and-analysis/sql-reference/transformations#st_pointonsurface) function that returns a point contained within a given polygon.

**Module tiler**

Fix

* Support adding properties from BIGNUMERIC columns in the [CREATE\_TILESET](https://docs.carto.com/data-and-analysis/sql-reference/tiler#create_tileset) procedure.

**Module data**

Fix

* Fixed an issue when using AVG aggregation, that was not correctly computed when “data\_query” contained NULL values.
* Fixed a problem with [DATAOBS\_ENRICH\_POINTS](https://docs.carto.com/data-and-analysis/sql-reference/data#dataobs_enrich_points), that was not parsing vars metadata correctly and producing a crash.
* Fixed a problem when using “Default” aggregation in [DATAOBS\_ENRICH\_](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/data)\* procedures.

**Module lds**

Fix

* Fixed a problem that caused [GEOCODE\_REVERSE\_TABLE](https://docs.carto.com/data-and-analysis/sql-reference/lds#geocode_reverse_table) crash when a table contains multiple points very close to each other.

**Module raster**

Improvement

* Support [COUNTIF](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#countif) aggregation method in [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.

**Module statistics**

Fix

* Added a normalization constant for [MORANS\_I\_](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics)\* procedures

## December 21, 2023 (v1.10.0)

**Module raster**

New

* New [`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: updated raster format, introduced performance optimizations and support for custom operations, including multi-band and aggregation expressions.
* [Raster loader v0.4.0](https://raster-loader.readthedocs.io/en/latest/user_guide/installation.html): supports new raster format, upload multiple bands and performance optimizations.

Deprecated

* Previous versions of `RASTER` procedures in beta

**Module retail**

Improvement

* Updated [`FIND_TWIN_AREAS`](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/retail) procedures to also work with categorical data.
* The previous version of the Twin Areas procedures are still available as:
  * [`FIND_TWIN_AREAS_V1`](https://docs.carto.com/data-and-analysis/sql-reference/retail#find_twin_areas_v1)
  * [`FIND_TWIN_AREAS_WEIGHTED_V1`](https://docs.carto.com/data-and-analysis/sql-reference/retail#find_twin_areas_weighted_v1)

**Module cpg**

Improvement

* Updated [`FIND_SIMILAR_LOCATIONS`](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/cpg) procedures to also work with categorical data.
* The previous version of the Twin Areas procedures are still available as:
  * [`FIND_SIMILAR_LOCATIONS_V1`](https://docs.carto.com/data-and-analysis/sql-reference/cpg#find_similar_locations_v1)
  * [`FIND_SIMILAR_LOCATIONS_WEIGHTED_V1`](https://docs.carto.com/data-and-analysis/sql-reference/cpg#find_similar_locations_weighted_v1)

**Module tiler**

Fix

* Fixed a bug in [CREATE\_POINT\_AGGREGATION\_TILESET](https://docs.carto.com/data-and-analysis/sql-reference/tiler#create_point_aggregation_tileset) procedure that was causing issues for generating higher zoom level tiles.

**Module data**

Improvement

* Updated [`GRIDIFY_ENRICH`](https://docs.carto.com/data-and-analysis/sql-reference/data#gridify_enrich) procedures to also work with categorical data.
* The previous version of the procedure is still available as [`GRIDIFY_ENRICH_V1`](https://docs.carto.com/data-and-analysis/sql-reference/data#gridify_enrich_v1)

Deprecated

* Old quadint/quadkey support in all procedures

## November 13, 2023 (v1.9.0)

**Module lds**

New

* Add [`SETUP`](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/lds#setup) procedure. This procedure helps configuring the Analytics Toolbox in custom installations. Check [this documentation](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/getting-access/manual-installation-in-your-own-project) about installing the Analytics Toolbox in your own BigQuery project for more information.
* Add LDS functions: [`GEOCODE`](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/lds#geocode), [`GEOCODE_REVERSE`](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/lds#geocode_reverse), [`ISOLINE`](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/lds#isoline). This functions complement the already existing procedures. They allow geocoding a single address or getting a single isoline without creating a result table.
* Replace `LDS_QUOTA_INFO` procedure with [`GET_LDS_QUOTA_INFO`](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/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.

Fix

* Correctly handle addresses with quotes in [`GEOCODE_TABLE`](https://docs.carto.com/data-and-analysis/sql-reference/lds#geocode_table).

**Module data**

Change

* Change location of spatial catalog tables: This is only an internal change. Now the catalog is hosted along with the Data Observatory subscriptions. This change decouples the Analytics Toolbox location from the Data Observatory location, providing more flexibility for future developments.

**Module statistics**

Fix

* Use temporal tables to avoid existing issues in [`GETIS_ORD_SPACETIME`](https://docs.carto.com/data-and-analysis/sql-reference/statistics#getis_ord_spacetime_quadbin).

**Module retail**

Fix

* Fix bugs in kring decay procedures: `KRING_DECAY`, `KRING_DECAY_GRID`. These procedure are used internally by other procedures. They work finding cells that are within the K-Ring of each cell in a grid, and assigns a weight based on the distance. This helps model changes in a variable across neighboring cells.\\

**Module cpg**

Change

* Adapt [composite score supervised procedures](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/cpg#create_spatial_performance_score): The algorithm used for computing supervised composite scores has been changed from `BOOSTED_TREE_REGRESSOR` to [`RANDOM_FOREST_REGRESSOR`](https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-create-random-forest) to avoid overfitting.

## October 13, 2023 (v1.8.0)

**Module statistics**

New

* We have added new PCAMIX procedures:
  * [BUILD\_PCAMIX\_DATA](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#build_pcamix_data): to create the data used by the PCAMIX method
  * [BUILD\_PCAMIX\_MODEL](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#build_pcamix_model): to train a PCA model using the PCAMIX method
  * [PREDICT\_PCAMIX\_SCORES](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#predict_pcamix_scores): to predict the PC scores on the trained/new data

**Module retail**

Improvement

* Improved performance in the [COMMERCIAL\_HOTSPOTS](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/retail#commercial_hotspots) procedure.

**Module lds**

Improvement

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

## September 8, 2023 (v1.7.0)

**Module statistics**

New

* Added `_TABLE` procedures for some statistic functions. The `_TABLE` version of the procedures expect a table as input, overcoming performance limitations of the functions that receive an array as input:
  * [KNN\_TABLE](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#knn_table)
  * [GFUN\_TABLE](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#gfun_table)
  * [GETIS\_ORD\_H3\_TABLE](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#getis_ord_h3_table)
  * [GETIS\_ORD\_QUADBIN\_TABLE](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#getis_ord_quadbin_table)
  * [GETIS\_ORD\_SPACETIME\_H3\_TABLE](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#getis_ord_spacetime_h3_table)
  * [GETIS\_ORD\_SPACETIME\_QUADBIN\_TABLE](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#getis_ord_spacetime_quadbin_table)
  * [MORANS\_I\_H3\_TABLE](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#morans_i_h3_table)
  * [MORANS\_I\_QUADBIN\_TABLE](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#morans_i_quadbin_table)
  * [LOCAL\_MORANS\_I\_H3\_TABLE](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#local_morans_i_h3_table)
  * [LOCAL\_MORANS\_I\_QUADBIN\_TABLE](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#local_morans_i_quadbin_table)

**Module retail**

Fix

* Fix default options for [BUILD\_REVENUE\_MODEL](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/retail#build_revenue_model) that were causing errors when using [linear regression models](https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-create-glm)

New

* [BUILD\_REVENUE\_MODEL](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/retail#build_revenue_model) now supports [random forest models](https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-create-random-forest)

**Module lds**

Fix

* Fix `GEOCODE_TABLE` not iterating through input table rows.

## August 7, 2023 (v1.6.0)

**Module cpg**

New

* We have added the new procedures [CREATE\_SPATIAL\_SCORE](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/cpg#create_spatial_score) and [CREATE\_SPATIAL\_PERFORMANCE\_SCORE](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/cpg#create_spatial_performance_score) to allow users create scores to analyze their network of merchants/point-of-sale based on a business performance metrics or geospatial attributes to analyze their suitability for the CPG brands.

**Module statistics**

Fix

* We have fixed order of return values in [LOCAL\_MORANS\_I\_H3](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#local_morans_i_h3) and [LOCAL\_MORANS\_I\_QUADBIN](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#local_morans_i_quadbin) functions.

**Module h3**

New

* We have added a new function [H3\_POLYFILL\_MODE](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/h3#h3_polyfill_mode) that enables different polyfill modes: center, intersects, contains.

Improvement

* We have improved the performance of [H3\_POLYFILL](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/h3#h3_polyfill) by an average factor of 60x.

**Module quadbin**

New

* We have added a new function [QUADBIN\_POLYFILL\_MODE](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/quadbin#quadbin_polyfill_mode) that enables different polyfill modes: center, intersects, contains.

Improvement

* We have improved the performance of [QUADBIN\_POLYFILL](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/quadbin#quadbin_polyfill) by an average factor of 10x.

## July 14, 2023 (v1.5.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-bigquery/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.

Fix

* We have applied some fixes to the [CREATE\_ROUTES](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/lds#create_routes) function so the metadata column can be successfully created and informed.

**Module data**

New

* We have added the new procedures [DATAOBS\_ENRICH\_POLYGONS\_WEIGHTED](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/data#dataobs_enrich_polygons_weighted) and [DATAOBS\_ENRICH\_GRID\_WEIGHTED](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/data#dataobs_enrich_grid_weighted). They allow users to enrich polygons or grids based on spatial indexes (e.g. H3, Quadbin) with features from Data Observatory subscriptions by taking into account the ratio of a specified feature between the intersected and original areas in a way to weight the contribution of each feature in the enrichment. Note that the original methods only use the geographic area of intersection for this weight.

Fix

* We have updated the [GRIDIFY\_ENRICH](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/data#gridify_enrich) procedure so the default value for the “decay” function is taken into consideration.

**Module retail**

New

* We have added the possibility of passing custom polygons as trade areas in [BUILD\_CANNIBALIZATION\_DATA](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/cpg#build_cannibalization_data) and [CANNIBALIZATION\_OVERLAP](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/cpg#cannibalization_overlap).

Fix

* We added exceptions to both [FIND\_TWIN\_AREAS](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/retail#find_twin_areas) and [FIND\_TWIN\_AREAS\_WEIGHTED](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/retail#find_twin_areas_weighted) procedures to ensure that the parameter “origin\_query” includes only one row (the origin cell).

**Module statistics**

New

* We are now allowing to use Numeric and Bignumeric as predictors data types types in the procedures: [AREA\_OF\_APPLICABILITY](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#area_of_applicability), [ENV\_BLOCKING](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#env_blocking) and [CREATE\_SPATIAL\_COMPOSITE\_SUPERVISED](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#create_spatial_composite_supervised).

Fix

* We modified the bucketization options in [CREATE\_SPATIAL\_COMPOSITE\_SUPERVISED](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#create_spatial_composite_supervised) and in [CREATE\_SPATIAL\_COMPOSITE\_UNSUPERVISED](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#create_spatial_composite_unsupervised) to better fit potential use cases covered by each procedure.

**Module quadbin**

Change

* We have updated the formula used in [QUADBIN\_FROMLONGLAT](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/quadbin#quadbin_fromlonglat) so it gets standardized. In addition a new implementation of [QUADBIN\_TOCHILDREN](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/quadbin#quadbin_tochildren) has been added in order to increase performance.

## June 6, 2023 (v1.4.0)

**Module lds**

New

* We have created a new procedure named [CREATE\_ROUTES](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/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.

**Module statistics**

New

* We have added new functions in the statistics module to perform space-time cluster analysis, namely [GETIS\_ORD\_SPACETIME\_QUADBIN](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#getis_ord_spacetime_quadbin) for quadbin indexes and [GETIS\_ORD\_SPACETIME\_H3](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#getis_ord_spacetime_h3) for H3 indexes.

Fix

* We have changed the input type and defined default values for some internal parameters that affect [CREATE\_SPATIAL\_COMPOSITE\_SUPERVISED](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#create_spatial_composite_supervised) and [CREATE\_SPATIAL\_COMPOSITE\_UNSUPERVISED](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#create_spatial_composite_unsupervised). Also added some missing brackets to them.
* Changed code to improve scalability in [CREATE\_SPATIAL\_COMPOSITE\_UNSUPERVISED](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#create_spatial_composite_unsupervised).
* Renamed internal function names to avoid possible conflicts in the future.

**Module cpg**

Fix

* We have introduced a better way to handle large tables and drop intermediate tables in the [UNIVERSE\_MATCHING](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/cpg#universe_matching) function.

**Module tiler**

New

* We have added metadata\_partition option to [CREATE\_TILESET](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/tiler#create_tileset), [CREATE\_SIMPLE\_TILESET](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/tiler#create_simple_tileset), [CREATE\_POINT\_AGGREGATION\_TILESET](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/tiler#create_point_aggregation_tileset), [CREATE\_SPATIAL\_INDEX\_TILESET](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/tiler#create_spatial_index_tileset). A metadata\_partition label is added to the table when the partition is not NULL. This optimizes tilesets for its use within CARTO.

## May 5, 2023 (v1.3.0)

**Module statistics**

New

* Set of procedures to compute Area of Applicability of a model built with BigQuery ML:
  * [AREA\_OF\_APPLICABILITY](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#area_of_applicability): This procedure computes the Area of Applicability (AOA) of a Bigquery ML model. It generates a metric which tells the user where the results from a Machine Learning (ML) model can be trusted when the predictions are extrapolated outside the training space (i.e. where the estimated cross-validation performance holds).
  * [ENV\_BLOCKING](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#env_blocking): This procedure derives cross validation (CV) folds based on[ environmental blocking](https://besjournals.onlinelibrary.wiley.com/doi/full/10.1111/2041-210X.13107).

Fix

* We have added a new mandatory parameter called correlation\_var when scoring\_method = FIRST\_PC in the [CREATE\_SPATIAL\_COMPOSITE\_UNSUPERVISED](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/statistics#create_spatial_composite_unsupervised)
* We have improved the management of temporary tables in all procedures to compute spatial composites (scores)

**Module raster (beta)**

Improvement

* We have released a new version of the [raster-loader (v0.3.1)](https://raster-loader.readthedocs.io/en/latest/index.html), with the following improvements:
  * Store ‘nodata’ value in metadata
  * Add resolution level to metadata
  * Fix bands metadata aggregation
* We allow for the use of ‘nodata’ metadata in [RASTER\_ST\_GETVALUE](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/sql-reference/raster#raster_st_getvalue)
* We have released experimental rendering capabilities for the raster data in deck.gl: <https://deck.gl/docs/api-reference/carto/carto-layer#raster-data-experimental>

## April 4, 2023 (v1.2.0)

**Module statistics**

New

* We have released a new set of procedures within the statistics module to enable users to [create spatial scores](https://academy.carto.com/advanced-spatial-analytics/spatial-analytics-for-bigquery/step-by-step-tutorials/how-to-create-a-composite-score-with-your-spatial-data) (also known as [composite indicators](https://www.oecd.org/sdd/42495745.pdf) or indexes) derived from a combination of different features. We have included 3 different procedures:
  * [CREATE\_SPATIAL\_COMPOSITE\_SUPERVISED](https://docs.carto.com/data-and-analysis/sql-reference/statistics#create_spatial_composite_supervised): to compute a spatial composite score as the residuals of a regression model which is used to detect areas of under- and over-prediction.
  * [CREATE\_SPATIAL\_COMPOSITE\_UNSUPERVISED](https://docs.carto.com/data-and-analysis/sql-reference/statistics#create_spatial_composite_unsupervised): to perform an aggregation of individual variables, scaled and weighted accordingly, into a spatial composite score.
  * [CRONBACH\_ALPHA\_COEFFICIENT](https://docs.carto.com/data-and-analysis/sql-reference/statistics#cronbach_alpha_coefficient): to measure the internal consistency of the variables used to derive the spatial composite score.

**Module lds**

Change

* We have updated the [LDS module](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-bigquery/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.

Fix

* [GEOCODE\_TABLE](https://docs.carto.com/data-and-analysis/sql-reference/lds#geocode_table) now supports null values in the input address column, ignoring them when running the geocoding process to provide results only for the informed addresses.

## March 7, 2023 (v1.1.0)

**Module raster (beta)**

Improvement

{% hint style="warning" %}
**Note**

The raster module of the Analytics Toolbox for BigQuery v1.1.0 will work only with raster-loader v0.3.0, which pre-computes and stores metadata in the raster table and homogenizes the generic/quadbin raster table format. So, if you update your Analytics Toolbox version to the most recent v1.1.0, please ensure you are using the raster-loader v0.3.0.
{% endhint %}

* We have made the [RASTER\_GETMETADATA](https://docs.carto.com/data-and-analysis/sql-reference/raster#raster_getmetadata) faster by retrieving metadata from the table and avoiding creating again the original table.
* We have improved the [RASTER\_ST\_GETVALUE](https://docs.carto.com/data-and-analysis/sql-reference/raster#raster_st_getvalue) by removing pixel\_geog column and cluster results by quadbin in the quadbin raster format.
* We have enhanced the [RASTER\_ST\_GETVALUE\_FROM\_TABLE](https://docs.carto.com/data-and-analysis/sql-reference/raster#raster_st_getvalue_from_table) outcome by preserving the input columns, renaming centroid\_quadbin\_block and centroid\_quadbin\_pixel to block\_quadbin and quadbin, clustering the results by quadbin in quadbin raster and removing few non-informative columns (e.g. geog and myoffset).

**Module cpg**

New

* We have released a new set of functions to enable users to perform the merchant universe matching analysis. It includes 2 different functions, [UNIVERSE\_MATCHING](https://docs.carto.com/data-and-analysis/sql-reference/cpg#universe_matching) which performs a fuzzy match between two different POI datasets based on location and name similarity (i.e. one dataset should include current merchants and the other one the complete universe of all potential merchants), and [UNIVERSE\_MATCHING\_REPORT](https://docs.carto.com/data-and-analysis/sql-reference/cpg#universe_matching_report) that generates report-like tables summarizing market penetration based on the results of the [UNIVERSE\_MATCHING](https://docs.carto.com/data-and-analysis/sql-reference/cpg#universe_matching) analysis.

Fix

* We have implemented a fix in the [CUSTOMER\_SEGMENTATION\_ANALYSIS\_DATA](https://docs.carto.com/data-and-analysis/sql-reference/cpg#customer_segmentation_analysis_data).

**Module lds**

Improvement

* From this version, we support line break (\n) and other escaped sequences in addresses in [GEOCODE\_TABLE](https://docs.carto.com/data-and-analysis/sql-reference/lds#geocode_table).

## January 31, 2023 (v1.0.0)

**Raster module (beta)**

New

{% hint style="warning" %}
Note that Analytics Toolbox for BigQuery v1.0.0 will work only with raster-loader v0.2.0, to use the latest version of rater-loader please ensure you also have access to the latest version of the Analytics Toolbox
{% endhint %}

* New module to operate with raster data in BigQuery. This module includes the procedures [RASTER\_ST\_GETVALUE](https://docs.carto.com/data-and-analysis/sql-reference/raster#raster_st_getvalue) and [RASTER\_ST\_GETVALUE\_FROM\_TABLE](https://docs.carto.com/data-and-analysis/sql-reference/raster#raster_st_getvalue_from_table) to obtain the values of the raster in one or multiple geographies, respectively. It also includes the [RASTER\_GETMETADATA](https://docs.carto.com/data-and-analysis/sql-reference/raster#raster_getmetadata) procedure to obtain metadata associated with the raster file.

**Routing module (beta)**

Improvement

* New enhanced version of the routing module with procedures [ROUTING\_MATRIX](https://docs.carto.com/data-and-analysis/sql-reference/routing#routing_matrix) to calculate origin-destination matrices and [ROUTING\_ISOLINES](https://docs.carto.com/data-and-analysis/sql-reference/routing#routing_isolines) to compute isolines around a set of locations, both supporting multiple transportation modes (car, bike, and walk). These new functions run on top of CARTO’s road network (derived from OSM segments) that is available as a public subscription in the Data Observatory. Please note that these improvements imply breaking changes with the previous version of the routing module.

**Module retail**

Fix

* Fix in [CANNIBALIZATION\_OVERLAP](https://docs.carto.com/data-and-analysis/sql-reference/retail#cannibalization_overlap) procedure / example.
* Fix in [TWIN\_AREAS\_WEIGHTED](https://docs.carto.com/data-and-analysis/sql-reference/retail#find_twin_areas_weighted) when sum is 1.

**Module statistics**

New

* Add [IDW](https://docs.carto.com/data-and-analysis/sql-reference/statistics#idw) function (Inverse Distance Weighted).

**Module tiler**

Improvement

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

## December 22, 2022

**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. Please note that these improvements imply breaking changes with the previous version of the CREATE\_ISOLINES functions.
* Added new confidence/relevance metadata to the results of the geocoding function [GEOCODE\_TABLE](https://docs.carto.com/analytics-toolbox-for-redshift/sql-reference/lds#geocode_table). Please note that this improvement has implied breaking changes with the previous versions of the GEOCODE\_TABLE and [GEOCODE\_REVERSE\_TABLE](https://docs.carto.com/analytics-toolbox-for-redshift/sql-reference/lds#geocode_reverse_table) functions.

**Module cpg**

New

* New [FIND\_SIMILAR\_LOCATIONS](https://docs.carto.com/data-and-analysis/sql-reference/cpg#generate_trade_areas) function to the CPG module, that allows users to identify which locations (e.g. merchants, stores) are more similar to a chosen location (e.g. top performant) based on the characteristics of their surrounding areas (or trade areas).

**Module retail**

Improvement

* Update in [BUILD\_CANNIBALIZATION\_DATA](https://docs.carto.com/data-and-analysis/sql-reference/retail#build_cannibalization_data) and [CANNIBALIZATION\_OVERLAP](https://docs.carto.com/data-and-analysis/sql-reference/retail#cannibalization_overlap) to support buffer, kring and isoline methods. Please note that these improvements have implied some breaking changes in the aforementioned functions invalidating their previous version.

**Module data**

Fix

* We have implemented a fix in the weighted averages computation in the [GRIDIFY\_ENRICH](https://docs.carto.com/data-and-analysis/sql-reference/data#gridify_enrich) procedure.

**Module quadbin**

New

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

## November 15, 2022

**Module retail**

Fix

* `__KRING_DECAY_GRID` was aggregating the value of the moving window pivoting index instead of neighbour indexes.

## November 8, 2022

**Module h3**

Improvement

* Add linestrings and points support to function H3\_POLYFILL.

## November 7, 2022

**Module retail**

New

* Add `FIND_TWIN_AREAS_WEIGHTED` procedure.

## November 1, 2022

**All modules**

New

* Create release workflows

## October 28, 2022

**Module s2**

New

* Add [S2\_RESOLUTION](https://docs.carto.com/data-and-analysis/sql-reference/s2#s2_resolution) function.
* Add [S2\_TOCHILDREN](https://docs.carto.com/data-and-analysis/sql-reference/s2#s2_tochildren) function.

## October 26, 2022

**Module transformations**

Fix

* Fix ST\_BUFFER crashing with geographies close to the poles.

**Module tiler**

Improvement

* Partition tables in spatial index tilesets.

**Module cpg**

New

* Add `CUSTOMER_SEGMENTATION_ANALYSIS_DATA` procedure.
* Add `GENERATE_TRADE_AREAS` procedure.
* Add `RUN_CUSTOMER_SEGMENTATION` procedure.

**Module lds**

Fix

* CREATE\_ISOLINES output is stored in the column `geom` instead of `__iso_geom`.

Improvement

* CREATE\_ISOLINES output is clustered by geometry.

## October 24, 2022

**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

**Module clustering**

New

* Move ST\_CLUSTERKMEANS function to core.

**Module random**

New

* Move ST\_GENERATEPOINTS function to core.

## September 30, 2022

**Module lds**

Improvement

* Rename `LDS_API_URL` to `API_BASE_URL`.

## September 29, 2022

**Module retail**

Improvement

* `LINEAR_REG` model is now supported.

## September 27, 2022

**Module tiler**

Improvement

* Fix bug in `__BUILD_REVENUE_MODEL_DATA_GRID`: Output table now contains `competitor_count`.

## September 19, 2022

**Module tiler**

Improvement

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

## September 17, 2022

**Module tiler**

Improvement

* Hotfix: set `generate_feature_id` to false by default due a bug in the generation.

## September 16, 2022

**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, geohas and quadbinh in all enrich procedures.
* Optimize all enrichment result tables by default by clusterizing by the geography or spatial index column.

## September 15, 2022

**Module s2**

New

* Add S2\_CENTER function.

**Module retail**

Improvement

* Return shap\_values in PREDICT\_REVENUE\_AVERAGE.

## August 26, 2022

**Module tiler**

New

* Add `generate_feature_id` parameter in `CREATE_SIMPLE_TILESET`.

## August 19, 2022

**Module retail**

Improvement

* Index parameter admits any type in PREDICT\_REVENUE\_AVERAGE.
* Index from revenue\_model\_data is not casted in PREDICT\_REVENUE\_AVERAGE to reduce query data processing.

## August 16, 2022

**Module tiler**

Fix

* Fixed bug when parsing zoom columns in geography tilers.

## August 11, 2022

**Module tiler**

Improvement

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

## August 9, 2022

**Module h3**

Fix

* Apply make\_valid in H3\_BOUNDARY.

## August 8, 2022

**Module tiler**

Fix

* Fixed bug in metadata `CREATE_SPATIAL_INDEX_TILESET`.

## August 5, 2022

**Module retail**

Improvement

* Check fixed model options in BUILD\_REVENUE\_MODEL procedure.

## August 3, 2022

**Module retail**

New

* Add BUILD\_CANNIBALIZATION\_DATA procedure.
* Add CANNIBALIZATION\_OVERLAP procedure.

## July 26, 2022

**Module lds**

New

* Add GEOCODE\_TABLE procedure.
* Add LDS\_QUOTA\_INFO procedure.
* Add GEOCODE\_REVERSE\_TABLE procedure.
* Add CREATE\_ISOLINES procedure.

## July 21, 2022

**Module statistics**

Improvement

* Added HH, LL, LH, HL detection in LOCAL\_MORANS\_I functions.

## July 20, 2022

**Module tiler**

Fix

* Fixed bug when passing multiline input to `CREATE_SPATIAL_INDEX_TILESET`.

## July 8, 2022

**Module data**

New

* Add quadbin support to module.

**Module retail**

New

* Add quadbin support

**Module tiler**

New

* Support of quadgrid as alias in `CREATE_POINT_AGGREGATION_TILESET`.

Improvement

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

## July 7, 2022

**Module h3**

Fix

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

**Module statistics**

New

* Add SMOOTHING\_MRF\_QUADBIN procedure.
* Add LOCAL\_MORANS\_I\_QUADBIN function.
* Add MORANS\_I\_QUADBIN function.
* Add GETIS\_ORD\_QUADBIN function.
* Quadbin support in GWR\_GRID function.

**Module tiler**

Fix

* Fixed tablename quoting in BigQuery tiler

## July 6, 2022

**Module retail**

Fix

* Fix quadkey support in FIND\_WHITESPACE\_AREAS

## June 29, 2022

**Module retail**

Fix

* Fixing bugs when not providing store variables to BUILD\_REVENUE\_MODEL\_DATA

## June 23, 2022

**Module quadbin**

New

* 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\_SIBLING function.
* Add QUADBIN\_TOCHILDREN function.
* Add QUADBIN\_TOPARENT function.
* Add QUADBIN\_TOZXY function.

## June 21, 2022

**Module data**

Fix

* Fix BQ inplace enrichment with uppercase column names.

**Module tiler**

Improvement

* Support H3 integer in `CREATE_SPATIAL_INDEX_TILESET`.

## June 13, 2022

**Module data**

Fix

* Fix order of `__KRING_DECAY` parameters.

## June 10, 2022

**Module tiler**

Fix

* Fix global stats in `CREATE_SPATIAL_INDEX_TILESET`.

Improvement

* Check input resolution limits in `CREATE_SPATIAL_INDEX_TILESET`.

## June 9, 2022

**Module data**

Fix

* Report missing subscription geographies in DATAOBS\_ENRICH\_ procedures.

## June 6, 2022

**Module data**

Fix

* Fix stability issues in GRIDIFY\_ENRICH procedure.

## June 3, 2022

**Module retail**

New

* Add store features and competitors stores features into BUILD\_REVENUE\_MODEL\_DATA procedure.

Fix

* Fixing bugs calling other routines

## June 2, 2022

**Module tiler**

New

* Add spatial index tileset generator `CREATE_SPATIAL_INDEX_TILESET`.

## May 16, 2022

**Module tiler**

Fix

* Bug fixing when the geometry early collapse

## April 27, 2022

**Module data**

New

* Add GRIDIFY\_ENRICH procedure.

**Module retail**

New

* Add FIND\_TWIN\_AREAS procedure.

## April 22, 2022

**Module data**

New

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

## April 20, 2022

**Module retail**

Fix

* Fix BUILD\_REVENUE\_MODEL\_DATA k-ring buffer computation.

## March 21, 2022

**Module transformations**

Improvement

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

**Module retail**

New

* Add COMMERCIAL\_HOTSPOTS procedure.

**Module statistics**

New

* Add SMOOTHING\_MRF\_H3 procedure.
* Add SMOOTHING\_MRF\_QUADKEY procedure.

## February 16, 2022

**Module statistics**

New

* Add VARIOGRAM function.
* Add ORDINARY\_KRIGING function.
* Add ORDINARY\_KRIGING\_TABLE procedure.

## February 15, 2022

**Module h3**

New

* Add H3\_CENTER function.
* Add H3\_RESOLUTION function.

**Module retail**

New

* Add FIND\_WHITESPACE\_AREAS procedure.

## February 3, 2022

**Module retail**

New

* Remove features importance tables from BUILD\_REVENUE\_MODEL procedure.

## February 1, 2022

**Module statistics**

New

* Add LOCAL\_MORANS\_I\_H3 function.
* Add LOCAL\_MORANS\_I\_QUADKEY function.

Improvement

* Improve MORANS\_I\_H3 and MORANS\_I\_QUADKEY implementation.

## January 10, 2022

**Module statistics**

Fix

* Replace STDDEV by STDDEV\_POP in GETIS\_ORD\_H3 and GETIS\_ORD\_QUADKEY.

## December 22, 2021

**Module retail**

New

* Add BUILD\_REVENUE\_MODEL\_DATA procedure.
* Add BUILD\_REVENUE\_MODEL procedure.
* Add PREDICT\_REVENUE\_AVERAGE procedure.

## December 16, 2021

**Module accessors**

Improvement

* Deployment schema "carto" instead of "accessors".

Removed

* Remove VERSION function.

**Module constructors**

Improvement

* Deployment schema "carto" instead of "constructors".

Removed

* Remove VERSION function.

**Module geohash**

Improvement

* Deployment schema "carto" instead of "geohash".

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 Bigquery.
* 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 ID\_FROMTOKEN function to S2\_FROMTOKEN.
* Rename TOKEN\_FROMID function to S2\_TOTOKEN.
* Rename ID\_FROMUINT64REPR function to S2\_FROMUINT64REPR.
* Rename UINT64REPR\_FROMID function to S2\_TOUINT64REPR.
* 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.

**Module routing**

Improvement

* Deployment schema "carto" instead of "routing".

Removed

* Remove VERSION function.

**Module statistics**

Improvement

* Deployment schema "carto" instead of "statistics".

Removed

* Remove VERSION function.

**Module tiler**

Improvement

* Deployment schema "carto" instead of "tiler".

Removed

* Remove VERSION function.

## December 13, 2021

**Module tiler**

Improvement

* Add support for legacy project names that contain dots or other special characters.

## December 10, 2021

**Module statistics**

New

* Add KNN function.
* Add GFUN function.
* Add LOF function.
* Add LOF\_TABLE procedure.

## November 30, 2021

**Module tiler**

Fix

* Escape single-quoted properties in the `CREATE_TILESET` metadata when obtaining the geometry type.

## November 25, 2021

**Module statistics**

New

* Add GWR\_GRID function.

## November 16, 2021

**Module tiler**

Fix

* Use `zoom_min_column` as `zoom_min` and `zoom_max_column` as `zoom_max` when provided.

Improvement

* Optimize simplification method instead of the native BigQuery.

## November 5, 2021

**Module data**

Improvement

* 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`, `DATAOBS_ENRICH_POINTS_RAW`, `DATAOBS_ENRICH_POLYGONS_RAW`, `DATAOBS_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`, `DATAOBS_ENRICH_POINTS`, `DATAOBS_ENRICH_POLYGONS`, `DATAOBS_ENRICH_GRID`, `ENRICH_POINTS_RAW`, `ENRICH_POLYGONS_RAW`, `ENRICH_GRID_RAW`, `DATAOBS_ENRICH_POINTS_RAW`, `DATAOBS_ENRICH_POLYGONS_RAW`, `DATAOBS_ENRICH_GRID_RAW`.

## November 2, 2021

**Module data**

Improvement

* Add `associated_geography_slug` column to `DATAOBS_SUBSCRIPTIONS`.
* Some column names have changed in `DATAOBS_SUBSCRIPTIONS`:
  * `table` is now `dataset_table`
  * `associated_geography` is now `associated_geography_table`
* Some column names have changed in `DATAOBS_SUBSCRIPTION_VARIABLES`:
  * `geography_slug` is now `associated_geography_slug`.
* Some column names have changed in `DATAOBS_SAMPLES`:
  * `table` is now `dataset_sample_table`.
* In `DATAOBS_SUBSCRIPTION_VARIABLES`, the column `associated_geography_slug` is now NULL for geography datasets.

Fix

* The output of `DATAOBS_SUBSCRIPTIONS` and `DATAOBS_SUBSCRIPTION_VARIABLES` now omits items that are not Data Observatory products.

## October 15, 2021

**Module data**

Fix

* Enrichment results could mix input rows and values, specially for large inputs due to multiple evaluation of nondeterministic ROW\_NUMBERS expression.

Improvement

* New API, with consistent naming of procedures \`

## September 23, 2021

**Module s2**

Improvement

* Rename functions ID\_FROMUINT64REPR, UINT64REPR\_FROMID to follow convention.

**Module statistics**

New

* Create statistics module.
* Add GETIS\_ORD\_H3 function.
* Add GETIS\_ORD\_QUADKEY function.
* Add MORANS\_I\_H3 function.
* Add MORANS\_I\_QUADKEY function.
* Add VERSION function.

## September 22, 2021

**Module h3**

Improvement

* Review HEXRING, KRING functions.
* Change KRING\_INDEXED to KRING\_DISTANCES.

## September 17, 2021

**Module tiler**

Fix

* Fix support for DATE in `CREATE_TILESET`.
* Fix naming of internal variables to avoid name collisions.

New

* Add `fraction_dropped_per_zoom` in tileset metadata.

## September 16, 2021

**Module data**

Changes

* Support `sub_` (table) subscriptions in:
  * DATAOBS\_ENRICH\_POINTS
  * DATAOBS\_ENRICH\_POINTS\_WITH\_MEASURES
  * DATAOBS\_ENRICH\_POLYGONS\_WITH\_AGGREGATION
  * DATAOBS\_ENRICH\_POLYGONS\_WITH\_MEASURES
  * DATAOBS\_ENRICH\_GRID

## September 14, 2021

**Module s2**

Fix

* Avoid keeping planar shape in spherical coordinates in ST\_BOUNDARY.

## September 3, 2021

**Module data**

Changes

* Search for tables in DATAOBS\_SAMPLES, DATAOBS\_SUBSCRIPTIONS, DATAOBS\_SUBSCRIPTIONS\_VARIABLES.

## August 31, 2021

**Module data**

Improvement

* DATAOBS\_ENRICH\_\* procedures are now optimized to reduce the amount of data processed by taking advantage of clusterization by geography in the Data Observatory.
* The `input_id_column` parameter has been removed from the following procedures:
  * DATAOBS\_ENRICH\_POINTS
  * DATAOBS\_ENRICH\_POINTS\_WITH\_MEASURES
  * DATAOBS\_ENRICH\_POLYGONS\_WITH\_AGGREGATION
  * DATAOBS\_ENRICH\_POLYGONS\_WITH\_MEASURES
  * ENRICH\_POINTS
  * ENRICH\_POINTS\_WITH\_MEASURES
  * ENRICH\_POLYGONS\_WITH\_AGGREGATION
  * ENRICH\_POLYGONS\_WITH\_MEASURES

## August 26, 2021

**Module data**

Improvement

* ENRICH\_GRID and DATAOBS\_ENRICH\_GRID procedures take `input_query` and `input_index_column` parameters instead of the `indices` array.
* DATAOBS\_ENRICH\_\* procedures now report missing subscriptions in a more user-friendly way.

**Module routing**

Improvement

* Pass network to JS UDF natively
* Support custom speed over LineStrings for GENERATE\_NETWORK function.
* Support custom speed over LineStrings for FIND\_SHORTEST\_PATH function.
* Support custom speed over LineStrings for DISTANCE\_MAP function.

## August 25, 2021

**Module tiler**

Fix

* Fix support for TIMESTAMP,DATETIME in CREATE\_TILESET and CREATE\_SIMPLE\_TILESET.
* Reduce parallelization to skip the recent error: "Not enough resources for query planning - too many subqueries or query is too complex"

## August 24, 2021

**Module h3**

Fix

* Support GEOMETRYCOLLECTION from ST\_ASH3\_POLYFILL.

## August 6, 2021

**Module data**

New

* Add DATAOBS\_ENRICH\_GRID procedure.
* Add ENRICH\_GRID procedure.

## August 4, 2021

**Module h3**

New

* Add KRING\_INDEXED function.

## July 30, 2021

**Module geohash**

New

* Create geohash module.
* Add VERSION function.
* Add ST\_BOUNDARY function.

**Module tiler**

Improvement

* Checking if the output table exists before running the tiler.

## July 13, 2021

**Module data**

Improvement

* DATAOBS\_ENRICH\_\* procedures take single `source` parameter with default `carto-customers` project.

## July 9, 2021

**Module data**

New

* Add DATAOBS\_SAMPLES procedure.

Improvement

* DATAOBS\_SUBSCRIPTIONS and DATAOBS\_SUBSCRIPTION\_VARIABLES take single `source` parameter with default `carto-customers` project. Views with `sub_` prefix are supported.

**Module routing**

New

* Create routing module.
* Add GENERATE\_NETWORK function.
* Add GENERATE\_NETWORK\_TABLE procedure.
* Add FIND\_SHORTEST\_PATH function.
* Add FIND\_SHORTEST\_PATH\_FROM\_NETWORK function.
* Add FIND\_SHORTEST\_PATH\_FROM\_NETWORK\_TABLE procedure.
* Add DISTANCE\_MAP function.
* Add DISTANCE\_MAP\_FROM\_NETWORK function.
* Add DISTANCE\_MAP\_FROM\_NETWORK\_TABLE procedure.
* Add VERSION function.

## July 8, 2021

**Module data**

Fix

* Fix DATAOBS\_SUBSCRIPTIONS and DATAOBS\_SUBSCRIPTION\_VARIABLES not working with subscriptions in which the provider id contained underscores.

## July 1, 2021

**Module tiler**

New

* Add new automatic tileset generator `CREATE_TILESET`.

## June 23, 2021

**Module data**

New

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

Improvement

* Change spatial catalog structure using two tables.
* Improve enrichment procedures:
  * Use public geographies instead of subscription views
  * Remove unnecessary variables from ENRICH\_POLYGONS\_WITH\_MEASURES
  * Make input\_id\_column always mandatory
  * Add input\_area consistently

## June 2, 2021

**Module data**

New

* Create data module.
* Add VERSION function.
* Add DATAOBS\_ENRICH\_POINTS procedure.
* Add DATAOBS\_ENRICH\_POINTS\_WITH\_MEASURES procedure.
* Add DATAOBS\_ENRICH\_POLYGONS\_WITH\_AGGREGATION procedure.
* Add DATAOBS\_ENRICH\_POLYGONS\_WITH\_MEASURES procedure.
* Add ENRICH\_POINTS procedure.
* Add ENRICH\_POINTS\_WITH\_MEASURES procedure.
* Add ENRICH\_POLYGONS\_WITH\_AGGREGATION procedure.
* Add ENRICH\_POLYGONS\_WITH\_MEASURES procedure.

## June 1, 2021

**Module s2**

New

* Add TOKEN\_FROMID function.
* Add ID\_FROMTOKEN function.
* Add ID\_FROM\_UINT64REPR function.
* Add UINT64REPR\_FROM\_ID function.

## May 19, 2021

**Module tiler**

Improvement

* Use semantic versioning.
* Add `features_count` and `geometry` labels to the tilesets.

## May 6, 2021

**Module clustering**

Improvement

* Change ST\_CLUSTERKMEANS returning cluster and geom

## May 4, 2021

**Module accessors**

New

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

**Module processing**

New

* 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.

**Module transformations**

New

* Add ST\_CONCAVEHULL function.

## April 30, 2021

**Module clustering**

New

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

## April 29, 2021

**Module constructors**

New

* Add ST\_BEZIERSPLINE function.
* Add ST\_MAKEELLIPSE function.

**Module measurements**

New

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

**Module transformations**

New

* Rename module to transformations.
* Add ST\_CENTERMEAN function.
* Add ST\_CENTERMEDIAN function.
* Add ST\_CENTEROFMASS function.
* Add ST\_DESTINATION function.
* Add ST\_GREATCIRCLE function.
* Add ST\_LINE\_INTERPOLATE\_POINT function.

**Module tiler**

Removed

* Remove quota & project checking.

## April 28, 2021

**Module constructors**

New

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

## April 16, 2021

**Module transformations**

New

* Create transformation module.
* Add ST\_BUFFER function.
* Add VERSION function.

## April 10, 2021

**Module random**

Improvement

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

## April 9, 2021

**Module h3**

Improvement

* Use hexadecimal as default type instead of int for h3 indexes.

Fix

* Fix ST\_BOUNDARY generating error when not able to parse geometry.

**Module placekey**

Improvement

* Placekey conversions works with hexadecimal h3 indexes instead of int.

**Module random**

New

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

## March 31, 2021

**Module h3**

New

* 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.

**Module placekey**

New

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

**Module s2**

New

* 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.

**Module tiler**

New

* Add QUOTA procedure in order to display the monthly quota and quota available.
* Implement support for layer name.
* Add a max limit to the `max_tile_size_kb` property. Adds a new option (`skip_validation`) to circunvent this limit, which also allows going over the max partition limit.
* Add a limit to the max amount of **expected** tiles at the highest zoom level for Simple Tilesets. It can be disabled via the `skip_validation` option of modified (for tests using `max_tiles_at_maxzoom`).
* Add new `drop_fraction_as_needed` strategy initial implementation. Also adds **internal** `debug` and `fraction_drop_per_zoom_level` options to help debugging.
* Add new `metadada` input parameter to set the properties `name`, `description`, `legends` and also `extra_metadata`.
* Add `zoom_min_column` and `zoom_max_column` to control the zoom level at which particular features are visible.

Improvement

* Change the default and max partition limit to 3999.
* Make aggregation tilesets to use the quadkey module UDF LONGLAT\_ASQUADINTLIST\_RESOLUTION in order to generate quadkey aggregations.

Removed

* Removed `zoom_step` option.

Fix

* Fix bug that left empty the generator options in the metadata cell.
* Fix CREATE\_SIMPLE\_TILESET failing with single column tables.
* Fix collision with `frequency` column name.

## February 10, 2021

**Module tiler**

New

* Add tileset type to metadata and BigQuery labels.
* Add the prefix "aggregation\_" to aggregation options: type, resolution and placement.

Improvement

* Moved to the Advanced Spatial Extension.
* Change "max\_tile\_size\_strategy" default to "throw\_error", matching the other defaults and improve the exception error message in CreatePointAggregationTileset.
* Rename adapting to BigQuery conventions, using UPPER CASE and separating words with underscore "\_".
* Set up limits for the procedures based on a limits table in the config project. The users can only execute the tiler from the "billing\_project" and they have a maximum amount of processed bytes per month.

Removed

* Remove compression levels 10-12 to reduce library size.
* Remove ST prefix from functions not using geographies.
* Remove unused functions like st\_tileenvelope or st\_tileenvelope\_bbox.