Parameters to Table

The Param to Table task in Gaio DataOS allows you to generate a table containing the values of selected parameters available in the current environment. This is useful when you want to use parameter values inside flows, merge them with data sources, or display them dynamically in reports.

This task can only be used when one or more parameters are already defined in the environment (either global, user, or contextual parameters).

---

How to Use

1. Open the Task

Go to the menu: Tasks > ETL > Param to table

---

2. Configure the Task

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

• Result table: Enter the name of the new table that will store the selected parameters (e.g., param_table).

---

3. Select Parameters

• Under the params section, all available parameters will be listed.

• Use the checkbox to select the ones you want to include in the resulting table.

• You can filter the list if many parameters are available.

Example: Select userId, region, and product to create a table with those values as columns.

---

4. Save and Use

• Click Save to register the task in your flow.

• The resulting table will contain a single row, with each selected parameter as a column and the current value of that parameter as the cell content.

---

✅ Use Cases

• Join parameter values with external or internal tables

• Use parameter values as inputs to other ETL steps

• Display user-specific or dynamic filters in dashboards

• Log or export execution context for audits or tracking

---