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
  • How to Use
  • 1. Open the Task
  • 2. Set Basic Information
  • 3. Advanced Options
  • 4. Map Columns to Parameters
  • 5. Save and Use
  1. TASKS
  2. ETL

Table to Parameters

PreviousParameters to TableNextDefine parameter value

Last updated 9 days ago

The Table to Param task in Gaio DataOS allows you to convert values from one or more table columns into reusable parameters within your flow. This feature is ideal for dynamically extracting data and using it as input in other tasks, filters, or dashboards.

This task can only be used when a table is selected in the flow.️

How to Use

1. Open the Task

In the left-side menu, go to: Tasks > ETL > Table to Param

2. Set Basic Information

  • Task label: (optional) Name for identifying this step in your flow.

  • Table: Automatically populated with the selected table (e.g., new_sales).

3. Advanced Options

Save values as default

When enabled, this will store the extracted parameter values as default values, available outside the current flow if needed.

Custom reference from column to param

When enabled, allows you to manually map each column of the table to a specific parameter.

4. Map Columns to Parameters

  • For each column listed, choose a parameter to assign its value to.

  • You can select from existing parameters.

  • Only one row is read — usually the first row of the selected table.

Example Mapping:

Table Column
Mapped Parameter

order_id

@order_id

region

@user_region

total_sale

@total_sales

5. Save and Use

  • Click Save to include the task in your data flow.

  • The captured values will now be available as environment parameters and can be used in:

    • SQL queries

    • Filters

    • Dashboards

    • Python or JavaScript blocks

Use Cases

  • Capture input values to personalize reporting

  • Feed parameters based on outputs of tables

  • Drive conditional logic based on dynamic table values

  • Create reactive dashboards powered by runtime variables