# 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](https://docs.carto.com/carto-user-manual/workflows/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](#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](https://docs.carto.com/carto-user-manual/extension-packages#managing-extension-packages). {% hint style="info" %} Please note that the components available via your CARTO Data Warehouse connection are the same ones as for Google BigQuery. {% endhint %} ## Aggregation

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

## Control

Component	BigQuery	Snowflake	Databricks	Oracle	Redshift	PostgreSQL
Conditional Split	✔️	✔️	✔️	✔️	✔️	✔️
Success/Error Split	✔️	✔️	✔️	❌	❌	✔️

## Custom

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

## Data Enrichment

Component	BigQuery	Snowflake	Databricks	Oracle	Redshift	PostgreSQL
Downscaling	✔️	✔️	❌	❌	❌	❌
Enrich H3 Grid	✔️	✔️	✔️	❌	✔️	❌
Enrich Points	✔️	✔️	✔️	❌	✔️	❌
Enrich Polygons	✔️	✔️	✔️	❌	✔️	❌
Enrich Polygons with Weights	✔️	✔️	✔️	❌	❌	❌
Enrich Polygons with Weights (Legacy)	✔️	❌	❌	❌	❌	❌
Enrich Quadbin Grid	✔️	✔️	✔️	❌	✔️	❌

## Data Preparation

Component	BigQuery	Snowflake	Databricks	Oracle	Redshift	PostgreSQL
Case When	✔️	✔️	✔️	✔️	✔️	✔️
Cast	✔️	✔️	✔️	✔️	✔️	✔️
Columns to array	✔️	✔️	✔️	❌	✔️	✔️
Create Column	✔️	✔️	✔️	✔️	✔️	✔️
Drop Columns	✔️	✔️	✔️	✔️	✔️	✔️
Edit Schema	✔️	✔️	✔️	❌	✔️	✔️
Extract from JSON	✔️	✔️	✔️	✔️	✔️	✔️
Find and Replace	✔️	✔️	❌	❌	❌	✔️
Generate UUID	✔️	✔️	✔️	❌	❌	❌
Geography to Geometry	❌	❌	✔️	❌	✔️	✔️
Geometry to Geography	❌	✔️	✔️	❌	❌	❌
Hex Color Generator	✔️	✔️	✔️	❌	✔️	✔️
Is not Null	✔️	✔️	✔️	✔️	✔️	✔️
Limit	✔️	✔️	✔️	✔️	✔️	✔️
Multi-col formula	✔️	✔️	❌	❌	✔️	✔️
Multi-row formula	✔️	✔️	❌	❌	✔️	✔️
Normalize	✔️	✔️	✔️	✔️	✔️	✔️
Order by	✔️	✔️	✔️	✔️	✔️	✔️
Parse JSON	✔️	✔️	❌	❌	✔️	✔️
Poly Build	✔️	❌	❌	❌	❌	❌
Poly Split	✔️	❌	❌	❌	❌	❌
Remove Duplicated	✔️	✔️	✔️	✔️	✔️	✔️
Rename Column	✔️	✔️	✔️	✔️	✔️	✔️
Row number	✔️	✔️	✔️	✔️	✔️	✔️
Sample	✔️	✔️	✔️	✔️	✔️	✔️
Select	✔️	✔️	✔️	✔️	✔️	✔️
Select Distinct	✔️	✔️	✔️	✔️	✔️	✔️
Simple Filter	✔️	✔️	✔️	✔️	✔️	✔️
Spatial Filter	✔️	✔️	✔️	✔️	✔️	✔️
ST Set SRID	❌	✔️	✔️	❌	✔️	✔️
Text to columns	✔️	✔️	✔️	✔️	✔️	✔️
Transpose / Unpivot	✔️	✔️	✔️	✔️	✔️	✔️
Unique	✔️	❌	❌	❌	❌	❌
Where	✔️	✔️	✔️	✔️	✔️	✔️

## Generative AI

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

## Input / Output

