Table to Parameters

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