LogoLogo
HomeAcademyLoginTry for free
  • Welcome
  • What's new
    • Q2 2025
    • Q1 2025
    • Q4 2024
    • Q3 2024
    • Q2 2024
    • Q1 2024
    • Q4 2023
    • Q3 2023
    • Q2 2023
    • Q1 2023
    • Q4 2022
    • Q3 2022
  • FAQs
    • Accounts
    • Migration to the new platform
    • User & organization setup
    • General
    • Builder
    • Workflows
    • Data Observatory
    • Analytics Toolbox
    • Development Tools
    • Deployment Options
    • CARTO Basemaps
    • CARTO for Education
    • Support Packages
    • Security and Compliance
  • Getting started
    • What is CARTO?
    • Quickstart guides
      • Connecting to your data
      • Creating your first map
      • Creating your first workflow
      • Developing your first application
    • CARTO Academy
  • CARTO User Manual
    • Overview
      • Creating your CARTO organization
      • CARTO Cloud Regions
      • CARTO Workspace overview
    • Maps
      • Data sources
        • Simple features
        • Spatial Indexes
        • Pre-generated tilesets
        • Rasters
        • Defining source spatial data
        • Managing data freshness
        • Changing data source location
      • Layers
        • Point
          • Grid point aggregation
          • H3 point aggregation
          • Heatmap point aggregation
          • Cluster point aggregation
        • Polygon
        • Line
        • Grid
        • H3
        • Raster
        • Zoom to layer
      • Widgets
        • Formula widget
        • Category widget
        • Pie widget
        • Histogram widget
        • Range widget
        • Time Series widget
        • Table widget
      • SQL Parameters
        • Date parameter
        • Text parameter
        • Numeric parameter
        • Publishing SQL parameters
      • Interactions
      • Legend
      • Basemaps
        • Basemap selector
      • AI Agents
      • SQL analyses
      • Map view modes
      • Map description
      • Feature selection tool
      • Search locations
      • Measure distances
      • Exporting data
      • Download PDF reports
      • Managing maps
      • Sharing and collaboration
        • Editor collaboration
        • Map preview for editors
        • Map settings for viewers
        • Comments
        • Embedding maps
        • URL parameters
      • Performance considerations
    • Workflows
      • Workflow canvas
      • Results panel
      • Components
        • Aggregation
        • Custom
        • Data Enrichment
        • Data Preparation
        • Generative AI
        • Input / Output
        • Joins
        • Parsers
        • Raster Operations
        • Spatial Accessors
        • Spatial Analysis
        • Spatial Constructors
        • Spatial Indexes
        • Spatial Operations
        • Statistics
        • Tileset Creation
        • BigQuery ML
        • Snowflake ML
        • Google Earth Engine
        • Google Environment APIs
        • Telco Signal Propagation Models
      • Data Sources
      • Scheduling workflows
      • Sharing workflows
      • Using variables in workflows
      • Executing workflows via API
      • Temporary data in Workflows
      • Extension Packages
      • Managing workflows
      • Workflows best practices
    • Data Explorer
      • Creating a map from your data
      • Importing data
        • Importing rasters
      • Geocoding data
      • Optimizing your data
    • Data Observatory
      • Terminology
      • Browsing the Spatial Data Catalog
      • Subscribing to public and premium datasets
      • Accessing free data samples
      • Managing your subscriptions
      • Accessing your subscriptions from your data warehouse
        • Access data in BigQuery
        • Access data in Snowflake
        • Access data in Databricks
        • Access data in Redshift
        • Access data in PostgreSQL
    • Connections
      • Google BigQuery
      • Snowflake
      • Databricks
      • Amazon Redshift
      • PostgreSQL
      • CARTO Data Warehouse
      • Sharing connections
      • Deleting a connection
      • Required permissions
      • IP whitelisting
      • Customer data responsibilities
    • Applications
    • Settings
      • Understanding your organization quotas
      • Activity Data
        • Activity Data Reference
        • Activity Data Examples
        • Activity Data Changelog
      • Users and Groups
        • Inviting users to your organization
        • Managing user roles
        • Deleting users
        • SSO
        • Groups
        • Mapping groups to user roles
      • CARTO Support Access
      • Customizations
        • Customizing appearance and branding
        • Configuring custom color palettes
        • Configuring your organization basemaps
        • Enabling AI Agents
      • Advanced Settings
        • Managing applications
        • Configuring S3 Bucket for Redshift Imports
        • Configuring OAuth connections to Snowflake
        • Configuring OAuth U2M connections to Databricks
        • Configuring S3 Bucket integration for RDS for PostgreSQL Exports in Builder
        • Configuring Workload Identity Federation for BigQuery
      • Data Observatory
      • Deleting your organization
    • Developers
      • Managing Credentials
        • API Base URL
        • API Access Tokens
        • SPA OAuth Clients
        • M2M OAuth Clients
      • Named Sources
  • Data and Analysis
    • Analytics Toolbox Overview
    • Analytics Toolbox for BigQuery
      • Getting access
        • Projects maintained by CARTO in different BigQuery regions
        • Manual installation in your own project
        • Installation in a Google Cloud VPC
        • Core module
      • Key concepts
        • Tilesets
        • Spatial indexes
      • SQL Reference
        • accessors
        • clustering
        • constructors
        • cpg
        • data
        • http_request
        • import
        • geohash
        • h3
        • lds
        • measurements
        • placekey
        • processing
        • quadbin
        • random
        • raster
        • retail
        • routing
        • s2
        • statistics
        • telco
        • tiler
        • transformations
      • Guides
        • Running queries from Builder
        • Working with Raster data
      • Release notes
      • About Analytics Toolbox regions
    • Analytics Toolbox for Snowflake
      • Getting access
        • Native App from Snowflake's Marketplace
        • Manual installation
      • Key concepts
        • Spatial indexes
        • Tilesets
      • SQL Reference
        • accessors
        • clustering
        • constructors
        • data
        • http_request
        • import
        • h3
        • lds
        • measurements
        • placekey
        • processing
        • quadbin
        • random
        • raster
        • retail
        • s2
        • statistics
        • tiler
        • transformations
      • Guides
        • Running queries from Builder
        • Working with Raster data
      • Release Notes
    • Analytics Toolbox for Databricks
      • Getting access
        • Personal (former Single User) cluster
        • Standard (former Shared) cluster
      • Reference
        • lds
        • tiler
      • Guides
      • Release Notes
    • Analytics Toolbox for Redshift
      • Getting access
        • Manual installation in your database
        • Installation in an Amazon Web Services VPC
        • Core version
      • Key concepts
        • Tilesets
        • Spatial indexes
      • SQL Reference
        • clustering
        • constructors
        • data
        • http_request
        • import
        • lds
        • placekey
        • processing
        • quadbin
        • random
        • s2
        • statistics
        • tiler
        • transformations
      • Guides
        • Running queries from Builder
      • Release Notes
    • Analytics Toolbox for PostgreSQL
      • Getting access
        • Manual installation
        • Core version
      • Key concepts
        • Tilesets
        • Spatial Indexes
      • SQL Reference
        • h3
        • quadbin
        • tiler
      • Guides
        • Creating spatial index tilesets
        • Running queries from Builder
      • Release Notes
    • CARTO + Python
      • Installation
      • Authentication Methods
      • Visualizing Data
      • Working with Data
        • How to work with your data in the CARTO Data Warehouse
        • How to access your Data Observatory subscriptions
        • How to access CARTO's Analytics Toolbox for BigQuery and create visualizations via Python notebooks
        • How to access CARTO’s Analytics Toolbox for Snowflake and create visualizations via Python notebooks
        • How to visualize data from Databricks
      • Reference
    • CARTO QGIS Plugin
  • CARTO for Developers
    • Overview
    • Key concepts
      • Architecture
      • Libraries and APIs
      • Authentication methods
        • API Access Tokens
        • OAuth Access Tokens
        • OAuth Clients
      • Connections
      • Data sources
      • Visualization with deck.gl
        • Basemaps
          • CARTO Basemap
          • Google Maps
            • Examples
              • Gallery
              • Getting Started
              • Basic Examples
                • Hello World
                • BigQuery Tileset Layer
                • Data Observatory Tileset Layer
              • Advanced Examples
                • Arc Layer
                • Extrusion
                • Trips Layer
            • What's New
          • Amazon Location
            • Examples
              • Hello World
              • CartoLayer
            • What's New
      • Charts and widgets
      • Filtering and interactivity
      • Integrating Builder maps in your application
      • Summary
    • Quickstart
      • Make your first API call
      • Visualize your first dataset
      • Create your first widget
    • Guides
      • Build a public application
      • Build a private application
      • Build a private application using SSO
      • Visualize massive datasets
      • Integrate CARTO in your existing application
      • Use Boundaries in your application
      • Avoid exposing SQL queries with Named Sources
      • Managing cache in your CARTO applications
    • Reference
      • Deck (@deck.gl reference)
      • Data Sources
        • vectorTableSource
        • vectorQuerySource
        • vectorTilesetSource
        • h3TableSource
        • h3QuerySource
        • h3TilesetSource
        • quadbinTableSource
        • quadbinQuerySource
        • quadbinTilesetSource
        • rasterSource
        • boundaryTableSource
        • boundaryQuerySource
      • Layers (@deck.gl/carto)
      • Widgets
        • Data Sources
        • Server-side vs. client-side
        • Models
          • getFormula
          • getCategories
          • getHistogram
          • getRange
          • getScatter
          • getTimeSeries
          • getTable
      • Filters
        • Column filters
        • Spatial filters
      • fetchMap
      • CARTO APIs Reference
    • Release Notes
    • Examples
    • CARTO for React
      • Guides
        • Getting Started
        • Views
        • Data Sources
        • Layers
        • Widgets
        • Authentication and Authorization
        • Basemaps
        • Look and Feel
        • Query Parameters
        • Code Generator
        • Sample Applications
        • Deployment
        • Upgrade Guide
      • Examples
      • Library Reference
        • Introduction
        • API
        • Auth
        • Basemaps
        • Core
        • Redux
        • UI
        • Widgets
      • Release Notes
  • CARTO Self-Hosted
    • Overview
    • Key concepts
      • Architecture
      • Deployment requirements
    • Quickstarts
      • Single VM deployment (Kots)
      • Orchestrated container deployment (Kots)
      • Advanced Orchestrated container deployment (Helm)
    • Guides
      • Guides (Kots)
        • Configure your own buckets
        • Configure an external in-memory cache
        • Enable Google Basemaps
        • Enable the CARTO Data Warehouse
        • Configure an external proxy
        • Enable BigQuery OAuth connections
        • Configure Single Sign-On (SSO)
        • Use Workload Identity in GCP
        • High availability configuration for CARTO Self-hosted
        • Configure your custom service account
      • Guides (Helm)
        • Configure your own buckets (Helm)
        • Configure an external in-memory cache (Helm)
        • Enable Google Basemaps (Helm)
        • Enable the CARTO Data Warehouse (Helm)
        • Configure an external proxy (Helm)
        • Enable BigQuery OAuth connections (Helm)
        • Configure Single Sign-On (SSO) (Helm)
        • Use Workload Identity in GCP (Helm)
        • Use EKS Pod Identity in AWS (Helm)
        • Enable Redshift imports (Helm)
        • Migrating CARTO Self-hosted installation to an external database (Helm)
        • Advanced customizations (Helm)
        • Configure your custom service account (Helm)
    • Maintenance
      • Maintenance (Kots)
        • Updates
        • Backups
        • Uninstall
        • Rotating keys
        • Monitoring
        • Change the Admin Console password
      • Maintenance (Helm)
        • Monitoring (Helm)
        • Rotating keys (Helm)
        • Uninstall (Helm)
        • Backups (Helm)
        • Updates (Helm)
    • Support
      • Get debug information for Support (Kots)
      • Get debug information for Support (Helm)
    • CARTO Self-hosted Legacy
      • Key concepts
        • Architecture
        • Deployment requirements
      • Quickstarts
        • Single VM deployment (docker-compose)
      • Guides
        • Configure your own buckets
        • Configure an external in-memory cache
        • Enable Google Basemaps
        • Enable the CARTO Data Warehouse
        • Configure an external proxy
        • Enable BigQuery OAuth connections
        • Configure Single Sign-On (SSO)
        • Enable Redshift imports
        • Configure your custom service account
        • Advanced customizations
        • Migrating CARTO Self-Hosted installation to an external database
      • Maintenance
        • Updates
        • Backups
        • Uninstall
        • Rotating keys
        • Monitoring
      • Support
    • Release Notes
  • CARTO Native App for Snowflake Containers
    • Deploying CARTO using Snowflake Container Services
  • Get Help
    • Legal & Compliance
    • Previous libraries and components
    • Migrating your content to the new CARTO platform
