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. Add the Task to Your Flow
  • 2. Configure the Task
  • 3. Save and Run
  1. TASKS
  2. Delivery

Export CSV

PreviousForm CardNextMap Editor

Last updated 2 days ago

The Export file task allows you to export a table from your data flow into a CSV file, which will be made available for download directly within the Gaio DataOS interface. It’s a practical way to share results or integrate with external systems.

How to Use

1. Add the Task to Your Flow

  • Go to the "Delivery" section in the left menu.

  • Drag the Export file task into your data flow.

  • Connect it to the table you wish to export.

2. Configure the Task

  • Task label: A name for the task (e.g., export_april_sales). For internal reference only.

  • Separator: Choose the character that will be used to separate columns in the CSV file. Gaio supports the following options:

    • Comma ( , ): Default for international use.

    • Semicolon ( ; ): Recommended for European or Brazilian formats.

    • Tab: Generates TSV (tab-separated values) files.

    • Pipe ( | ): Useful when your data contains a lot of commas or semicolons.

    • fieldsTerminatedByTILD: Uses the tilde ~ symbol as the field separator, useful for custom data integrations.

  • Compress file (ZIP) (optional): Enable this option if you want the resulting CSV file to be compressed as a .zip.

3. Save and Run

  • Click Save to store the task.

  • Click Run to execute the task in your flow.

  • When the flow runs, the file will be generated based on the settings.

  • The download will be available with the same name as the exported table.

💡 Tips

  • The resulting file will include all columns and rows from the linked table.

  • Use Pipe or TILD separators when your data includes a lot of punctuation.

  • You can include this task in automated flows or trigger it manually as needed.