Data Preparation
Joining different datasets by a common column
CARTO DW | BigQuery | Snowflake | Redshift | PostgreSQL |
---|---|---|---|---|
This example demonstrates how to use Workflows to join two tables based on a common ID on both tables.
Join two datasets and group by a property
CARTO DW | BigQuery | Snowflake | Redshift | PostgreSQL |
---|---|---|---|---|
This example shows how to use Workflows to join two tables together and then group by a specific property, producing aggregated data coming from both sources.
Union of two data sources with same schema
CARTO DW | BigQuery | Snowflake | Redshift | PostgreSQL |
---|---|---|---|---|
This example demonstrates how to use Workflows to generate a table that contains all the rows from two different sources with the same schema.
Filter rows using a custom geography
CARTO DW | BigQuery | Snowflake | Redshift | PostgreSQL |
---|---|---|---|---|
This example demonstrates how to use Workflows to filter a data source using a custom geography input.
Generate a calculated column from a multi-column formula
CARTO DW | BigQuery | Snowflake | Redshift | PostgreSQL |
---|---|---|---|---|
This example demonstrates how to use Workflows to generate a new column using a formula that involves different columns in the calculation.
Normalize a variable to an index between 0 and 1
CARTO DW | BigQuery | Snowflake | Redshift | PostgreSQL |
---|---|---|---|---|
This example demonstrates how to use Workflows to obtain a normalized index from a column in your dataset.
Rank and limit a table
CARTO DW | BigQuery | Snowflake | Redshift | PostgreSQL |
---|---|---|---|---|
This example demonstrates how to use Workflows to sort a table by a specific property, and only keep a certain number of rows.
Filter columns
CARTO DW | BigQuery | Snowflake | Redshift | PostgreSQL |
---|---|---|---|---|
This example demonstrates how to use Workflows to reduce a dataset to a smaller number of columns required for a specific analysis..