Powered by GitBook
On this page
  • May 14th, 2025 (v1.11.0)
  • May 6th, 2025 (v1.10.0)
  • December 19th, 2024 (v1.9.0)
  • November 27th, 2024 (v1.8.1)
  • September 24th, 2024 (v1.8.0)
  • July 2nd, 2024 (v1.7.1)
  • May 22nd, 2024 (v1.7.0)
  • April 18th, 2024 (v1.6.1)
  • March 21st, 2024 (v1.6.0)
  • February 16th, 2024 (v1.5.1)
  • January 18th, 2024 (v1.5.0)
  • December 23, 2023 (v1.4.1)
  • November 13, 2023 (v1.4.0)
  • October 13, 2023 (v1.3.1)
  • September 8, 2023 (v1.3.0)
  • August 7, 2023 (v1.2.1)
  • July 14, 2023 (v1.2.0)
  • June 6, 2023 (v1.1.0)
  • April 4, 2023 (v1.0.2)
  • March 7, 2023 (v1.0.1)
  • January 31, 2023 (v1.0.0)
  • December 22, 2022
  • Module lds
  • Module quadbin
  • November 1, 2022
  • All modules
  • October 25, 2022
  • Module data
  • October 18, 2022
  • Module data
  • October 10, 2022
  • Module data
  • October 7, 2022
  • Module clustering
  • Module random
  • October 1, 2022
  • Module lds
  • Module lds
  • September 21, 2022
  • Module tiler
  • September 19, 2022
  • Module statistics
  • Module tiler
  • September 7, 2022
  • Module data
  • September 2, 2022
  • Module data
  • August 26, 2022
  • Module statistics
  • August 19, 2022
  • Module s2
  • August 11, 2022
  • Module tiler
  • August 9, 2022
  • Module statistics
  • July 22, 2022
  • Module lds
  • Module statistics
  • July 20, 2022
  • Module clustering
  • July 14, 2022
  • Module quadbin
  • July 12, 2022
  • Module tiler
  • July 8, 2022
  • Module quadbin
  • July 1, 2022
  • Module tiler
  • June 27, 2022
  • Module tiler
  • June 24, 2022
  • Module quadbin
  • June 20, 2022
  • Module tiler
  • June 7, 2022
  • Module lds
  • June 6, 2022
  • Module lds
  • June 2, 2022
  • Module lds
  • May 19, 2022
  • Module lds
  • May 13, 2022
  • Module tiler
  • April 21, 2022
  • Module tiler
  • March 30, 2022
  • Module tiler
  • March 25, 2022
  • Module tiler
  • March 10, 2022
  • Module tiler
  • February 25, 2022
  • Module tiler
  • February 18, 2022
  • Module lds
  • December 16, 2021
  • Module transformations
  • December 10, 2021
  • Module constructors
  • Module placekey
  • Module processing
  • Module s2
  • Module transformations
  • Module clustering
  • Module random
  • October 21, 2021
  • Module clustering
  • October 6, 2021
  • Module processing
  • Module transformations
  • October 5, 2021
  • Module clustering
  • Module random
  • September 23, 2021
  • Module s2
  • September 17, 2021
  • Module constructors
  • September 7, 2021
  • Module placekey

