Components

Components in CARTO Workflows are, together with the data sources, the available resources to build your analytical workflows. To use these elements, drag and drop them from the Components Explorer to the Workflow canvas.

In this section you can find the list of all components in CARTO Workflows and their availability in the different cloud data warehouse platforms. Please check this page regularly as currently we are continuously incorporating new components and also completing their availability across platforms.

This section also contains information about Extension Packages, which extend Workflows' functionality for specific use cases.

Extension Packages can be created for workflows that use BigQuery and Snowflake connections.

In addition to the extensions created by external developers, partners and other third-parties, CARTO provides a collection of extension packages developed and maintained internally. These are described below, and are distributed via .zip files that can be installed from the Workflows UI.

Please note that the components available via your CARTO Data Warehouse connection are the same ones as for Google BigQuery.

Aggregation

Component	BigQuery	Snowflake	Databricks	Redshift	PostgreSQL
Count	✔️	✔️	✔️	✔️	✔️
Group by	✔️	✔️	✔️	✔️	✔️
Point Stats in Polygons	✔️	✔️	✔️	✔️	✔️
ST Dump	✔️	❌	✔️	❌	❌
Summarize	✔️	✔️	✔️	✔️	✔️
Unnest	✔️	❌	✔️	❌	❌

Custom

Component	BigQuery	Snowflake	Databricks	Redshift	PostgreSQL
Call Procedure	✔️	✔️	❌	✔️	✔️
Custom Python Code	❌	❌	✔️	❌	❌
Custom SQL Select	✔️	✔️	✔️	✔️	✔️

Data Enrichment

Component	BigQuery	Snowflake	Databricks	Redshift	PostgreSQL
Enrich H3 Grid	✔️	✔️	(coming soon)	❌	❌
Enrich Points	✔️	✔️	(coming soon)	✔️	❌
Enrich Polygons	✔️	✔️	(coming soon)	✔️	❌
Enrich Polygons with Weights	✔️	(coming soon)	(coming soon)	❌	❌
Enrich Quadbin Grid	✔️	✔️	(coming soon)	✔️	❌

Data Preparation

Component	BigQuery	Snowflake	Databricks	Redshift	PostgreSQL
Case When	✔️	✔️	✔️	✔️	✔️
Cast	✔️	✔️	✔️	✔️	✔️
Create Column	✔️	✔️	✔️	✔️	✔️
Columns to Array	✔️	✔️	✔️	✔️	✔️
Drop Columns	✔️	✔️	✔️	✔️	✔️
Edit Schema	✔️	✔️	✔️	✔️	✔️
Extract from JSON	✔️	✔️	✔️	✔️	✔️
Find Replace	✔️	✔️	❌	✔️	❌
Generate UUID	✔️	✔️	✔️	❌	❌
Geography to Geometry	❌	✔️	❌	✔️	✔️
Geometry to Geography	❌	✔️	❌	✔️	✔️
Hex Color Generator	✔️	✔️	✔️	✔️	✔️
Limit	✔️	✔️	✔️	✔️	✔️
Multi-col formula	✔️	✔️	✔️	✔️	✔️
Multi-row formula	✔️	✔️	✔️	✔️	✔️
Normalize	✔️	✔️	✔️	✔️	✔️
Order by	✔️	✔️	✔️	✔️	✔️
Poly Build	✔️	❌	❌	❌	❌
Poly Split	✔️	❌	❌	❌	❌
Remove Duplicated	✔️	✔️	✔️	✔️	✔️
Rename Column	✔️	✔️	✔️	✔️	✔️
Row Number	✔️	✔️	✔️	✔️	✔️
Sample	✔️	✔️	✔️	✔️	✔️
Select	✔️	✔️	✔️	✔️	✔️
Select Distinct	✔️	✔️	✔️	✔️	✔️
Simple Filter	✔️	✔️	✔️	✔️	✔️
Spatial Filter	✔️	✔️	✔️	✔️	✔️
ST SetSRID	❌	❌	❌	✔️	✔️
Text to columns	✔️	✔️	✔️	✔️	✔️
Transpose	✔️	✔️	✔️	✔️	✔️
Unique	✔️	❌	❌	❌	❌
Where	✔️	✔️	❌	✔️	✔️

Generative AI

Component	BigQuery	Snowflake	Databricks	Redshift	PostgreSQL
ML Generate Text	✔️	❌	❌	❌	❌

Input / Output

