Analytics Toolbox for Snowflake

Analytics Toolbox for Snowflake

Release notes

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

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.

Module quadkey

Feature

  • Add KRING_DISTANCES function.

Changed

  • Review KRING function.

September 14, 2021

Module s2

Changes

  • Compute ST_BOUNDARY from WKT.

September 9, 2021

Module quadkey

Changed

  • Performance improvement in ST_ASQUADINT_POLYFILL.

August 24, 2021

Module h3

Fixed

  • Support GEOMETRYCOLLECTION from ST_ASH3_POLYFILL.

August 11, 2021

Module quadkey

Fixed

  • Support GEOMETRYCOLLECTION from ST_ASQUADINT_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.

March 31, 2021

Module quadkey

Feature

  • Create quadkey module.
  • Add QUADINT_FROMZXY function.
  • Add ZXY_FROMQUADINT function.
  • Add LONGLAT_ASQUADINT function.
  • Add QUADINT_FROMQUADKEY function.
  • Add QUADKEY_FROMQUADINT function.
  • Add TOPARENT function.
  • Add TOCHILDREN function.
  • Add SIBLING function.
  • Add KRING function.
  • Add BBOX function.
  • Add ST_ASQUADINT function.
  • Add ST_ASQUADINT_POLYFILL function.
  • Add ST_BOUNDARY function.
  • Add LONGLAT_ASQUADINTLIST_RESOLUTION function.
  • Add VERSION function.