Insert Row

The Insert Row task in Gaio DataOS allows you to manually insert a new row into an existing table. It is especially useful for adding static records, parameterized values, or dynamic data generated through formulas or computed fields.

---

How to Use

1. Open the Task

• In the Studio, go to the left menu and navigate to: Tasks > ETL > Insert Row

---

2. Fill Out Basic Information

• Task label: (optional) Provide a name for this task within your flow.

• Table: Select the target table where the new row will be inserted.

---

3. Select Columns

• In the Columns field, choose which columns you want to populate.

• After selecting, a list of input fields will be displayed below for each column.

---

4. Define Type and Value for Each Column

For each selected column, configure the following:

Type: Choose the input type:

• Value: insert a fixed/static value (e.g., "Product A", 123)

• Parameter: use a previously defined project parameter

• Computed: define a formula or function (e.g., now(), today(), 1+1) |

Value: Enter the corresponding value based on the type selected.

Examples:

• col_1: Type = Value, Value = "New Client"

• col_2: Type = Parameter, Value = @client_id

• date_one: Type = Computed, Value = today()

---

5. Execute or Save

• Run: Runs the task without saving it to the flow.

• Save: Saves the task for use in the current flow without executing it.

• Save and Run: Saves and immediately runs the task.

---

Use Cases

• Manually insert a single row into a table

• Log events or markers during execution

• Populate test values during flow development

• Use computed fields for timestamps, UUIDs, or calculated values