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
Spatial Operations
Component
BigQuery
Snowflake
Redshift
PostgreSQL
​Distance Matrix​
​✔
​
​✔
​
​✔
​
​✔
​
​Distance (single table)​
​✔
​
​❌
​
​❌
​
​❌
​
​Find 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​
​✔
​
​❌
​
​❌
​
​✔
​
​Trade Areas​
​✔
​
​❌
​
​❌
​
​❌
​
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​
​✔
​
​✔
​
​✔
​
​✔
​
​Find Replace​
​✔
​
​✔
​
​✔
​
​❌
​
​Generate UUID​
​✔
​
​✔
​
​❌
​
​❌
​
​Geography to Geometry​
​❌
​
​✔
​
​✔
​
​✔
​
​Geometry to Geography​
​❌
​
​✔
​
​✔
​
​✔
​
​Limit​
​✔
​
​✔
​
​✔
​
​✔
​
​Multi-col formula​
​✔
​
​✔
​
​✔
​
​✔
​
​Multi-row formula​
​✔
​
​✔
​
​✔
​
​✔
​
​Normalize​
​✔
​
​✔
​
​✔
​
​✔
​
​Order by​
​✔
​
​✔
​
​✔
​
​✔
​
​Poly Build​
​✔
​
​❌
​
​❌
​
​❌
​
​Poly Split​
​✔
​
​❌
​
​❌
​
​❌
​
​Refactor Columns​
​✔
​
​✔
​
​✔
​
​✔
​
​Remove Duplicated​
​✔
​
​✔
​
​✔
​
​✔
​
​Rename Column​
​✔
​
​✔
​
​✔
​
​✔
​
​Row Number​
​✔
​
​✔
​
​✔
​
​✔
​
​Sample​
​✔
​
​✔
​
​✔
​
​✔
​
​Select​
​✔
​
​✔
​
​✔
​
​✔
​
​Select Distinct​
​✔
​
​✔
​
​✔
​
​✔
​
​Simple Filter​
​✔
​
​✔
​
​✔
​
​✔
​
​Spatial Filter​
​✔
​
​✔
​
​✔
​
​✔
​
​ST SetSRID​
​❌
​
​❌
​
​✔
​
​✔
​
​Text to columns​
​✔
​
​✔
​
​✔
​
​✔
​
​Transpose​
​✔
​
​✔
​
​✔
​
​✔
​
​Unique​
​✔
​
​❌
​
​❌
​
​❌
​
​Where​
​✔
​
​✔
​
​✔
​
​✔
​
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​
​✔
​
​❌
​
​✔
​
​✔
​
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​
​✔
​
​✔
​
​✔
​
​✔
​
​Join (extended)​
​✔
​
​❌
​
​❌
​
​❌
​
​Spatial Join​
​✔
​
​✔
​
​✔
​
​✔
​
​Spatial Match​
​✔
​
​❌
​
​❌
​
​❌
​
​ST Difference​
​✔
​
​✔
​
​❌
​
​✔
​
​ST Intersection​
​✔
​
​✔
​
​✔
​
​✔
​
​Union All​
​✔
​
​✔
​
​✔
​
​

Component	BigQuery	Snowflake	Redshift	PostgreSQL
Distance Matrix	✔	✔	✔	✔
Distance (single table)	✔	❌	❌	❌
Find 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	✔	❌	❌	✔
Trade Areas	✔	❌	❌	❌

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

Component	BigQuery	Snowflake	Redshift	PostgreSQL
Cast	✔	✔	✔	✔
Create Column	✔	✔	✔	✔
Drop Column	✔	✔	✔	✔
Find Replace	✔	✔	✔	❌
Generate UUID	✔	✔	❌	❌
Geography to Geometry	❌	✔	✔	✔
Geometry to Geography	❌	✔	✔	✔
Limit	✔	✔	✔	✔
Multi-col formula	✔	✔	✔	✔
Multi-row formula	✔	✔	✔	✔
Normalize	✔	✔	✔	✔
Order by	✔	✔	✔	✔
Poly Build	✔	❌	❌	❌
Poly Split	✔	❌	❌	❌
Refactor Columns	✔	✔	✔	✔
Remove Duplicated	✔	✔	✔	✔
Rename Column	✔	✔	✔	✔
Row Number	✔	✔	✔	✔
Sample	✔	✔	✔	✔
Select	✔	✔	✔	✔
Select Distinct	✔	✔	✔	✔
Simple Filter	✔	✔	✔	✔
Spatial Filter	✔	✔	✔	✔
ST SetSRID	❌	❌	✔	✔
Text to columns	✔	✔	✔	✔
Transpose	✔	✔	✔	✔
Unique	✔	❌	❌	❌
Where	✔	✔	✔	✔

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	✔	❌	✔	✔

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

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

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