Analytics Toolbox for Snowflake

Analytics Toolbox for Snowflake

Github Code

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

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.