Update

The Update task in Gaio DataOS allows you to modify existing records in a table based on custom filter conditions. This is ideal for correcting data, applying transformation rules, or dynamically synchronizing values during ETL flows.

ImImportant: This task can only be used when a table is selected in the flow. Be sure to add and connect a Table before configuring the update.

---

How to Use

1. Insert and Select a Table Block

• Add a Table to your flow and choose the dataset you want to work with.

• The Update task will only become available once a table is selected.

---

2. Open the Update Task

• In the left-hand menu, go to: Tasks > ETL > Update

---

3. Configure Basic Info

• Task label: (optional) Add a name for the task to identify it in your flow.

• Table: The table should be automatically linked from your selected block (e.g., new_sales).

---

4. Select Columns to Update

• In the Columns section, choose the fields you want to update.

• For each selected column, define:

Type: Defines how the new value will be set:

• Value: Static input

• Parameter: Uses a predefined variable

• Computed: Accepts formulas (e.g., now(), 1 + 1) |

Value: Enter the new value or expression

---

5. Set Filter Conditions

• In the Filters section, specify which records should be updated.

• For each filter:

Field	Description
Column	Select the column to filter by
Type	Input type (e.g., Value, Parameter)
Operator	Comparison logic (e.g., Equal to, Greater than)
Value	The value to match

Example: Update the order_date only where order_id = 1001.

Important: If there are no filters, all rows in the table will be updated.

---

6. Execute or Save

• Run: Immediately executes the update (one-time).

• Save: Saves the configuration to your data flow.

• Save and Run: Saves and executes the update at once.

---

Use Cases

• Correct outdated or incorrect values

• Apply standardization rules (e.g., replace empty values)

• Use dynamic inputs via parameters

• Update timestamps or statuses during automated flows