Component	BigQuery	Snowflake	Databricks	Redshift	PostgreSQL
Export to Bucket	✔️	❌	❌	❌	❌
Get Table by Name	✔️	✔️	✔️	✔️	✔️
HTTP Request	✔️	✔️	❌	✔️	❌
Import from URL	✔️	✔️	❌	✔️	✔️
Output	✔️	✔️	✔️	✔️	✔️
Save as Table	✔️	✔️	✔️	✔️	✔️
Send by Email	✔️	❌	❌	❌	❌

Joins

Component	BigQuery	Snowflake	Databricks	Redshift	PostgreSQL
Cross Join	✔️	✔️	✔️	✔️	✔️
Join	✔️	✔️	✔️	✔️	✔️
Join (extended)	✔️	❌	❌	❌	❌
Spatial Join	✔️	✔️	✔️	✔️	✔️
Spatial Match	✔️	❌	❌	❌	❌
ST Difference	✔️	✔️	✔️	❌	✔️
ST Intersection	✔️	✔️	✔️	✔️	✔️
Union All	✔️	✔️	✔️	✔️	✔️

Parsers

Component	BigQuery	Snowflake	Databricks	Redshift	PostgreSQL
Draw Custom Features	✔️	✔️	✔️	✔️	✔️
ST as GeoJSON	✔️	✔️	✔️	✔️	✔️
ST as Text	✔️	✔️	✔️	✔️	✔️
ST Geog from Text	✔️	✔️	✔️	✔️	✔️
ST GeogPoint	✔️	✔️	✔️	✔️	✔️
Table from GeoJSON	✔️	✔️	✔️	✔️	✔️
WKB from GeoJSON	❌	❌	✔️	❌	❌
WKB from Text	❌	❌	✔️	❌	❌

Raster Operations

Component	BigQuery	Snowflake	Databricks	Redshift	PostgreSQL
Get Values from Raster	✔️	✔️	(coming soon)	❌	❌
Intersect and Aggregate Raster	✔️	✔️	(coming soon)	❌	❌

Spatial Accessors

Component	BigQuery	Snowflake	Databricks	Redshift	PostgreSQL
ST Geometry Type	✔️	✔️	✔️	✔️	✔️
ST NumGeometries	✔️	❌	✔️	✔️	✔️
ST NumPoints	✔️	✔️	✔️	✔️	✔️
ST Point N	✔️	✔️	✔️	✔️	✔️
ST X / ST Y	✔️	✔️	✔️	✔️	✔️

Spatial Analysis

Component	BigQuery	Snowflake	Databricks	Redshift	PostgreSQL
K-Nearest Neighbors	✔️	❌	❌	❌	❌
ST Cluster DBSCAN	✔️	❌	❌	❌	❌
ST Cluster K-Means	✔️	✔️	❌	✔️	✔️
ST Count Points in Polygons	✔️	✔️	✔️	✔️	✔️
ST Delaunay Polygons	✔️	✔️	❌	✔️	✔️
ST Voronoi	✔️	✔️	✔️	✔️	✔️

Spatial Constructors

Component	BigQuery	Snowflake	Databricks	Redshift	PostgreSQL
BBOX from Values	✔️	✔️	✔️	✔️	✔️
Clip with Polygons	✔️	✔️	✔️	✔️	✔️
Create Grid	✔️	✔️	✔️	✔️	✔️
Create Isolines	✔️	✔️	❌	✔️	❌
Create Routes	✔️	✔️	❌	✔️	❌
Point from Static LatLon	✔️	✔️	✔️	✔️	✔️
Remove Holes	✔️	❌	✔️	✔️	✔️
Spatial Process	✔️	❌	❌	❌	❌
ST Boundary	✔️	❌	✔️	✔️	✔️
ST Bounding Box	✔️	✔️	✔️	✔️	✔️
ST Extent	✔️	✔️	✔️	✔️	✔️
ST Generate Points	✔️	❌	❌	❌	❌
ST Geocode	✔️	✔️	❌	✔️	❌
ST Make Line	✔️	❌	✔️	✔️	✔️
ST Make Polygon	✔️	✔️	✔️	✔️	✔️
ST Polygonize	✔️	❌	❌	✔️	✔️

Spatial Indexes

