Links

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
ST_AREA
ST_BUFFER
ST_LENGTH

Parsers

Component
BigQuery
Snowflake
Redshift
PostgreSQL
ST_ASTEXT

Data Preparation

Component
BigQuery
Snowflake
Redshift
PostgreSQL
CAST
LIMIT
NORMALIZE
ORDER_BY
SAMPLE
SELECT
WHERE

Spatial Constructors

Component
BigQuery
Snowflake
Redshift
PostgreSQL
ST_EXTENT

Custom

Component
BigQuery
Snowflake
Redshift
PostgreSQL

Spatial Analysis

Component
BigQuery
Snowflake
Redshift
PostgreSQL

Aggregation

Component
BigQuery
Snowflake
Redshift
PostgreSQL
COUNT
GROUP_BY
ST_DUMP
UNNEST

Joins

Component
BigQuery
Snowflake
Redshift
PostgreSQL
JOIN
UNION_ALL

Spatial Accessors

Component
BigQuery
Snowflake
Redshift
PostgreSQL
ST_POINTN
ST_X/ST_Y

Spatial Indexes

Component
BigQuery
Snowflake
Redshift
PostgreSQL
H3_CENTER

Import/Export

Component
BigQuery
Snowflake
Redshift
PostgreSQL

Compatibility Mode