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
        • Rapid Map Prototyping
      • Charts and widgets
      • Filtering and interactivity
      • 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
      • 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 6th, 2025 (v1.19.0)
  • January 30th, 2025 (v1.18.0)
  • December 19th, 2024 (v1.17.0)
  • November 27th, 2024 (v1.16.0)
  • October 28th, 2024 (v1.15.0)
  • September 24th, 2024 (v1.14.0)
  • August 23rd, 2024 (v1.13.1)
  • July 2nd, 2024 (v1.13.0)
  • May 22nd, 2024 (v1.12.0)
  • April 18th, 2024 (v1.11.0)
  • March 21st, 2024 (v1.10.0)
  • February 16th, 2024 (v1.9.0)
  • January 18th, 2024 (v1.8.0)
  • December 21, 2023 (v1.7.1)
  • November 13, 2013 (v1.7.0)
  • October 13, 2023 (v1.6.1)
  • September 8, 2023 (v1.6.0)
  • July 14, 2023 (v1.4.0)
  • June 6, 2023 (v1.3.0)
  • May 5, 2023 (v1.2.0)
  • April 4, 2023 (v1.1.1)
  • March 7, 2023 (v1.1.0)
  • January 31, 2023 (v1.0.0)
  • December 22, 2022
  • Module lds
  • Module quadbin
  • Module h3
  • November 1, 2022
  • All modules
  • October 24, 2022
  • Module processing
  • Module clustering
  • Module random
  • October 4, 2022
  • Module lds
  • September 30, 2022
  • Module lds
  • September 28, 2022
  • Module data
  • September 19, 2022
  • Module tiler
  • August 11, 2022
  • Module tiler
  • July 13, 2022
  • Module data
  • July 12, 2022
  • Module tiler
  • July 8, 2022
  • Module tiler
  • July 7, 2022
  • Module h3
  • June 24, 2022
  • Module quadbin
  • June 23, 2022
  • Module tiler
  • June 15, 2022
  • Module data
  • May 19, 2022
  • Module lds
  • May 6, 2022
  • Module data
  • April 28, 2022
  • Module data
  • April 21, 2022
  • Module tiler
  • April 20, 2022
  • Module tiler
  • April 7, 2022
  • Module transformations
  • March 25, 2022
  • Module tiler
  • March 21, 2022
  • Module transformations
  • February 24, 2022
  • Module tiler
  • February 18, 2022
  • Module lds
  • February 16, 2022
  • Module tiler
  • January 10, 2022
  • Module data
  • December 15, 2021
  • Module data
  • December 10, 2021
  • Module random
  • December 3, 2021
  • Module accessors
  • Module constructors
  • Module h3
  • Module measurements
  • Module placekey
  • Module processing
  • Module s2
  • Module transformations
  • Module clustering
  • Module data
  • Module random
  • November 25, 2021
  • Module clustering
  • Module data
  • Module random
  • November 24, 2021
  • Module data
  • November 5, 2021
  • Module data
  • November 4, 2021
  • Module data
  • September 22, 2021
  • Module h3
  • September 14, 2021
  • Module s2
  • August 24, 2021
  • Module h3
  • June 2, 2021
  • Module h3
  • May 26, 2021
  • Module processing
  • May 24, 2021
  • Module clustering
  • Module random
  • May 21, 2021
  • Module accessors
  • May 20, 2021
  • Module constructors
  • Module measurements
  • Module transformations
  • April 16, 2021
  • Module placekey
  • April 12, 2021
  • Module s2
  • April 7, 2021
  • Module h3

Was this helpful?

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

Release Notes

PreviousWorking with Raster dataNextAnalytics Toolbox for Databricks

Last updated 14 days ago

Was this helpful?

May 6th, 2025 (v1.19.0)

Module raster

Fix

  • Added a fix to keep the original geometry column from the vector input in procedure.

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

January 30th, 2025 (v1.18.0)

Module raster

Improvement

  • Added support for compressed raster tables in and .

Module statistics

Fix

December 19th, 2024 (v1.17.0)

Module lds

Improvement

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

November 27th, 2024 (v1.16.0)

Module data

New

Module lds

Fix

October 28th, 2024 (v1.15.0)

Module lds

Improvement

  • Added async batch routing services support for TomTom, providing a 2x-3x preformance improvement in processing speed.

Module statistics

New

September 24th, 2024 (v1.14.0)

Module tiler

New

Module statistics

Fix

August 23rd, 2024 (v1.13.1)

Module statistics

Fix

July 2nd, 2024 (v1.13.0)

Module raster

New

  • Adjustments to use only full-resolution data when the raster table has overviews (blocks of resolution smaller than the block_resolution stated in the metadata)

  • We can now specify per-band no-data values for raster datasets. Rasters bands also now have a ‘colorInterp’ metadata attribute with possible values of red, green, blue, alpha or unknown.

Improvement

  • Replaced some of the IFF logic checks for NODATA values with NULLIF and arithmetic operations. This allows Snowflake's planner to better optimize queries and improves performance.

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

