Delete
The Delete task in Gaio DataOS allows you to remove records from a table based on custom filter conditions. It is useful for cleaning outdated, inconsistent, or temporary data as part of automated ETL flows.
Important: 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 deletion.
How to Use
1. Add and Select a Table Block
In your flow, add a Table with the dataset you want to work with.
Select the table as input for the Delete task.
2. Open the Delete Task
In the left-side menu, go to: Tasks > ETL > Delete
3. Fill Out Task Information
Task label: (optional) A descriptive name for the step.
Table: Will be automatically filled based on the selected table (e.g.,
new_sales).
4. Set Filter Conditions
In the Filters section, define one or more conditions to specify which rows should be deleted.
For each filter, configure:
Column
Choose the column to filter by (e.g., order_id)
Type
Input type: Value, Parameter, etc.
Operator
Comparison operator (Equal to, Not equal to, Greater than, etc.)
Value
The value to compare against
Example:
Delete rows from the new_sales table where order_id is equal to 1001.
5. Execute or Save
Run: Immediately performs the deletion (without saving the task).
Save: Saves the task to the current flow.
Save and Run: Saves and immediately executes the deletion.
Use Cases
Remove invalid or duplicate records
Delete temporary test data
Automate cleanup logic based on business rules
Ensure data consistency before or after processing
Last updated