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
  • Main Sections of the Studio
  • Flow
  • Source
  • Parameters
  • Form
  • Files
  • Maps
  • API
  • Discovery
  1. FUNDAMENTALS

Studio

PreviousData ProjectsNextDatabase

Last updated 15 days ago

The Studio is the core environment inside a Data Project where users can build, orchestrate, and automate data workflows. It provides a visual interface and powerful tools for data development, automation, analytics, and API integration.

Main Sections of the Studio

Below are the primary menus available in the Studio, each with a specific purpose:

Flow

  • The Flow tab is where you create and manage data processes.

  • Users can visually construct workflows that include SQL queries, Python scripts, dashboards, and more.

  • Each process represents a step or logic within the data pipeline.

Source

  • Provides access to data generated inside the project and to external data sources.

  • Only data sources previously configured by an admin user in the system settings will be available here.

  • Developers can explore and query datasets available in their permission scope.

Parameters

  • Acts as a central hub for variables used within processes.

  • Parameters can be:

    • Applied in filters

    • Set as environment variables

    • Used to pass values between SQL queries and Python/JavaScript code blocks.

Form

  • Used to create input forms for dashboards or data entry.

  • Forms can be linked to trigger data flows, making them powerful tools for user interaction and workflow automation.

  • Ideal for building dynamic and interactive reports.

Files

  • A space for uploading files such as:

    • CSV

    • Excel spreadsheets

    • PDFs

    • Images

    • Videos

  • Uploaded files can be processed and integrated into your flows.

Maps

  • Allows users to build custom geo maps using GeoJSON files.

  • Useful for geospatial visualizations and regional data insights.

API

  • Enables users to build and publish APIs based on project-generated data.

  • APIs can also be configured to trigger data processes, allowing real-time interaction with external systems.

Discovery

  • A smart assistant for data exploration.

  • Easily connect to a table and use:

    • Power Search (natural language search over data)

    • AI Dashboard (auto-generated visuals)

    • Insights (automated analysis and suggestions)