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.

Spatial Operations

Component	BigQuery	Snowflake	Redshift	PostgreSQL
Distance Matrix	✔️	✔️	✔️	✔️
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	✔️	❌	❌	✔️

Parsers

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

Data Preparation

Component	BigQuery	Snowflake	Redshift	PostgreSQL
Cast	✔️	✔️	✔️	✔️
Create Column	✔️	✔️	✔️	✔️
Drop Column	✔️	✔️	✔️	✔️
Generate UUID	✔️	✔️	❌	❌
Geography to Geometry	❌	✔️	✔️	✔️
Geometry to Geography	❌	✔️	✔️	✔️
Limit	✔️	✔️	✔️	✔️
Normalize	✔️	✔️	✔️	✔️
Order by	✔️	✔️	✔️	✔️
Remove Duplicated	✔️	✔️	✔️	✔️
Rename Column	✔️	✔️	✔️	✔️
Sample	✔️	✔️	✔️	✔️
Select	✔️	✔️	✔️	✔️
Select Distinct	✔️	✔️	✔️	✔️
Simple Filter	✔️	✔️	✔️	✔️
Spatial Filter	✔️	✔️	✔️	✔️
ST SetSRID	❌	❌	✔️	✔️
Where	✔️	✔️	✔️	✔️

Spatial Constructors

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

Custom

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

Spatial Analysis

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

Aggregation

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

Joins

Component	BigQuery	Snowflake	Redshift	PostgreSQL
Cross Join	✔️	✔️	✔️	✔️
Join	✔️	✔️	✔️	✔️
Spatial Join	✔️	✔️	✔️	✔️
ST Difference	✔️	✔️	❌	✔️
ST Intersection	✔️	✔️	✔️	✔️
Union All	✔️	✔️	✔️	✔️

Spatial Accessors

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

Spatial Indexes

Component	BigQuery	Snowflake	Redshift	PostgreSQL
H3 Boundary	✔️	✔️	❌	❌
H3 Center	✔️	❌	❌	❌
H3 from GeoPoint	✔️	✔️	❌	❌
H3 Polyfill	✔️	✔️	❌	❌
Quadbin Boundary	✔️	✔️	✔️	✔️
Quadbin Center	✔️	✔️	✔️	✔️
Quadbin from GeoPoint	✔️	✔️	✔️	✔️
Quadbin Polyfill	✔️	✔️	✔️	❌

Import/Export

Component	BigQuery	Snowflake	Redshift	PostgreSQL
Get Table by Name	✔️	✔️	✔️	✔️
Import from URL	✔️	❌	❌	❌
Save as Table	✔️	✔️	✔️	✔️
Send by Email	✔️	❌	❌	❌

Compatibility Mode

Component	BigQuery	Snowflake	Redshift	PostgreSQL
A Append Fields	✔️	❌	❌	❌
A Buffer	✔️	❌	❌	❌
A Spatial Info	✔️	❌	❌	❌
A Create Points	✔️	❌	❌	❌
A Distance	✔️	❌	❌	❌
A Find Nearest	✔️	❌	❌	❌
A Generalize	✔️	❌	❌	❌
A Join	✔️	❌	❌	❌
A Poly Build	✔️	❌	❌	❌
A Poly Split	✔️	❌	❌	❌
A Spatial Match	✔️	❌	❌	❌
A Spatial Process	✔️	❌	❌	❌
A Trade Areas	✔️	❌	❌	❌
A Union	✔️	❌	❌	❌