Import/Export
Components that allow you to import or export data to/from CARTO and your connected cloud data warehouse.
Export to Bucket
Description
This components exports a table to a storage bucket. Unless a GCS Bucket Name is provided, the files will be exported to a bucket owned by CARTO. The read access to this bucket is public, but listing is forbidden. This means that a file can only be downloaded by having the link, which name is not guessable.
For Self-Hosted deployments, a bucket owned by the customer needs to be configured. Please refer to this documentation for more information.
Inputs
Source table [Table]
File format: Select between CSV and JSON formats for the exported file(s).
Export compressed: Choose between a compressed file (.gz) or uncomprsesed.
(Optional) GCS Bucket name: A custom bucket provided by the user can be used by entering its name. Optionally a folder (or folders) can be added to the bucket name separated by slashes (/). The name of the bucket should follow the GCS specification and the name of the folder(s), in addition to GCS requirements should not contain single quotes (') or backslashes (). The connection (the email which appears on the connections page) should at least have permission for creating and deleting objects. To download the urls in a browser they should grant permissions to the email of an account they can login with. This custom bucket won't work with CARTO Data Warehouse connections unless the bucket is public.
Using this component requires that the connection has BigQuery User permission in the billing project.
Outputs
Result table [Table]
A table containing links to the result of the export.
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
Result table [Table]
Import from URL
This component has been deprecated in favor of importing a file to your Workflow's canvas
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]
FQN of table to create/overwrite [String]
Append [true/false]:
Determines whether the result will be appended to the existing table.
Outputs
Result table [Table]
Output
Description
This component sets the node connected to it as output for API executions of the workflow.
Inputs
Source table [Table]
This component can only be used once on a workflow. The content of the node connected to it will be stored on a temporary table, specified in the API response when calling the execution of a workflow as: "workflowOutputTableName": "workflows-api-demo.workflows_temp.wfproc_f2f8df5df4ddf279_out_33afd785675f081d"
.
Find more information about how to define the output of a workflow here.
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
Last updated