Workflow
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
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.
Last updated