Links

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