> For the complete documentation index, see [llms.txt](https://docs.gaiodataos.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.gaiodataos.com/tools/tasks/etl/builder.md).

# Builder

<figure><img src="/files/tlFODQQW4hZTjEHlwCAQ" alt=""><figcaption></figcaption></figure>

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).

***

## &#x20;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):**&#x20;

* **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.

{% hint style="warning" %}
To use parameters in calculated fields, the user must enter **‘{{parameter\_name}}’** in their function or as a value.
{% endhint %}

**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.