Module h3

Improvement

Module statistics

Fix

Module http_request

New

Module import

New

April 18th, 2024 (v1.11.0)

Module raster

New

  • Added new RASTER_VALUES and RASTER_AGG_VALUES procedures:

    • RASTER_VALUES obtains pixel values from a raster where it overlaps with an optional vector data input. It accepts SQL expressions, including operations between bands.

    • RASTER_AGG_VALUES obtains aggregated values from a raster's pixel values where it intersects with a vector data input. It accepts any SQL aggregation expression.

Module clustering

Fix

Module h3

Improvement

Module lds

Fix

March 21st, 2024 (v1.10.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.

Module statistics

Fix

February 16th, 2024 (v1.9.0)

Module raster

New

Module statistics

Fix

Module lds

Fix

Module quadbin

Fix

Module random

Fix

January 18th, 2024 (v1.8.0)

Module quadbin

New

Fix

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

Module transformations

New

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

Module statistics

New

Fix

December 21, 2023 (v1.7.1)

Module statistics

Fix

Module retail

New

November 13, 2013 (v1.7.0)

Module lds

New

Module statistics

New

Fix

  • Added missing EXECUTE AS CALLER command in the procedures of this module, which was causing an error when the role that ran the procedure was not the owner.

October 13, 2023 (v1.6.1)

Module lds

Improvement

September 8, 2023 (v1.6.0)

Module statistics

New

  • The new version of the following procedures now expects a table as input, overcoming previous performance limitations:

This is a breaking change from the previous version of the functions that expected an ARRAY as input. Please make sure that you make the necessary changes if you are using this functions.

Module lds

New

  • We have added optional parameters: api_base_url, lds_token to every function/procedure

Fix

  • Fix CREATE_ROUTES fails if geom_column is not named geom

July 14, 2023 (v1.4.0)

Module lds

New

June 6, 2023 (v1.3.0)

Module lds

New

May 5, 2023 (v1.2.0)

Module statistics

New

We have added a new module named “statistics” in the Analytics Toolbox for Snowflake which has a set of geostatistics functions to compute the Getis-Ord Gi* statistic and the Moran’s I spatial autocorrelation:

  • Getis-Ord Gi* functions:

  • Moran’s I functions:

Module h3

New

Module transformations

New

April 4, 2023 (v1.1.1)

Module lds

Improvement

Change

March 7, 2023 (v1.1.0)

Module lds

New

January 31, 2023 (v1.0.0)

Module tiler

Improvement

  • 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

Module h3

November 1, 2022

All modules

Feature

  • Create release workflows

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

Feature

  • Move ST_CLUSTERKMEANS function to core.

Module random

Feature

  • 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 13, 2022

Module data

Feature

  • 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

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

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.

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

Feature

  • 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

Feature

  • 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

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.

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

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.

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

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.

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

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.

Fixed , , and procedures when using Snowpark ML in connections where there is no default schema set.

Fixed , procedures returning buckets of non-equal size (when bucketize method is “EQUAL_INTERVALS” or “EQUAL_INTERVALS_ZERO_CENTERED”).

Added procedure.

Fixed an issue that produced redundant calls in procedure.

New procedure, which expects a table containing time series (indexed by a time step column and a unique series identifier) and can group the time series in as many clusters as the user requests.

New procedure. This procedure is designed to analyze spatio-temporal data in order to identify and categorize locations based on their hotspot or coldspot status over time. Utilizing z-score values generated by the Space-Time Getis-Ord function.

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.

Update python version from 3.8 to 3.9 on and procedures, as version 3.8 is getting deprecated.

Fixed an issue with and procedures, that were returning wrong results when “time_freq” was passed as lower case.

Optimized raster procedures (, ) to manage bigger data sources.

New options in : groupby_vector_columns and groupby_raster_columns to have finer control over the aggregation.

Avoid memory limit exceeded in

Include all numeric types for unsupervised composite score validation in .

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 fewer clusters than requested. The maximum number of clusters now will be equal to the number of different points passed.

Functions in the h3 module now use internally. This change improves performance as it leverages native Snowflake optimization capabilities.

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.

Updated output table schema for the procedures and .

Add and procedures: work with CARTO raster tables, with support for custom operations, including multi-band and aggregation expressions.

: adding support for Snowflake.

Fixes in , procedures.

Add warning to procedures when no cells have neighbors.

Sanitize queries in so addresses with special characters are geocoded.

Fix so it can work with views.

Fix to accept column names and increase performance.

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

functions now return NULL when NULL parameters are passed.

New function.

Fixed a problem that caused procedure crashing for zooms higher than 13.

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

Output tables are now correctly prepared to work with Snowflake's .

Output tables are now correctly prepared to work with Snowflake's .

New , and procedures.

Replaced “index” as column name in the output tables with “h3” or “quadbin”, for easier use of the results in Builder for , * and procedures.

Output tables are now correctly prepared to work with Snowflake's .

Change output types of from Variant to the corresponding ones

Added EXECUTE AS CALLER option to and procedures. This fixes a previous issue when trying to use the procedures with a role different than the owner.

Introduced the new module for Snowflake, aimed to solve specific retail analytics use cases.

New procedure, which can be used to locate hotspot areas by calculating a combined Getis-Ord Gi* statistic over several variables.

Add procedure. This procedure allows configuring credentials and endpoints for a custom installation of the Analytics Toolbox. Check for more information about this topic.

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.

Added , procedures. These procedures allows computing the spatial autocorrelation locally.

Added procedure. This procedure allows computing a Geographically Weighed Regression on an spatial index grid.

Added , procedures. These procedures allow computing the space temporal Getis-Ord Gi* statistic for each H3 index and each datetime timestamp according to the method described in this .

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

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 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 incorporated two new functions to the “h3” module of the Analytics Toolbox, namely , which returns the center of an H3 cell as a GEOGRAPHY point, and which returns the H3 cell resolution as an integer.

We have added support for the function, which computes the convex hull of the input geographies (the smallest convex geography that covers all the input ones)

We have improved the performance in , benefiting now from parallelizing requests to the API.

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

We have added object type support for the options parameter also maintaining string type support as until now 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.

The function for invalid geographies has been fixed.

tileset
Snowflake's native H3 functions
Raster loader v0.5.0
QUADBIN
Search Optimization Service
Search Optimization Service
Search Optimization Service
retail
CREATE_ISOLINES
GETIS_ORD_H3
GETIS_ORD_QUADBIN
MORANS_I_H3
MORANS_I_QUADBIN
CREATE_ISOLINES
GEOCODE_TABLE
CREATE_ROUTES
GETIS_ORD_QUADBIN
GETIS_ORD_H3
P_VALUE
MORANS_I_QUADBIN
MORANS_I_H3
H3_CENTER
H3_RESOLUTION
ST_CONVEXHULL
GEOCODE_TABLE
quadbin
H3_BOUNDARY
Moran’s
GETIS_ORD_
this documentation
paper
LDS module
RASTER_VALUES
RASTER_AGG_VALUES
RASTER_AGG_VALUES
RASTER_VALUE
RASTER_VALUE_TABLE
CREATE_ROUTES
GEOCODE_TABLE
GEOCODE_TABLE
GEOCODE_TABLE
SETUP
GET_LDS_QUOTA_INFO
GEOCODE_TABLE
GEOCODE_REVERSE_TABLE
CREATE_ISOLINES
GEOCODE
GEOCODE_REVERSE
ISOLINE
CREATE_ISOLINES
RASTER_AGG_VALUES
RASTER_VALUES
RASTER_AGG_VALUES
ST_CLUSTERKMEANS
ST_CLUSTERKMEANS
TIME_SERIES_CLUSTERING
CREATE_SPATIAL_COMPOSITE_SUPERVISED
CREATE_SPATIAL_COMPOSITE_UNSUPERVISED
CREATE_SPATIAL_COMPOSITE_SUPERVISED
CREATE_SPATIAL_COMPOSITE_UNSUPERVISED
TIME_SERIES_CLUSTERING
SPACETIME_HOTSPOTS_CLASSIFICATION
GETIS_ORD_SPACETIME_H3
GETIS_ORD_SPACETIME_QUADBIN
CREATE_SPATIAL_COMPOSITE_UNSUPERVISED
CREATE_SPATIAL_COMPOSITE_SUPERVISED
CREATE_SPATIAL_COMPOSITE_UNSUPERVISED
CREATE_SPATIAL_COMPOSITE_UNSUPERVISED
GETIS_ORD_SPACETIME
Moran's I
CREATE_SPATIAL_COMPOSITE_SUPERVISED
CREATE_SPATIAL_COMPOSITE_UNSUPERVISED
CRONBACH_ALPHA_COEFFICIENT
GWR_GRID
GWR_GRID
GETIS_ORD_SPACETIME_QUADBIN
GETIS_ORD_SPACETIME_H3
LOCAL_MORANS_I_H3
LOCAL_MORANS_I_QUADBIN
GWR_GRID
GETIS_ORD_SPACETIME_H3
GETIS_ORD_SPACETIME_QUADBIN
ST_GENERATEPOINTS
IMPORT_URL
HTTP_REQUEST
CREATE_SPATIAL_COMPOSITE_SUPERVISED
ST_POINTONSURFACE
H3_POLYFILL_TABLE
ENRICH_POLYGONS_WEIGHTED
COMMERCIAL_HOTSPOTS
QUADBIN_TOPARENT
QUADBIN_DISTANCE
CREATE_ISOLINES
CREATE_SPATIAL_COMPOSITE_UNSUPERVISED
usage quota
CREATE_SIMPLE_TILESET
CREATE_SIMPLE_TILESET
CREATE_POINT_AGGREGATION_TILESET