
Analytics Toolbox for Snowflake
Release notes
June 9, 2022
Module lds
Feature
- Add CREATE_ISOLINES procedure.
June 24, 2022
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
Module tiler
Changed
- Add CREATE_SPATIAL_INDEX_TILESET procedure.
June 15, 2022
Module data
- 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
Changed
- Errors used to be reported with a procedure result message. Now they raise exceptions.
May 19, 2022
Module lds
Changed
- Add optional
language
parameter to GEOCODE_REVERSE function.
May 6, 2022
Module data
Changed
- Errors used to be reported with a procedure result message. Now they raise exceptions.
April 28, 2022
Module data
Feature
- Allow using tables as input, not just queries.
- Add in place enrichment.
April 21, 2022
Module tiler
Changed
- Add support for non-uppercase column names
April 20, 2022
Module tiler
Changed
- Errors used to be reported with a procedure result message. Now they raise exceptions.
April 7, 2022
Module transformations
Feature
- Add ST_BUFFER function.
March 25, 2022
Module tiler
Changed
- Run the simple tiler in a single query.
- Add
fraction_dropped_per_zoom
to the metadata.
Fixed
- 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
Module transformations
Changed
- ST_CONCAVEHULL now allows arrays with one/two points as input.
February 24, 2022
Module tiler
Feature
- Add CREATE_SIMPLE_TILESET procedure.
February 18, 2022
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
Module tiler
Feature
- Create tiler module.
- Add CREATE_POINT_AGGREGATION_TILESET procedure.
January 10, 2022
Module data
Feature
- Add DATAOBS_SUBSCRIPTIONS procedure.
- Add DATABOS_SUBSCRIPTION_VARIABLES procedure.
Changed
- Read spatial_catalog tables in source.
December 15, 2021
Module data
Changed
- Missing subscriptions are reported by name in DATAOBS_ENRICH_* procedures
December 10, 2021
Module random
Changed
- ST_GENERATEPOINTS now uses a spherically uniform distribution. Previously used to by uniform on projection.
December 3, 2021
Module accessors
Changed
- Deployment schema “carto” instead of “accessors”.
- Rename ST_ENVELOPE function to ST_ENVELOPE_ARR.
Removed
- Remove VERSION function.
Module constructors
Changed
- Deployment schema “carto” instead of “constructors”.
Removed
- Remove VERSION function.
Module h3
Changed
- 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
Changed
- 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
Changed
- 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
Changed
- Deployment schema “carto” instead of “processing”.
Removed
- Remove VERSION function.
Module s2
Changed
- 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
Changed
- Deployment schema “carto” instead of “transformations”.
Remove
- Remove VERSION function.
Module clustering
Changed
- Deployment schema “carto” instead of “clustering”.
Removed
- Remove VERSION function.
Module data
Changed
- Deployment schema “carto” instead of “data”.
Removed
- Remove VERSION function.
Module random
Changed
- Deployment schema “carto” instead of “random”.
Removed
- Remove VERSION function.
November 25, 2021
Module clustering
Changed
- Deployment schema “carto” instead of “clustering”.
- Remove VERSION function.
Module data
Changed
- Deployment schema “carto” instead of “data”.
- Remove VERSION function.
Module random
Changed
- Deployment schema “carto” instead of “random”.
- Remove VERSION function.
November 24, 2021
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
Module data
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
.
Fixed
- 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
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
Module h3
Feature
- Add KRING_DISTANCES function.
Changed
- Review HEXRING, KRING functions.
September 14, 2021
Module s2
Changes
- Compute ST_BOUNDARY from WKT.
August 24, 2021
Module h3
Fixed
- Support GEOMETRYCOLLECTION from ST_ASH3_POLYFILL.
June 2, 2021
Module h3
Changed
- Reduce bundle size for every function.
May 26, 2021
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
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
Module accessors
Feature
- Create accessors module.
- Add ST_ENVELOPE function.
- Add VERSION function.
May 20, 2021
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
Module placekey
Feature
- Create placekey module.
- Add H3_ASPLACEKEY function.
- Add PLACEKEY_ASH3 function.
- Add ISVALID function.
- Add VERSION function.
April 12, 2021
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
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.