Was this helpful?

Export as PDF
  1. Data and Analysis
  2. Analytics Toolbox for Redshift

Release Notes

PreviousRunning queries from BuilderNextAnalytics Toolbox for PostgreSQL

Last updated 19 days ago

Was this helpful?

May 14th, 2025 (v1.11.0)

Module lds

New

  • Added which computes route data between a set of origin and destination points and generates a table adding the distance and time of each pair of values.

May 6th, 2025 (v1.10.0)

Module lds

Fix

  • Added a fix to have better handling of null values in all procedures

Module clustering

Fix

  • Added a fix to prevent the procedure from throwing an error when encountering null values in Geography columns

December 19th, 2024 (v1.9.0)

Module lds

Improvement

  • Added a verification of AT Gateway parameters during the SETUP process to ensure availability of resources.

November 27th, 2024 (v1.8.1)

Module lds

Fix

September 24th, 2024 (v1.8.0)

Module tiler

New

Module lds

Fix

July 2nd, 2024 (v1.7.1)

Module import

Fix

  • Import functions in AT Gateway now raise an exception when there is an error. This replaces the previous status message.

May 22nd, 2024 (v1.7.0)

Module http_request

New

Module import

New

April 18th, 2024 (v1.6.1)

Module clustering

Fix

Module lds

