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. Configure the Task
  • 3. Select Parameters
  • 4. Save and Use
  1. TASKS
  2. ETL

Parameters to Table

PreviousRESTNextTable to Parameters

Last updated 9 days ago

The Param to Table task in Gaio DataOS allows you to generate a table containing the values of selected 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

parameters