HomeAcademyLoginTry for free

Release Notes

February 18th, 2025 (v1.1.0)

Module lds

New

January 30th, 2025 (v1.0.1)

Module tiler

Fix

October 31st, 2024 (v1.0.0)

Module tiler

New

  • Added tiler module that contains fuctions to create different types of tilesets:

    • CREATE_VECTOR_TILESET: Generates a simple feature's tileset from point, lines or polygons geographies.

    • CREATE_POINT_AGG_TILESET: Generates a tileset with aggregated points and properties.

    • CREATE_H3_AGG_TILESET: Creates a tileset that uses an H3 spatial index, aggregating data from an input table that uses that same spatial index.

    • CREATE_QUADBIN_AGG_TILESET: Creates a tileset that uses a quadbin spatial index, aggregating data from an input table that uses that same spatial index.

Apache Sedona

New

  • The CARTO Analytics Toolbox includes all functions from Apache Sedona 1.5.1. These functions are available with the prefix sedona_ like: SELECT sedona_ST_Point(double(1.2345), 2.3456)

Deprecation notice

The release notes below make reference to an older version of the CARTO Analytics Toolbox for Databricks. That version is deprecated and the functions included in it are not maintained anymore.

October 24, 2022

Tiler

Feature

  • Add tilestats generation to H3 Tiler

October 19, 2022

All modules

Feature

  • Tasks to build installation packages

Improvement

  • Versioning uses YYYY.MM.DD format based on date now

October 10, 2022

Tiler

Feature

  • Add H3 Tiler

September 21, 2022

All modules

Feature

  • Add VERSION_CORE function

Accessors

Improvement

  • Change type returned by ST_X and ST_Y to Double

All modules

Feature

  • Add VERSION_ADVANCED function

September 20, 2022

All modules

Improvement

  • Set default compression codec to snappy

September 16, 2022

All modules

Feature

  • Add headers to functions that didn’t have

  • Add make rule to publis artifact in local and sonatype

  • Add make rule to check and create headers

Improvement

  • change makefiles and sbt file to prepare the at advance

Module parsers

Fixed

  • Fix the parser tests that had old user function names

All modules

Feature

  • Add structure for databricks in AT advanced repo

  • Add make rules

  • Add CI/CD workflows

September 15, 2022

All modules

Improvement

  • The XY precission of the TWKBWriter is set to 5.

Module formatters

Fix

  • Fix the doc of the transformers functions ST_ASLATLONTEXT and ST_ASTEXT.

September 6, 2022

Module accessors

Fix

  • Fix the bug in ST_COORDDIM that was adding z coordinate to geometries.

Module indexing

Fix

  • Fix the cast ClassCastException in ST_GEOMREPROJECT.

September 1, 2022

All modules

Improvement

  • Refactor databricks cloud to adapt it to the new cloud structure

August 29, 2022

Module indexing

Feature

  • Add ST_CRSFROMTEXT function.

  • Add ST_EXTENTFROMGEOM function.

  • Add ST_EXTENTTOGEOM function.

  • Add ST_GEOMREPROJECT function.

  • Add ST_MAKEEXTENT function.

  • Add ST_PARTITIONCENTROID function.

  • Add ST_Z2LATLON function.

Module formatters

Feature

  • Add ST_ASTWKB function.

Module parsers

Feature

  • Add ST_GEOMFROMWKT function.

Module predicates

Feature

  • Add ST_COVERS function.

Module transformations

Feature

  • Add ST_BUFFERPOINT function.

  • Add ST_DIFFERENCE function.

  • Add ST_SIMPLIFY function.

August 19, 2022

Module accessors

Feature

  • Add ST_COORDDIM function.

  • Add ST_DIMENSION function.

  • Add ST_ENVELOPE function.

  • Add ST_GEOMETRYN function.

  • Add ST_ISCLOSED function.

  • Add ST_ISCOLLECTION function.

  • Add ST_ISEMPTY function.

  • Add ST_ISGEOMFIELD function.

  • Add ST_ISRING function.

  • Add ST_ISSIMPLE function.

  • Add ST_ISVALID function.

  • Add ST_NUMGEOMETRIES function.

  • Add ST_NUMPOINTS function.

  • Add ST_POINTN function.

  • Add ST_Y function.

  • Add ST_X function.

Module constructors

Feature

  • Add ST_MAKEBBOX function.

  • Add ST_MAKEBOX2D function.

  • Add ST_MAKELINE function.

  • Add ST_MAKEPOINT function.

  • Add ST_MAKEPOINTM function.

  • Add ST_MAKEPOLYGON function.

  • Add ST_POINT function.

Module formatters

Feature

  • Add ST_ASBINARY function.

  • Add ST_ASGEOHASH function.

  • Add ST_ASGEOJSON function.

  • Add ST_ASLATLONTEXT function.

  • Add ST_ASTEXT function.

  • Add ST_BYTEARRAY function.

  • Add ST_CASTTOGEOMETRY function.

  • Add ST_CASTTOLINESTRING function.

  • Add ST_CASTTOPOINT function.

  • Add ST_CASTTOPOLYGON function.

Module measurements

Feature

  • Add ST_AREA function.

  • Add ST_DISTANCE function.

  • Add ST_DISTANCESPHERE function.

  • Add ST_LENGTH function.

  • Add ST_LENGTHSPHERE function.

Module parsers

Feature

  • Add ST_BOX2DFROMGEOHASH function.

  • Add ST_GEOMETRYFROMTEXT function.

  • Add ST_GEOMFROMGEOHASH function.

  • Add ST_GEOMFROMGEOJSON function.

  • Add ST_GEOMFROMWKB function.

  • Add ST_GEOMFROMWKT function.

  • Add ST_LINEFROMTEXT function.

  • Add ST_MLINEFROMTEXT function.

  • Add ST_MPOINTFROMTEXT function.

  • Add ST_MPOLYFROMTEXT function.

  • Add ST_POINTFROMGEOHASH function.

  • Add ST_POINTFROMTEXT function.

  • Add ST_POINTFROMWKB function.

  • Add ST_POLYGONFROMTEXT function.

Module predicates

Feature

  • Add ST_CONTAINS function.

  • Add ST_CROSSES function.

  • Add ST_DISJOINT function.

  • Add ST_EQUALS function.

  • Add ST_INTERSECTS function.

  • Add ST_OVERLAPS function.

  • Add ST_RELATE function.

  • Add ST_RELATEBOOL function.

  • Add ST_TOUCHES function.

  • Add ST_WITHIN function.

Module transformations

Feature

  • Add ST_ANTIMERIDIANSAFEGEOM function.

  • Add ST_BOUNDARY function.

  • Add ST_CENTROID function.

  • Add ST_CLOSESTPOINT function.

  • Add ST_CONVEXHULL function.

  • Add ST_EXTERIORRING function.

  • Add ST_IDLSAFEGEOM function.

  • Add ST_INTERIORRINGN function.

  • Add ST_INTERSECTION function.

  • Add ST_TRANSLATE function.

PreviousGuidesNextAnalytics Toolbox for Redshift

Last updated

Was this helpful?