Component	BigQuery	Snowflake	Databricks	Oracle	Redshift	PostgreSQL
API Output	✔️	✔️	✔️	❌	✔️	✔️
Create Builder Map	✔️	✔️	✔️	❌	✔️	❌
Export to Bucket	✔️	❌	❌	❌	❌	❌
Get Table by Name	✔️	✔️	✔️	✔️	✔️	✔️
HTTP Request	✔️	✔️	❌	❌	✔️	❌
Import from URL	✔️	✔️	❌	❌	✔️	❌
Import from URL using table	✔️	✔️	❌	❌	✔️	❌
MCP Tool Output	✔️	✔️	✔️	✔️	❌	❌
Viewer Result Output	✔️	✔️	✔️	✔️	✔️	✔️
Save as Table	✔️	✔️	✔️	✔️	✔️	✔️
Send by Email	✔️	❌	❌	❌	❌	❌

## Joins

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

## Parsers

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

## Raster Operations

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

## Spatial Accessors

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

## Spatial Analysis

Component	BigQuery	Snowflake	Databricks	Oracle	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	Oracle	Redshift	PostgreSQL
BBOX from Values	✔️	✔️	✔️	✔️	✔️	✔️
Clip with Polygons	✔️	✔️	✔️	✔️	✔️	✔️
Create Grid	✔️	✔️	✔️	❌	✔️	✔️
Create H3 Isolines	✔️	✔️	✔️	❌	✔️	❌
Create Isolines	✔️	✔️	✔️	❌	✔️	❌
Create Routes	✔️	✔️	✔️	❌	✔️	❌
Create Routing Matrix	✔️	✔️	❌	❌	✔️	❌
Oracle Geocode	❌	❌	❌	✔️	❌	❌
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	Oracle	Redshift	PostgreSQL
H3 Boundary	✔️	✔️	✔️	❌	❌	✔️
H3 Center	✔️	✔️	✔️	❌	❌	✔️
H3 from GeoPoint	✔️	✔️	✔️	❌	❌	✔️
H3 Grid Distance	✔️	✔️	✔️	❌	❌	✔️
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	Oracle	Redshift	PostgreSQL
Distance (single table)	✔️	❌	❌	❌	❌	❌
Distance Matrix	✔️	✔️	❌	❌	✔️	✔️
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	Oracle	Redshift	PostgreSQL
Cluster Time Series	✔️	✔️	❌	❌	❌	❌
Composite Score Supervised	✔️	❌	❌	❌	❌	❌
Composite Score Supervised	❌	✔️	❌	❌	❌	❌
Composite Score Unsupervised	✔️	✔️	✔️	❌	❌	❌
Cronbach Alpha Coefficient	✔️	✔️	❌	❌	❌	❌
Detect Space-time Anomalies	✔️	❌	❌	❌	❌	❌
Detect Spatial Anomalies	✔️	❌	❌	❌	❌	❌
Getis Ord	✔️	✔️	✔️	❌	❌	❌
Getis Ord Spacetime	✔️	✔️	❌	❌	❌	❌
GWR	✔️	✔️	✔️	❌	❌	❌
Hotspot Analysis	✔️	❌	❌	❌	❌	❌
Local Morans I	✔️	✔️	✔️	❌	❌	❌
Morans I	✔️	✔️	✔️	❌	❌	❌
Spacetime Hotspots Classification	✔️	✔️	❌	❌	❌	❌

## Tileset Creation

Component	BigQuery	Snowflake	Databricks	Oracle	Redshift	PostgreSQL
Create H3 Agg Tileset	✔️	✔️	❌	❌	✔️	✔️
Create Point Agg Tileset	✔️	✔️	❌	❌	✔️	✔️
Create Quadbin Agg Tileset	✔️	✔️	❌	❌	✔️	✔️
Create Vector Tileset	✔️	✔️	❌	❌	✔️	✔️

## Oracle

Component	BigQuery	Snowflake	Databricks	Oracle	Redshift	PostgreSQL
Begin/End Block	❌	❌	❌	✔️	❌	❌

## 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). 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](https://docs.carto.com/carto-user-manual/extension-packages#managing-extension-packages). ### BigQuery ML

