Gaio DataOS
Gaio DataOS
Gaio DataOS
  • 👋 Welcome to Gaio DataOS
  • GETTING STARTED
    • Gaio DataOS Console
    • Quickstart
  • FUNDAMENTALS
    • Data Projects
    • Studio
    • Database
    • Workflow
  • Data Sources
  • TASKS
    • ETL
      • Builder
      • SQL
      • Source SQL
      • Insert Table
      • Insert Row
      • Update
      • Delete
      • Create Table
      • Quick Table
      • Quick Upload
      • Pivot Table
      • Unpivot Table
      • Run Process
      • REST
      • Parameters to Table
      • Table to Parameters
      • Define parameter value
      • Users
      • CSV Web
      • CSV Local
      • Google Spreadsheet
    • Analytics
      • Sample
      • Cluster
      • Principal Components
      • Association Rules
      • Forecast
      • Python
    • Delivery
      • Report
      • Content
      • Form Card
      • Export CSV
      • Map
    • Map Editor
Powered by GitBook
On this page
  • How to Use
  • 1. Add and Select a Table Block
  • 2. Open the Delete Task
  • 3. Fill Out Task Information
  • 4. Set Filter Conditions
  • 5. Execute or Save
  1. TASKS
  2. ETL

Delete

PreviousUpdateNextCreate Table

Last updated 16 days ago

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:

Field
Description

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