Analytics Toolbox for Redshift

Analytics Toolbox for Redshift

Github Code

Release notes

April 21, 2022

Module tiler

Feature

  • Add max_tile_size_strategy support for CREATE_SIMPLE_TILESET.

Fixed

  • Fix tile_feature_order not being taken into account for CREATE_POINT_AGGREGATION_TILESET and CREATE_POINT_AGGREGATION_TILESET.

March 30, 2022

Module tiler

Fixed

  • Escape special characters in generated properties.

March 25, 2022

Module tiler

Changed

  • Raise improper qualified tables errors.
  • Limit GeoJSON precision to 6 to comply Redshift VARCHAR size limitations.
  • Add ST_Simplify to the tiler.

March 10, 2022

Module tiler

Feature

  • Add CREATE_SIMPLE_TILESET procedure.

February 25, 2022

Module tiler

Feature

  • Create tiler module.
  • Add CREATE_POINT_AGGREGATION_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.

December 16, 2021

Module transformations

Fixed

  • Refactor of internal __ST_GEOMFROMGEOJSON function to avoid UDFs nestig Redshift limitations

December 10, 2021

Module constructors

Changed

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

Removed

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

Changed

  • Deployment schema “carto” instead of “quadkey”.
  • Rename ZXY_FROMQUADINT function to QUADINT_TOZXY.
  • Rename LONGLAT_ASQUADINT function to QUADINT_FROMGEOGPOINT.
  • Rename QUADKEY_FROMQUADINT function to QUADINT_TOQUADKEY.
  • Rename TOPARENT function to QUADINT_TOPARENT.
  • Rename TOCHILDREN function to QUADINT_TOCHILDREN.
  • Rename SIBLING function to QUADINT_SIBLING.
  • Rename KRING function to QUADINT_KRING.
  • Rename KRING_DISTANCES function to QUADINT_KRING_DISTANCES.
  • Rename BBOX function to QUADINT_BBOX.
  • Rename ST_ASQUADINT function to QUADINT_FROMGEOGPOINT.
  • Rename ST_ASQUADINT_POLYFILL function to QUADINT_POLYFILL.
  • Rename ST_BOUNDARY function to QUADINT_BOUNDARY.

Removed

  • Remove VERSION function.

Module s2

Changed

  • Deployment schema “carto” instead of “s2”.
  • Rename HILBERTQUADKEY_FROMID function to S2_TOHILBERTQUADKEY.
  • Rename ID_FROMHILBERTQUADKEY function to S2_FROMHILBERTQUADKEY.
  • Rename ID_FROMTOKEN function to S2_FROMTOKEN.
  • Rename ID_FROMUINT64REPR function to S2_FROMUINT64REPR.
  • Rename LONGLAT_ASID function to S2_FROMLONGLAT.
  • Rename RESOLUTION function to S2_RESOLUTION.
  • Rename ST_ASID function to S2_FROMGEOGPOINT.
  • Rename ST_ASID_POLYFILL_BBOX function to S2_POLYFILL_BBOX.
  • Rename ST_BOUNDARY function to S2_BOUNDARY.
  • Rename TOCHILDREN function to S2_TOCHILDREN.
  • Rename TOKEN_FROMID function to S2_TOTOKEN.
  • Rename TOPARENT function to S2_TOPARENT.
  • Rename UINT64REPR_FROMID function to S2_TOUINT64REPR.

Removed

  • Remove VERSION function.

Module transformations

Changed

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

Removed

  • Remove VERSION function.

Module clustering

Changed

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

Removed

  • Remove VERSION function.

Module clustering

Changed

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

Removed

  • Remove VERSION function.

Module random

Changed

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

Removed

  • Remove VERSION function.

Module random

Changed

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

October 21, 2021

Module clustering

Changed

  • ST_CLUSTERKMEANS returning an Array.

October 6, 2021

Module processing

Feature

  • Create processing module.
  • Add VERSION function.
  • Add ST_POLYGONIZE function.
  • Add ST_DELAUNAYLINES function.
  • Add ST_DELAUNAYPOLYGONS function.
  • Add ST_VORONOILINES function.
  • Add ST_VORONOIPOLYGONS function.

Module transformations

Feature

  • Create transformations module.
  • Add VERSION function.
  • Add ST_CENTERMEAN function.
  • Add ST_CENTROID function.
  • Add ST_CENTEROFMASS function
  • Add ST_CENTERMEDIAN function
  • Add ST_GREATCIRCLE function
  • Add ST_DESTINATION function

October 5, 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.

September 23, 2021

Module s2

Feature

  • Create s2 module.
  • Add HILBERTQUADKEY_FROMID function.
  • Add ID_FROMHILBERTQUADKEY function.
  • Add ID_FROMTOKEN function.
  • Add ID_FROMUINT64REPR function.
  • Add LONGLAT_ASID function.
  • Add RESOLUTION function.
  • Add ST_ASID function.
  • Add ST_ASID_POLYFILL_BBOX function.
  • Add ST_BOUNDARY function.
  • Add TOCHILDREN function.
  • Add TOKEN_FROMID function.
  • Add TOPARENT function.
  • Add UINT64REPR_FROMID function.
  • Add VERSION function.

September 22, 2021

Module quadkey

Feature

  • Add KRING_DISTANCES function.

Changed

  • Review KRING function.

September 17, 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.

September 9, 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 VERSION function.

September 7, 2021

Module placekey

Feature

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