Import/Export

Components that allow you to import or export data to/from CARTO and your connected cloud data warehouse.

Get Table by Name

Description

Load a table in the workflow, giving its name as a string. eg: db.schema.table.

Inputs

Source table reference [String]

Output

Data table available in CARTO Workflows.

Import from URL

This component requires the CARTO Analytics Toolbox installed in the chosen connection to build the workflow.

Description

This component imports a table from a URL. Shapefiles, GeoPackage, CSV, KML, KMZ, TAB, GeoJSON, and (Geo)Parquet files with a maximum size 1Gb are supported.

Inputs

• Source URL [String]

• Only import if newer than existing table [Boolean]

• Automatically guess column data types in the imported table [Boolean]

Outputs

• Result table [Table]

Save as Table

Description

This component writes an input table to a non-temporary location.

If a table exists under that location, it will be overwritten.

Inputs

• Source table [Table]

• Name of table to create/overwrite [String]

• Column used for clustering [Column]

Outputs

• Result table [Table]

Send by Email

This component requires the CARTO Analytics Toolbox installed in the chosen connection to build the workflow.

Description

This components saves a table to a bucket and sends a notification with the saved table location.

It is limited to tables with a maximum size of 1GB. For larger tables, an exception will be thrown.

Inputs

• Source table [Table]

• Email address [String]

• Subject [String]

• Body [String]

• File format [Selection]

Outputs

• Email sent