Component	BigQuery
Create Classification Model	✔️
Create Forecast Model	✔️
Create Regression Model	✔️
Evaluate	✔️
Evaluate Forecast	✔️
Explain Forecast	✔️
Explain Predict	✔️
Forecast	✔️
Get Model by Name	✔️
Global Explain	✔️
Import Model	✔️
Predict	✔️

### Snowflake ML | Component | Snowflake | | ---------------------------------------------------------------------------------------------------------------------------------------- | :------------------: | | [Get Model by Name](https://docs.carto.com/carto-user-manual/workflows/snowflake-ml#get-model-by-name) | :heavy\_check\_mark: | | [Create Classification Model](https://docs.carto.com/carto-user-manual/workflows/snowflake-ml#create-classification-model) | :heavy\_check\_mark: | | [Create Forecasting Model](https://docs.carto.com/carto-user-manual/workflows/snowflake-ml#create-forecasting-model) | :heavy\_check\_mark: | | [Predict](https://docs.carto.com/carto-user-manual/workflows/snowflake-ml#predict) | :heavy\_check\_mark: | | [Forecast](https://docs.carto.com/carto-user-manual/workflows/snowflake-ml#forecast) | :heavy\_check\_mark: | | [Evaluate Classification](https://docs.carto.com/carto-user-manual/workflows/snowflake-ml#evaluate-classification) | :heavy\_check\_mark: | | [Evaluate Forecast](https://docs.carto.com/carto-user-manual/workflows/snowflake-ml#evaluate-forecast) | :heavy\_check\_mark: | | [Feature Importance (Classification)](https://docs.carto.com/carto-user-manual/workflows/snowflake-ml#feature-importance-classification) | :heavy\_check\_mark: | | [Feature Importance (Forecast)](https://docs.carto.com/carto-user-manual/workflows/snowflake-ml#feature-importance-forecast) | :heavy\_check\_mark: | ### 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	✔️

### Geospatial Foundation Models | Component | Bigquery | | -------------------------------------------------------------------------------------------------------------------------------------------------------------- | :------------------: | | [Google PDFM County Embeddings](https://docs.carto.com/carto-user-manual/workflows/google-pdfm-embeddings#county-embeddings) | :heavy\_check\_mark: | | [Google PDFM ZCTA Embeddings](https://docs.carto.com/carto-user-manual/workflows/google-pdfm-embeddings#zcta-embeddings) | :heavy\_check\_mark: | | [Google Earth Engine Satellite Embeddings](https://docs.carto.com/carto-user-manual/workflows/google-pdfm-embeddings#google-earth-engine-satellite-embeddings) | :heavy\_check\_mark: | ### Telco Signal Propagation Models

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

Component	BigQuery	Snowflake
Facilities Preparation	✔️	✔️
Demand Points Preparation	✔️	✔️
Cost Matrix Preparation	✔️	✔️
Constraints Definition	✔️	✔️
Location-Allocation	✔️	✔️
Territory Balancing	✔️	❌

### Analytics on Embeddings | Component | BigQuery | | ------------------------------------------------------------------------------------------------------------- | :------------------: | | [Change Detection](https://docs.carto.com/carto-user-manual/workflows/embedding-analytics#change-detection) | :heavy\_check\_mark: | | [Clustering](https://docs.carto.com/carto-user-manual/workflows/embedding-analytics#clustering) | :heavy\_check\_mark: | | [Similarity Search](https://docs.carto.com/carto-user-manual/workflows/embedding-analytics#similarity-search) | :heavy\_check\_mark: | | [Visualization](https://docs.carto.com/carto-user-manual/workflows/embedding-analytics#visualization) | :heavy\_check\_mark: | ### Trajectory Analysis

Component	BigQuery	Snowflake
Trajectory from Points	✔️	✔️
Trajectory to Points	✔️	✔️
Trajectory Splitter	✔️	✔️
Trajectory Cleaner	✔️	✔️
Trajectory Simplifier	✔️	✔️
Compute Trajectory Metrics	✔️	✔️
Distance from Trajectory	✔️	✔️
Get Position at Timestamp	✔️	✔️
Trajectory Intersection	✔️	✔️
Stop Detection	✔️	✔️