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.

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

The previously available group of components named "Compatibility mode" has been removed since the release made on 14th June 2023. The majority of components of that group are now available in the other existing groups and your workflows have not been affected by this change. On the other side, the following 4 components have been removed and we kindly ask you to adapt your workflows to use the following equivalent components:

• A Buffer -> Buffer

• A Append fields -> Union

• A Crete point -> ST Geogpoint

• A Generalize -> ST Simplify

Aggregation

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

Custom

Component	BigQuery	Snowflake	Redshift	PostgreSQL
Call Procedure	✔️	✔️	✔️	✔️
Custom SQL Select	✔️	✔️	✔️	✔️

Data Enrichment

Component	BigQuery	Snowflake	Redshift	PostgreSQL
Enrich H3 Grid	✔️	✔️	❌	❌
Enrich Points	✔️	✔️	✔️	❌
Enrich Polygons	✔️	✔️	✔️	❌
Enrich Quadbin Grid	✔️	✔️	✔️	❌

Data Preparation

Component	BigQuery	Snowflake	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	Redshift	PostgreSQL
ML Generate Text	✔️	❌	❌	❌

Input / Output

Component	BigQuery	Snowflake	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	Redshift	PostgreSQL
Cross Join	✔️	✔️	✔️	✔️
Join	✔️	✔️	✔️	✔️
Join (extended)	✔️	❌	❌	❌
Spatial Join	✔️	✔️	✔️	✔️
Spatial Match	✔️	❌	❌	❌
ST Difference	✔️	✔️	❌	✔️
ST Intersection	✔️	✔️	✔️	✔️
Union All	✔️	✔️	✔️	✔️

Parsers

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

Raster Operations

Component	BigQuery	Snowflake	Redshift	PostgreSQL
Get Values from Raster	✔️	✔️	❌	❌
Intersect and Aggregate Raster	✔️	✔️	❌	❌

Spatial Accessors

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

Spatial Analysis

Component	BigQuery	Snowflake	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	Redshift	PostgreSQL
BBOX from Values	✔️	✔️	✔️	✔️
Clip with Polygons	✔️	✔️	✔️	✔️
Create Grid	✔️	✔️	✔️	✔️
Create Isolines	✔️	✔️	✔️	❌
Create Routes	✔️	✔️	✔️	❌
Create Tileset	✔️	❌	❌	❌
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	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	Redshift	PostgreSQL
Distance Matrix	✔️	✔️	✔️	✔️
Distance (single table)	✔️	❌	❌	❌
Distance to Nearest	✔️	❌	❌	❌
Spatial Info	✔️	❌	❌	❌
ST Area	✔️	✔️	✔️	✔️
ST Buffer	✔️	✔️	✔️	✔️
ST Centroid	✔️	❌	✔️	✔️
ST Concave Hull	✔️	✔️	❌	❌
ST Convex Hull	✔️	❌	✔️	✔️
ST Distance	✔️	✔️	✔️	✔️
ST Length	✔️	✔️	✔️	✔️
ST Line Interpolate Point	✔️	✔️	✔️	✔️
ST Perimeter	✔️	✔️	✔️	✔️
ST Simplify	✔️	✔️	✔️	✔️
ST Snap to Grid	✔️	❌	❌	✔️
Subdivide	✔️	✔️	✔️	✔️
Trade Areas	✔️	❌	❌	❌

Statistics

Component	BigQuery	Snowflake	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	Redshift	PostgreSQL
Create H3 Aggregation Tileset	✔️	✔️	✔️	✔️
Create Point Aggregation Tileset	✔️	✔️	✔️	✔️
Create Quadbin Aggregation Tileset	✔️	✔️	✔️	✔️
Create Vector Tileset	✔️	✔️	✔️	✔️