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
      • 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
      • Content
      • Form Card
      • Export CSV
    • Map Editor
Powered by GitBook
On this page
  • How to Use the Builder
  • 1. Insert and Select a Table Block
  • 2. Open the Builder Task
  • 3. Configure Basic Info
  • 4. Build Your Query Visually
  • 5. Use Query Features
  • 6. View the Output and Logic
  • 7. Run or Save the Query
  1. TASKS
  2. ETL

Builder

PreviousETLNextSQL

Last updated 4 days ago

The Builder is Gaio DataOS’s visual query builder. It allows both technical and non-technical users to construct structured queries in a simple and intuitive way — without writing SQL code (though the generated SQL can be viewed and edited at any time).

How to Use the Builder

1. Insert and Select a Table Block

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

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

2. Open the Builder Task

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

  • On the left panel, all available fields will be listed below, with icons indicating data types (text, number, date, etc.).

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. Build Your Query Visually

Inside the Builder tab, you can construct your query using the following blocks:

Columns: Choose the fields you want to display in the results and apply aggregate functions like SUM, COUNT, AVG, etc.

Filter: Apply conditions to narrow down the dataset (e.g., region = 'South', units_sold > 5).

Join: Link other tables using relationships (JOINs).

Group: Group the data by one or more columns.

Filter After Grouping: Filter the grouped results (e.g., show only products with total sales above 100 units).

Order: Sort the result set based on selected fields.

Rows & Page (Offset):

  • Limit: Max number of rows to return.

  • Offset: Number of rows to skip (useful for pagination).

5. Use Query Features

In addition to the Table tab, you’ll find two options at the top left:

Computed: Create calculated fields using custom expressions. Example: units_sold * unit_price to generate a total sales field.

Aggregated: Manage and view all aggregated fields.

6. View the Output and Logic

At the top of the screen, you’ll find two useful tabs:

SQL: Displays the SQL code automatically generated based on your configuration. You can review, copy, or even edit it as needed.

Preview: Shows a real-time preview of the query results, helping you validate the logic before saving.

7. Run or Save the Query

  • Click Save to store your query configuration.

  • Click Save and run to immediately execute the query and preview the results.

Best Practices

  • Use Computed fields to create metrics directly in your query.

  • Always review the SQL tab to understand what’s being executed.

  • Use Preview to validate the output before saving or publishing.

  • Name your queries clearly to keep your project organized.