Fix

March 21st, 2024 (v1.6.0)

Module lds

New

  • All external functions (including those used by the procedures in the lds module) now use a single, unified endpoint. This also simplifies the manual installation of the Analytics Toolbox.

February 16th, 2024 (v1.5.1)

Module lds

Fix

January 18th, 2024 (v1.5.0)

Module quadbin

New

Fix

  • Improved precision when calculating cell indexes from latitudes close to the poles (±90º).

Module constructors

Fix

Module transformations

Fix

Module tiler

Fix

Module data

Fix

  • Fixed an issue when using AVG aggregation, that was not correctly computed when “data_query” contained NULL values.

Module lds

Fix

December 23, 2023 (v1.4.1)

Module lds

Fix

Module tiler

Fix

  • Tiler support for non-integer numeric properties. We have corrected a problem that was causing problems when using numeric properties with decimal values.

November 13, 2023 (v1.4.0)

Module lds

New

October 13, 2023 (v1.3.1)

Module tiler

Improvement

  • Performance optimizations for the produres that generate tilesets:

Module lds

Improvement

September 8, 2023 (v1.3.0)

Module lds

New

  • Add optional parameters: api_base_url, lds_token to every function/procedure.

August 7, 2023 (v1.2.1)

Module lds

Fix

July 14, 2023 (v1.2.0)

