Lookup Upsert
The Lookup Upsert activity inserts or updates a value in a lookup table.
Configuring the Lookup Upsert Activity
To configure the Lookup Upsert activity, fill in the required fields in the activity panel.
Configuration
| Field | Required | Description | Example |
|---|---|---|---|
| Name | Optional | Specify the name for this activity. | MyActivity |
| Description | Optional | Specify the description for this activity. | Reads a file from S3 |
| Lookup Table | Optional | Specify the lookup table for this activity. | Lookup Table |
Input
Map the required input fields to provide data for this activity.
Output
| Field | Required | Data Type | Description | Example |
|---|---|---|---|---|
| Status | Optional | String | ||
| Num Entries Upserted | Optional | Integer |