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
  • Data Flows in Gaio DataOS
  • What Can a Data Flow Contain?
  • Automation Capabilities
  1. FUNDAMENTALS

Workflow

PreviousDatabaseNextData Sources

Last updated 17 days ago

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.