Module lds

New

Fix

Module quadbin

Change

\

June 6, 2023 (v1.1.0)

Module lds

New

April 4, 2023 (v1.0.2)

Module lds

Change

March 7, 2023 (v1.0.1)

Module lds

Fix

January 31, 2023 (v1.0.0)

Module tiler

Improvements

  • Update default zoom values: geo, quadbin, h3 (12, 12, 6)

  • Fix spatial index tiler with empty properties

December 22, 2022

Module lds

Improvement

Module quadbin

New

November 1, 2022

All modules

Feature

  • Create release workflows

Improvement

  • Adapt to Semver

October 25, 2022

Module data

Fix

  • Fix enrichment procedures not working with VARCHAR variables for aggregation types MIN, MAX and COUNT.

October 18, 2022

Module data

Fix

  • Fix enrichment procedures returning inconsistent results for input queries containing LIMIT.

  • Fix ST_AREA returning NULL by using ST_SIMPLIFY.

  • Fix inconsistent values resturned because of ST_ENVELOPE.

October 10, 2022

Module data

Feature

  • Add DATAOBS_ENRICH_POINTS procedure.

  • Add DATAOBS_ENRICH_POLYGONS procedure.

  • Add DATAOBS_ENRICH_GRID procedure.

  • Add ENRICH_GRID procedure.

October 7, 2022

Module clustering

Feature

  • Move ST_CLUSTERKMEANS function to core.

  • Move CREATE_CLUSTERKMEANS procedure to core.

Module random

Feature

  • Move ST_GENERATEPOINTS function to core.

October 1, 2022

