Redshift - Update actions
This action updates one or more rows with a single set of values. It uses a
WHERE condition to select the row(s) to perform the update.
Update row(s) action
First, select a table to update. This can be done either by selecting a table from the pick list, or toggling the input field to text mode and typing the full table name.
Next, provide a
WHERE condition to select rows to be updated. This condition can be as simple as filtering a single record to update based on
id = 123
Alternatively, it can be used to select and update multiple rows.
status = 'closed'
Take note that all rows matching this criteria will be updated with the same values provided in Columns input.
WHERE conditions with subqueries can also be used. Refer to the WHERE condition guide for more information.
Lastly, map the datapills from your previous triggers or actions into their respective columns. The columns in the selected table are presented as input fields here for you to insert datapills.