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 Designer Panel. 
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_CONCAVEHULL​
​✔
​
​✔
​
​❌
​
​❌
​
​ST_CONVEXHULL​
​✔
​
​❌
​
​✔
​
​✔
​
​ST_DISTANCE​
​✔
​
​✔
​
​✔
​
​✔
​
​ST_LENGTH​
​✔
​
​✔
​
​✔
​
​✔
​
​ST_LINE_INTERPOLATE_POINT​
​✔
​
​✔
​
​✔
​
​✔
​
​ST_PERIMETER​
​✔
​
​✔
​
​✔
​
​✔
​
​ST_SIMPLIFY​
​✔
​
​✔
​
​✔
​
​✔
​
​ST_SNAPTOGRID​
​✔
​
​❌
​
​❌
​
​✔
​
Parsers
Component
BigQuery
Snowflake
Redshift
PostgreSQL
​ST_ASGEOJSON​
​✔
​
​✔
​
​✔
​
​✔
​
​ST_ASTEXT​
​✔
​
​✔
​
​✔
​
​✔
​
​ST_GEOGFROMTEXT​
​✔
​
​✔
​
​✔
​
​✔
​
​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_BOUNDINGBOX​
​✔
​
​✔
​
​✔
​
​✔
​
​ST_EXTENT​
​✔
​
​✔
​
​✔
​
​✔
​
​ST_GENERATEPOINTS​
​✔
​
​❌
​
​❌
​
​❌
​
​ST_GEOCODE​
​✔
​
​✔
​
​✔
​
​❌
​
​ST_MAKELINE​
​✔
​
​❌
​
​✔
​
​✔
​
​ST_MAKEPOLYGON​
​✔
​
​✔
​
​✔
​
​✔
​
​ST_POLYGONIZE​
​✔
​
​❌
​
​✔
​
​✔
​
Custom
Component
BigQuery
Snowflake
Redshift
PostgreSQL
​CALL_PROCEDURE​
​✔
​
​✔
​
​✔
​
​✔
​
​CUSTOM_SQL_SELECT​
​✔
​
​✔
​
​✔
​
​✔
​
Spatial Analysis
Component
BigQuery
Snowflake
Redshift
PostgreSQL
​KNN_NEIGHBORS​
​✔
​
​❌
​
​❌
​
​❌
​
​ST_CLUSTERDBSCAN​
​✔
​
​❌
​
​❌
​
​❌
​
​ST_CLUSTERKMEANS​
​✔
​
​✔
​
​✔
​
​✔
​
​ST_COUNT_POINTSINPOLYGONS​
​✔
​
​✔
​
​✔
​
​✔
​
​ST_DELAUNAYPOLYGONS​
​✔
​
​✔
​
​✔
​
​✔
​
​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_GEOMETRYTYPE​
​✔
​
​✔
​
​✔
​
​✔
​
​ST_NUMGEOMETRIES​
​✔
​
​❌
​
​✔
​
​✔
​
​ST_NUMPOINTS​
​✔
​
​✔
​
​✔
​
​✔
​
​ST_POINTN​
​✔
​
​✔
​
​✔
​
​✔
​
​ST_X/ST_Y​
​✔
​
​✔
​
​✔
​
​✔
​
Spatial Indexes
Component
BigQuery
Snowflake
Redshift
PostgreSQL
​H3_BOUNDARY​
​✔
​
​✔
​
​❌
​
​❌
​
​H3_CENTER​
​✔
​
​❌
​
​❌
​
​❌
​
​H3_FROMGEOGPOINT​
​✔
​
​✔
​
​❌
​
​❌
​
​H3_POLYFILL​
​✔
​
​✔
​
​❌
​
​❌
​
​QUADBIN_BOUNDARY​
​✔
​
​✔
​
​✔
​
​✔
​
​QUADBIN_CENTER​
​✔
​
​✔
​
​✔
​
​✔
​
​QUADBIN_FROMGEOGPOINT​
​✔
​
​✔
​
​✔
​
​✔
​
​QUADBIN_POLYFILL​
​✔
​
​✔
​
​✔
​
​❌
​
Import/Export
Component
BigQuery
Snowflake
Redshift
PostgreSQL
​IMPORT_FROM_URL​
​✔
​
​❌
​
​❌
​
​❌
​
​SAVE_AS_TABLE​
​✔
​
​✔
​
​✔
​
​✔
​
​SEND_BY_EMAIL​
​✔
​
​❌
​
​❌
​
​❌
​
Compatibility Mode