Module lds

Improvement

Module lds

Improvement

  • Rename LDS_API_URL to API_BASE_URL.

September 21, 2022

Module tiler

Fix

  • Fix CREATE_SPATIAL_INDEX_TILESET returning nested UDFs error when detecting the index type.

September 19, 2022

Module statistics

Improvement

  • Add p-values in the output of GETIS_ORD_QUADBIN function.

Module tiler

Improvement

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

September 7, 2022

Module data

Feature

  • Add ENRICH_POLYGONS procedure.

September 2, 2022

Module data

Feature

  • Add ENRICH_POINTS procedure.

August 26, 2022

Module statistics

Feature

  • Add GETIS_ORD_QUADBIN function.

August 19, 2022

Module s2

Fix

  • Fix S2_BOUNDARY inverted coordinates.

August 11, 2022

Module tiler

Improvement

  • Unify extra_metadata into metadata in tiler metadata.

August 9, 2022

Module statistics

Feature

  • Add P_VALUE function.

July 22, 2022

Module lds

Feature

  • Add GEOCODE_REVERSE_TABLE procedure.

Module statistics

Feature

  • Create statistics module.

  • Add MORANS_I_QUADBIN function.

July 20, 2022

Module clustering

Feature

  • Add CREATE_CLUSTERKMEANS procedure.

July 14, 2022

Module quadbin

Improvement

  • Update functions volatility.

  • QUADBIN_FROMZXY accepting BIGINTs as params instead of INTs.

July 12, 2022

Module tiler

Improvement

  • Improve speed of CREATE_SPATIAL_INDEX_TILESET.

July 8, 2022

Module quadbin

Improvement

  • Release SQL version of QUADBIN_TOZXY.

July 1, 2022

Module tiler

Improvement

  • Support h3int from CREATE_SPATIAL_INDEX_TILESET.

June 27, 2022

Module tiler

Improvement

  • Support quadbin from CREATE_SPATIAL_INDEX_TILESET instead of quadint.

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

  • Add QUADBIN_TOCHILDREN function.

  • Add QUADBIN_TOPARENT function.

  • Add QUADBIN_TOZXY function.

June 20, 2022

Module tiler

Feature

  • Add CREATE_SPATIAL_INDEX_TILESET procedure.

June 7, 2022

Module lds

Fix

  • Fix chunks in CREATE_ISOLINES.

June 6, 2022

Module lds

Improvement

  • Check if the user has enough credits to execute CREATE_ISOLINES.

June 2, 2022

Module lds

Feature

  • Add CREATE_ISOLINES procedure.

May 19, 2022

Module lds

Improvement

  • Add optional language parameter to GEOCODE_REVERSE function.

May 13, 2022

Module tiler

Feature

  • Add max_simplification_zoom and coordinates_precision parameters.

April 21, 2022

Module tiler

Feature

  • Add max_tile_size_strategy support for CREATE_SIMPLE_TILESET.

Fix

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

March 30, 2022

Module tiler

Fix

  • Escape special characters in generated properties.

March 25, 2022

Module tiler

Improvement

  • 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

Fix

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

December 10, 2021

Module constructors

Improvement

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

Removed

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

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 random

Improvement

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

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

Removed

  • Remove VERSION function.

October 21, 2021

Module clustering

Improvement

  • 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 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 7, 2021

Module placekey

Feature

  • Create placekey module.

  • Add H3_ASPLACEKEY function.

  • Add PLACEKEY_ASH3 function.

  • Add ISVALID function.

  • Add VERSION function.

Fixed an issue that produced redundant calls in procedure.

Add tile_resolution to all creation options. This new setting allows controlling the size of the tiles when rendered in a map. Higher values produce larger tiles.

Improved handling of FQNs in and procedures..

We have a new module named “http_request”. It allows making requests to external endpoints through the function .

We have a new module named “import”. It allows importing tables for a given URL containing a file in any of the formats supported by the CARTO Import API. The procedure in charge of this import is .

Update in order to avoid generating less clusters than requested. The maximum number of clusters now will be equal to the number of different points passed.

not working properly for “geom_column” parameters value different from “geom”.

