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
      • Publishing and sharing maps
        • Map settings for viewers
        • Map preview for editors
        • Collaborative maps
        • 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
  • February 18th, 2025 (v1.1.0)
  • January 30th, 2025 (v1.0.1)
  • October 31st, 2024 (v1.0.0)
  • October 24, 2022
  • Tiler
  • October 19, 2022
  • All modules
  • October 10, 2022
  • Tiler
  • September 21, 2022
  • All modules
  • Accessors
  • All modules
  • September 20, 2022
  • All modules
  • September 16, 2022
  • All modules
  • Module parsers
  • All modules
  • September 15, 2022
  • All modules
  • Module formatters
  • September 6, 2022
  • Module accessors
  • Module indexing
  • September 1, 2022
  • All modules
  • August 29, 2022
  • Module indexing
  • Module formatters
  • Module parsers
  • Module predicates
  • Module transformations
  • August 19, 2022
  • Module accessors
  • Module constructors
  • Module formatters
  • Module measurements
  • Module parsers
  • Module predicates
  • Module transformations

Was this helpful?

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

Release Notes

PreviousGuidesNextAnalytics Toolbox for Redshift

Last updated 2 months ago

Was this helpful?

February 18th, 2025 (v1.1.0)

Module lds

New

  • Added , containing: , , , , , , and .

January 30th, 2025 (v1.0.1)

Module tiler

Fix

  • Fixed , , and procedures returning an error unless extra_metadata is added.

October 31st, 2024 (v1.0.0)

Module tiler

New

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

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

    • : Generates a tileset with aggregated points and properties.

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

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

Apache Sedona

New


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.

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

Apache Sedona 1.5.1
LDS module
tiler
CREATE_POINT_AGG_TILESET
CREATE_H3_AGG_TILESET
CREATE_QUADBIN_AGG_TILESET
CREATE_VECTOR_TILESET
CREATE_POINT_AGG_TILESET
CREATE_H3_AGG_TILESET
CREATE_QUADBIN_AGG_TILESET
GEOCODE_TABLE
GEOCODE_REVERSE_TABLE
CREATE_ISOLINES
CREATE_ROUTES
GEOCODE
GEOCODE_REVERSE
ISOLINE
GET_LDS_QUOTA_INFO