Comment on page
Release Notes
Module lds
New
- Add SETUP procedure. This procedure allows configuring credentials and endpoints for a custom installation of the Analytics Toolbox. Check this documentation for more information about this topic.
- Replace LDS_QUOTA_INFO by 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
,LOCAL_MORANS_I_QUADBIN
procedures. These procedures allows computing the spatial autocorrelation locally. - Added
GWR_GRID
procedure. This procedure allows computing a Geographically Weighed Regression on an spatial index grid. - Added
GETIS_ORD_SPACETIME_H3
,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.
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.
Module lds
Improvement
Module statistics
New
- The new version of the following procedures now expects a table as input, overcoming previous performance limitations:
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.
Module lds
New
- We have added optional parameters:
api_base_url
,lds_token
to every function/procedure
Fix
- Fix
CREATE_ROUTES
fails ifgeom_column
is not namedgeom
Module lds
New
- We are now allowing users to send any of the parameter options supported by the isolines service provider in CREATE_ISOLINES.
- We have improved our logging of results in 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.
Module lds
New
- We have created a new procedure named 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 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:
- Moran’s I functions:
Module h3
New
We have incorporated two new functions to the “h3” module of the Analytics Toolbox, namely H3_CENTER, which returns the center of an H3 cell as a GEOGRAPHY point, and H3_RESOLUTION which returns the H3 cell resolution as an integer.
Module transformations
New
We have added support for the ST_CONVEXHULL function, which computes the convex hull of the input geographies (the smallest convex geography that covers all the input ones)
Module lds
Improvement
- We have improved the performance in CREATE_ISOLINES, benefiting now from parallelizing requests to the API.
Change
- We have updated the LDS module to be aligned with the new usage quota model, working as an annual budget and combining consumption across all supported LDS services.
Module lds
New
- We have added object type support for the options parameter also maintaining string type support as until now in GEOCODE_TABLE, GEOCODE_REVERSE_TABLE, CREATE_ISOLINES, , GEOCODE, GEOCODE_REVERSE, and ISOLINE.
Module tiler
Improvement
- Update default zoom values: geo, quadbin, h3 (12, 12, 6).
- Fix spatial index tiler with empty properties.
Improvement
- We have added the possibility to configure more options as parameters when executing the functions to 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.
New
- Quadbin/quadkey conversion functions have been added to ease the conversion from quadbin to quadkey and from quadkey to quadbin indexes.
Feature
- Create release workflows
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
Feature
- Move ST_CLUSTERKMEANS function to core.
Feature
- Move ST_GENERATEPOINTS function to core.
Improvement
- CREATE_ISOLINES output is ordered by geometry to be compliant with Snowflake Search Optimization Service.
Improvement
- Rename
LDS_API_URL
toAPI_BASE_URL
.
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.
Improvement
- Set
version
field in tilers metadata compliant with AT version.
Improvement
- Unify
extra_metadata
intometadata
in tiler metadata.
Feature
- Add quadbin support to module.
Fix
- Fix quoting and letter case in spatial index tiler.
Fix
- Fix wrong uppercase in spatial index tiler.
Improvement
- Use core functions to convert H3 from int to string.
Fix
- Correctly handle large polygons in H3_POLYFILL.
- Fixed wrong uppercase for quadbin and h3 tile ids
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.
Improvement
- Add CREATE_SPATIAL_INDEX_TILESET procedure.
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.
Improvement
- Add optional
language
parameter to GEOCODE_REVERSE function.
Improvement
- Errors used to be reported with a procedure result message. Now they raise exceptions.
Feature
- Allow using tables as input, not just queries.
- Add in place enrichment.
Improvement
- Add support for non-uppercase column names
Improvement
- Errors used to be reported with a procedure result message. Now they raise exceptions.
Feature
- Add ST_BUFFER function.
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.
Improvement
- ST_CONCAVEHULL now allows arrays with one/two points as input.
Feature
- Add CREATE_SIMPLE_TILESET procedure.
Feature
- Add GEOCODE_TABLE procedure.
- Add GEOCODE function.
- Add GEOCODE_REVERSE function.
- Add ISOLINE function.
- Add LDS_QUOTA_INFO function.
Feature
- Create tiler module.
- Add CREATE_POINT_AGGREGATION_TILESET procedure.
Feature
- Add DATAOBS_SUBSCRIPTIONS procedure.
- Add DATABOS_SUBSCRIPTION_VARIABLES procedure.
Improvement
- Read spatial_catalog tables in source.
Improvement
- Missing subscriptions are reported by name in DATAOBS_ENRICH_* procedures
Improvement
- ST_GENERATEPOINTS now uses a spherically uniform distribution. Previously used to by uniform on projection.
Improvement
- Deployment schema “carto” instead of “accessors”.
- Rename ST_ENVELOPE function to ST_ENVELOPE_ARR.
Removed
- Remove VERSION function.
Improvement
- Deployment schema “carto” instead of “constructors”.
Removed
- Remove VERSION function.
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.
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.
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.
Improvement
- Deployment schema “carto” instead of “processing”.
Removed
- Remove VERSION function.
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.
Improvement
- Deployment schema “carto” instead of “transformations”.
Removed
- Remove VERSION function.
Improvement
- Deployment schema “carto” instead of “clustering”.
Removed
- Remove VERSION function.
Improvement
- Deployment schema “carto” instead of “data”.
Removed
- Remove VERSION function.
Improvement
- Deployment schema “carto” instead of “random”.
Removed
- Remove VERSION function.
Improvement
- Deployment schema “carto” instead of “clustering”.
- Remove VERSION function.
Improvement
- Deployment schema “carto” instead of “data”.
- Remove VERSION function.
Improvement
- Deployment schema “carto” instead of “random”.
- Remove VERSION function.
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.
Changes
- Fields named
dimension
,total
,intersection
andinput_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
.
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.
Feature
- Add KRING_DISTANCES function.
Improvement
- Review HEXRING, KRING functions.
Changes
- Compute ST_BOUNDARY from WKT.
Fix
- Support GEOMETRYCOLLECTION from ST_ASH3_POLYFILL.
Improvement
- Reduce bundle size for every function.
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.
Feature
- Create clustering module.
- Add VERSION function.
- Add ST_CLUSTERKMEANS function.
Feature
- Create random module.
- Add ST_GENERATEPOINTS function.
- Add VERSION function.
Feature
- Create accessors module.
- Add ST_ENVELOPE function.
- Add VERSION function.
Feature
- Create constructors module.
- Add ST_BEZIERSPLINE function.
- Add ST_MAKEELLIPSE function.
- Add ST_MAKEENVELOPE function.
- Add ST_TILEENVELOPE function.
- Add VERSION function.
Feature
- Create measurements module.
- Add ST_ANGLE function.
- Add ST_AZIMUTH function.
- Add ST_MINKOWSKIDISTANCE function.
- Add VERSION function.
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.
Feature
- Create placekey module.
- Add H3_ASPLACEKEY function.
- Add PLACEKEY_ASH3 function.
- Add ISVALID function.
- Add VERSION function.
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.
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.