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. Define the Result Table Name
  • 3. Select the Desired Columns
  • 4. Save and Use
  1. TASKS
  2. ETL

Users

PreviousDefine parameter valueNextCSV Web

Last updated 9 days ago

The User task in Gaio DataOS allows you to generate a table containing information about all registered users on the platform. This feature is particularly useful for access control, user management, governance reporting, and auditing flows based on user roles and permissions.


How to Use

1. Open the Task

Navigate to: Tasks > ETL > User


2. Define the Result Table Name

  • Result table: Enter the name of the table that will store the user data (e.g., users_table, platform_users, etc.).


3. Select the Desired Columns

You can choose which user attributes to include in the output table:

Column
Description

Name

Full name of the user

Email

Associated email address

Created at

Date the user account was created

Group

Group or permission set the user belongs to

Role

User access level (e.g., Admin, Editor, Viewer)

Select only the fields you need for your process or report.


4. Save and Use

  • Click Save to add the task to your flow.

  • Upon execution, the system will generate a table with one row per user, using the selected columns.

This table can be used for joins, permission validation, governance dashboards, or user-based filtering in flows and reports.


Use Cases

  • Build governance dashboards to list all platform users

  • Track user access levels, roles, and group associations

  • Audit who has access to which environments or data

  • Cross-reference users with logs or activity history