Insert Row
Last updated
Last updated
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.
In the Studio, go to the left menu and navigate to: Tasks > ETL > Insert Row
Task label: (optional) Provide a name for this task within your flow.
Table: Select the target table where the new row will be inserted.
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.
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()
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.
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