now uses async batch geocoding with TomTom, boosting the geocoding speed considerably. Also matching by rows is applied ensuring that the address that reaches the TomTom endpoints is as similar as possible as the table value.

fixed a problem with using input credentials for all requests.

Fixed support for waypoints in .

New function that returns the distance (number of cells) between two quadbin cells.

Fixed a problem with the output of and functions, they now return a GEOMETRY type column instead of a VARCHAR.

Fixed a problem with the output of function, it now returns a GEOMETRY with SRID 4326.

Fixed a problem with the output of , , , and functions, they now return a GEOMETRY with SRID 4326.

Fixed a problem with procedure, that was crashing when the value for the “max_tile_size_strategy” property was "drop_fraction_as_needed" in points tables.

Improved tile precision when creating tilesets from geometries containing points with latitudes close to the poles (±90º) using or .

Improved bounds calculation to get an approximate value when using h3 cells in the procedure.

malfunctioning for multi-line addresses with multiple rows with scape line and indentations.

Accept one or more AWS roles for the function

Add procedure. This procedure allows configuring credentials and endpoints of an Analytics Toolbox installation. Find more information about this topic in .

Replace LDS_QUOTA_INFO by function. This new function allows checking your currently consumed quota with a single query, without the need to store the result as a table.

New batch service for . Used automatically by the procedure. No changes required.

We have made the procedure more robust for special characters contained in the address data.

We are now allowing users to send any of the parameter options supported by the isolines service provider in .

We have improved our logging of results in so more information about processed and geocoded rows is provided to the user. Also the new option “carto_force_geocode” allows the re-geocoding of already geocoded rows.

We have applied some fixes to the function so the metadata column can be successfully created and informed.

We have updated the formula used in so it gets standardized. In addition a new implementation of has been added in order to increase performance.

We have created a new procedure named , which calculates the routes (returned as linestrings) between a set of given origins and destinations (points) in a query. It supports different transport modes and advanced options as the other functions of the lds module.

We have updated the to be aligned with the new model, working as an annual budget and combining consumption across all supported LDS services.

Returning geometries with proper srid (4326) in , , and .

We have added the possibility to configure more options as parameters when executing the functions to . These new options, which depend on the LDS service provider, allow the user to configure more transportation modes such as truck or bike, the possibility of specifying departure or arrival times allowing the creation of reverse isolines, and other options like different routing modes.

Added new confidence/relevance metadata to the results of the geocoding function .

Quadbin/quadkey conversion functions have been added to ease the conversion from to quadkey and from quadkey to quadbin indexes.

CREATE_ROUTING_MATRIX
ST_CLUSTERKMEANS
CREATE_ROUTES
tileset
CREATE_ISOLINES
CREATE_ROUTES
HTTP_REQUEST
IMPORT_URL
ST_CLUSTERKMEANS
GEOCODE_TABLE
GEOCODE_TABLE
CREATE_ISOLINES
CREATE_ROUTES
QUADBIN_DISTANCE
ST_BEZIERSPLINE
ST_MAKEELLIPSE
ST_MAKEENVELOPE
ST_CENTERMEAN
ST_CENTERMEDIAN
ST_CENTROID
ST_DESTINATION
ST_GREATCIRCLE
CREATE_SIMPLE_TILESET
CREATE_SIMPLE_TILESET
CREATE_POINT_AGGREGATION_TILESET
CREATE_SPATIAL_INDEX_TILESET
GEOCODE_TABLE
SETUP
SETUP
this documentation
GET_LDS_QUOTA_INFO
CREATE_POINT_AGGREGATION_TILESET
CREATE_SIMPLE_TILESET
CREATE_ISOLINES
GEOCODE_TABLE
CREATE_ISOLINES
GEOCODE_TABLE
CREATE_ROUTES
QUADBIN_FROMLONGLAT
QUADBIN_TOCHILDREN
CREATE_ROUTES
LDS module
usage quota
GEOCODE_TABLE
CREATE_ISOLINES
GEOCODE
ISOLINE
CREATE_ISOLINES
GEOCODE_TABLE
quadbin