Description
The Upload To Datasource activity allows you to import structured data from a file or data from previous activity into a designated table within a connected data source such as a database, data warehouse, or cloud storage system.
This activity supports uploading tabular data and optional file attachments into the target system. It ensures the uploaded content is mapped correctly by specifying the destination table and attachment column (if applicable).
Use case:
Upload exported Excel or CSV files into a central data warehouse after data cleaning and validation steps. Attachments such as PDFs or images linked to records can also be inserted if required.
| Input Type | Format | Description |
|---|
| Data/File | Tabular or Binary | Structured data to be uploaded to the datasource. |
Output
| Output Type | Format | Description |
|---|
| Status | Text / Table | Confirmation of rows uploaded or updated in the target datasource. |
Configuration Fields
| Field Name | Description | Required |
|---|
| Datasource ID | ID of the target datasource connection (e.g., MySQL, Azure, Snowflake). | Yes |
| Table | Name of the destination table within the selected datasource where the data will be uploaded. | Yes |
| Use Data Attachments | Enables uploading file-type data associated with records (e.g., document attachments). | No |
| Attachment Column | The column in the table where data attachments (if any) should be stored. Required if attachments are enabled. | Optional |
Not Applicable
Sample Configuration
| Field | Value |
|---|
| Datasource ID | sales-db-prod |
| Table | CustomerRecords |
| Use Data Attachments | true |
| Attachment Column | DocumentLink |
Sample Output
| Table | Status | Rows Uploaded |
|---|
| CustomerRecords | Success | 125 |
