Analytics Toolbox for Snowflake

Analytics Toolbox for Snowflake

Github Code

Release notes

November 1, 2022

All modules

New

  • Create release workflows

Improvement

  • Adapt to Semver

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.

October 4, 2022

Module lds

Improvement

  • CREATE_ISOLINES output is ordered by geometry to be compliant with Snowflake Search Optimization Service.

September 30, 2022

Module lds

Improvement

  • Rename LDS_API_URL to API_BASE_URL.

September 28, 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, geohash in all enrich procedures.
  • Optimize performance of all enrich result tables by ordering or clusterizing them.

September 19, 2022

Module tiler

Improvement

  • Set version field in tilers metadata compliant with AT version.

August 11, 2022

Module tiler

Improvement

  • Unify extra_metadata into metadata in tiler metadata.

July 22, 2022

Module lds

New

  • Add GEOCODE_REVERSE_TABLE procedure.

July 13, 2022

Module data

New

  • Add quadbin support to module.

July 12, 2022

Module tiler

Fix

  • Fix quoting and letter case in spatial index tiler.

July 8, 2022

Module tiler

Fix

  • Fix wrong uppercase in spatial index tiler.

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

June 24, 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_SIBLINGS function.
  • Add QUADBIN_TOCHILDREN function.
  • Add QUADBIN_TOPARENT function.
  • Add QUADBIN_TOZXY function.

June 23, 2022

Module tiler

Improvement

  • Add CREATE_SPATIAL_INDEX_TILESET procedure.

June 15, 2022

Module data

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.

June 9, 2022

Module lds

New

  • Add CREATE_ISOLINES procedure.

May 19, 2022

Module lds

Improvement

  • Add optional language parameter to GEOCODE_REVERSE function.

May 6, 2022

Module data

Improvement

  • Errors used to be reported with a procedure result message. Now they raise exceptions.

April 28, 2022

Module data

New

  • Allow using tables as input, not just queries.
  • Add in place enrichment.

April 21, 2022

Module tiler

Improvement

  • Add support for non-uppercase column names

April 20, 2022

Module tiler

Improvement

  • Errors used to be reported with a procedure result message. Now they raise exceptions.

April 7, 2022

Module transformations

New

  • Add ST_BUFFER function.

March 25, 2022

Module tiler

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.

March 21, 2022

Module transformations

Improvement

  • ST_CONCAVEHULL now allows arrays with one/two points as input.

February 24, 2022

Module tiler

New

  • Add CREATE_SIMPLE_TILESET procedure.

February 18, 2022

Module lds

New

  • Add GEOCODE_TABLE procedure.
  • Add GEOCODE function.
  • Add GEOCODE_REVERSE function.
  • Add ISOLINE function.
  • Add LDS_QUOTA_INFO function.

February 16, 2022

Module tiler

New

  • Create tiler module.
  • Add CREATE_POINT_AGGREGATION_TILESET procedure.

January 10, 2022

Module data

New

  • Add DATAOBS_SUBSCRIPTIONS procedure.
  • Add DATABOS_SUBSCRIPTION_VARIABLES procedure.

Improvement

  • Read spatial_catalog tables in source.

December 15, 2021

Module data

Improvement

  • Missing subscriptions are reported by name in DATAOBS_ENRICH_* procedures

December 10, 2021

Module random

Improvement

  • ST_GENERATEPOINTS now uses a spherically uniform distribution. Previously used to by uniform on projection.

December 3, 2021

Module accessors

Improvement

  • Deployment schema “carto” instead of “accessors”.
  • Rename ST_ENVELOPE function to ST_ENVELOPE_ARR.

Removed

  • Remove VERSION function.

Module constructors

Improvement

  • Deployment schema “carto” instead of “constructors”.

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 Snowflake.
  • Remove ST_AZIMUTH, already present in Snowflake.
  • 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 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.

November 25, 2021

Module clustering

Improvement

  • Deployment schema “carto” instead of “clustering”.
  • Remove VERSION function.

Module data

Improvement

  • Deployment schema “carto” instead of “data”.
  • Remove VERSION function.

Module random

Improvement

  • Deployment schema “carto” instead of “random”.
  • Remove VERSION function.

November 24, 2021

Module data

New

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

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.

November 4, 2021

Module data

New

  • 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

New

  • Add KRING_DISTANCES function.

Improvement

  • Review HEXRING, KRING functions.

September 14, 2021

Module s2

Changes

  • Compute ST_BOUNDARY from WKT.

August 24, 2021

Module h3

Fix

  • Support GEOMETRYCOLLECTION from ST_ASH3_POLYFILL.

June 2, 2021

Module h3

Improvement

  • Reduce bundle size for every function.

May 26, 2021

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.

May 24, 2021

Module clustering

New

  • Create clustering module.
  • Add VERSION function.
  • Add ST_CLUSTERKMEANS function.

Module random

New

  • Create random module.
  • Add ST_GENERATEPOINTS function.
  • Add VERSION function.

May 21, 2021

Module accessors

New

  • Create accessors module.
  • Add ST_ENVELOPE function.
  • Add VERSION function.

May 20, 2021

Module constructors

New

  • Create constructors module.
  • Add ST_BEZIERSPLINE function.
  • Add ST_MAKEELLIPSE function.
  • Add ST_MAKEENVELOPE function.
  • Add ST_TILEENVELOPE function.
  • Add VERSION function.

Module measurements

New

  • Create measurements module.
  • Add ST_ANGLE function.
  • Add ST_AZIMUTH function.
  • Add ST_MINKOWSKIDISTANCE function.
  • Add VERSION function.

Module transformations

New

  • 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

New

  • Create placekey module.
  • Add H3_ASPLACEKEY function.
  • Add PLACEKEY_ASH3 function.
  • Add ISVALID function.
  • Add VERSION function.

April 12, 2021

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.

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