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:
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
Last updated