> 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/fundamentals/workflow.md).

# Workflow

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

### Data Flows in Gaio DataOS

**Data Flows** are the foundation of how data is transformed, automated, and operationalized within Gaio DataOS. They represent visual pipelines that combine multiple steps into a seamless, executable logic — from raw data ingestion to business-ready insights.

***

### What Can a Data Flow Contain?

Each flow can include a wide range of components that address real-world business problems and enable scalable data solutions:

* **SQL Queries**:\
  Run advanced queries to transform, join, and aggregate data directly from the ClickHouse engine.
* **Auto Machine Learning**:\
  Incorporate no-code or low-code machine learning models to predict trends, classify events, and detect anomalies.
* **API Connections**:\
  Integrate external data sources or trigger APIs to automate system actions or expose your data as a service.
* **Dashboards and Reports**:\
  Generate visual reports such as charts, KPIs, heatmaps, and tables — all linked directly to your data logic.
* **Content Elements**:\
  Add banners, cards, or textual explanations to enhance the storytelling in your dashboards.

***

### Automation Capabilities

Flows in Gaio can be fully automated using scheduled triggers or external events:

* **Scheduled Execution**: Set recurring intervals (hourly, daily, weekly, etc.)
* **Manual Execution**: Trigger flows on demand for ad-hoc analysis or debugging
* **Triggered by API/Form**: Launch flows when users interact with dashboards or when APIs are called

***

#### Benefits

| Feature                    | Description                                                                                        |
| -------------------------- | -------------------------------------------------------------------------------------------------- |
| **Visual Design**          | Drag-and-drop blocks to build your logic without writing code (but code is supported when needed). |
| **Modular Structure**      | Each block (SQL, report, model, etc.) can be reused in different flows or projects.                |
| **Live Monitoring**        | Track execution status in real time with built-in logging and performance metrics.                 |
| **End-to-End Integration** | Combine data prep, ML, and visualization in one single flow — no switching between tools.          |