Component	BigQuery	Snowflake	Redshift	PostgreSQL
DISTANCE_MATRIX	✔	✔	✔	✔
ST_AREA	✔	✔	✔	✔
ST_BUFFER	✔	✔	✔	✔
ST_CENTROID	✔	❌	✔	✔
ST_CONCAVEHULL	✔	✔	❌	❌
ST_CONVEXHULL	✔	❌	✔	✔
ST_DISTANCE	✔	✔	✔	✔
ST_LENGTH	✔	✔	✔	✔
ST_LINE_INTERPOLATE_POINT	✔	✔	✔	✔
ST_PERIMETER	✔	✔	✔	✔
ST_SIMPLIFY	✔	✔	✔	✔
ST_SNAPTOGRID	✔	❌	❌	✔

Component	BigQuery	Snowflake	Redshift	PostgreSQL
ST_ASGEOJSON	✔	✔	✔	✔
ST_ASTEXT	✔	✔	✔	✔
ST_GEOGFROMTEXT	✔	✔	✔	✔
ST_GEOGPOINT	✔	✔	✔	✔
TABLE_FROM_GEOJSON	✔	✔	✔	✔

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

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_BOUNDINGBOX	✔	✔	✔	✔
ST_EXTENT	✔	✔	✔	✔
ST_GENERATEPOINTS	✔	❌	❌	❌
ST_GEOCODE	✔	✔	✔	❌
ST_MAKELINE	✔	❌	✔	✔
ST_MAKEPOLYGON	✔	✔	✔	✔
ST_POLYGONIZE	✔	❌	✔	✔

Component	BigQuery	Snowflake	Redshift	PostgreSQL
KNN_NEIGHBORS	✔	❌	❌	❌
ST_CLUSTERDBSCAN	✔	❌	❌	❌
ST_CLUSTERKMEANS	✔	✔	✔	✔
ST_COUNT_POINTSINPOLYGONS	✔	✔	✔	✔
ST_DELAUNAYPOLYGONS	✔	✔	✔	✔
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	✔	✔	✔	✔
SPATIAL_JOIN	✔	✔	✔	✔
ST_DIFFERENCE	✔	✔	❌	✔
ST_INTERSECTION	✔	✔	✔	✔
UNION_ALL	✔	✔	✔	✔

Component	BigQuery	Snowflake	Redshift	PostgreSQL
ST_GEOMETRYTYPE	✔	✔	✔	✔
ST_NUMGEOMETRIES	✔	❌	✔	✔
ST_NUMPOINTS	✔	✔	✔	✔
ST_POINTN	✔	✔	✔	✔
ST_X/ST_Y	✔	✔	✔	✔

Component	BigQuery	Snowflake	Redshift	PostgreSQL
H3_BOUNDARY	✔	✔	❌	❌
H3_CENTER	✔	❌	❌	❌
H3_FROMGEOGPOINT	✔	✔	❌	❌
H3_POLYFILL	✔	✔	❌	❌
QUADBIN_BOUNDARY	✔	✔	✔	✔
QUADBIN_CENTER	✔	✔	✔	✔
QUADBIN_FROMGEOGPOINT	✔	✔	✔	✔
QUADBIN_POLYFILL	✔	✔	✔	❌

Component	BigQuery	Snowflake	Redshift	PostgreSQL
IMPORT_FROM_URL	✔	❌	❌	❌
SAVE_AS_TABLE	✔	✔	✔	✔
SEND_BY_EMAIL	✔	❌	❌	❌