Component	BigQuery	Snowflake	Databricks	Redshift	PostgreSQL
H3 Boundary	✔️	✔️	✔️	❌	❌
H3 Center	✔️	❌	✔️	❌	❌
H3 Grid Distance	✔️	✔️	✔️	❌	✔️
H3 from GeoPoint	✔️	✔️	✔️	❌	❌
H3 KRing	✔️	✔️	✔️	❌	✔️
H3 Polyfill	✔️	✔️	✔️	❌	❌
H3 To Parent	✔️	✔️	✔️	❌	✔️
Quadbin Boundary	✔️	✔️	✔️	✔️	✔️
Quadbin Center	✔️	✔️	✔️	✔️	✔️
Quadbin from GeoPoint	✔️	✔️	✔️	✔️	✔️
Quadbin KRing	✔️	✔️	✔️	✔️	✔️
Quadbin Polyfill	✔️	✔️	✔️	✔️	❌
Quadbin To Parent	✔️	✔️	✔️	✔️	✔️

Spatial Operations

Component	BigQuery	Snowflake	Databricks	Redshift	PostgreSQL
Distance Matrix	✔️	✔️	❌	✔️	✔️
Distance (single table)	✔️	❌	❌	❌	❌
Distance to Nearest	✔️	❌	❌	❌	❌
Prepare for Visualization	❌	❌	✔️	❌	❌
Spatial Info	✔️	❌		❌	❌
ST Area	✔️	✔️	✔️	✔️	✔️
ST Buffer	✔️	✔️	✔️	✔️	✔️
ST Centroid	✔️	❌	✔️	✔️	✔️
ST Concave Hull	✔️	✔️	✔️	❌	❌
ST Convex Hull	✔️	❌	✔️	✔️	✔️
ST Distance	✔️	✔️	✔️	✔️	✔️
ST DWithin	❌	❌	✔️	❌	❌
ST Length	✔️	✔️	✔️	✔️	✔️
ST Line Interpolate Point	✔️	✔️	❌	✔️	✔️
ST Perimeter	✔️	✔️	✔️	✔️	✔️
ST Simplify	✔️	✔️	✔️	✔️	✔️
ST Snap to Grid	✔️	❌	❌	❌	✔️
Subdivide	✔️	✔️	✔️	✔️	✔️
Trade Areas	✔️	❌	❌	❌	❌

Statistics

Component	BigQuery	Snowflake	Databricks	Redshift	PostgreSQL
Cluster Time Series	✔️	❌	❌	❌	❌
Composite Score Supervised	✔️	✔️	❌	❌	❌
Composite Score Unsupervised	✔️	✔️	❌	❌	❌
Cronbach Alpha Coefficient	✔️	✔️	❌	❌	❌
Getis Ord	✔️	✔️	❌	❌	❌
Getis Ord Spacetime	✔️	✔️	❌	❌	❌
GWR	✔️	✔️	❌	❌	❌
Hotspot Analysis	✔️	Coming soon	❌	❌	❌
Local Moran's I	✔️	✔️	❌	❌	❌
Moran's I	✔️	✔️	❌	❌	❌
Spacetime Hotspots Classification	✔️	❌	❌	❌	❌

Tileset Creation

Component	BigQuery	Snowflake	Databricks	Redshift	PostgreSQL
Create H3 Aggregation Tileset	✔️	✔️	✔️	✔️	✔️
Create Point Aggregation Tileset	✔️	✔️	✔️	✔️	✔️
Create Quadbin Aggregation Tileset	✔️	✔️	✔️	✔️	✔️
Create Vector Tileset	✔️	✔️	✔️	✔️	✔️

Extension Packages

Workflows' functionality can be extended and tailored to specific use cases, by creating custom components, which can be grouped and distributed together as Extension Packages.

Extension Packages can be created for workflows that use BigQuery and Snowflake connections.

In addition to the extensions created by external developers, partners and other third-parties, CARTO provides a collection of extension packages developed and maintained internally. These are described below, and are distributed via .zip files that can be installed from the Workflows UI.

Google Earth Engine

Component	BigQuery
Summary Region	✔️
Summary Table	✔️
Get Elevation	✔️
Get NDVI	✔️
Get Precipitation	✔️

Google Environment APIs

Component	BigQuery
Solar API Building Insights	✔️
Air Quality API Current Conditions	✔️
Air Quality API Forecast	✔️
Air Quality API History	✔️
Pollen API Forecast	✔️

Telco Signal Propagation Models

Component	BigQuery
Path Profile	✔️
Path Profile Raster	✔️
Close In	✔️
Extended HATA	✔️