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. Paste or Type Data
  • 2. Click “Prepare data”
  • 3. Adjust Column Types (Optional)
  • 4. Set Table Options
  • 5. Execute
  1. TASKS
  2. ETL

Quick Table

PreviousCreate TableNextQuick Upload

Last updated 10 days ago

The Quick Table task in Gaio DataOS allows you to quickly create a table from small, manual data inputs — perfect for testing, prototyping, or entering reference values without uploading a full file.

How to Use

Follow these steps to create a table from pasted data:

1. Paste or Type Data

  • Use the input field at the top to enter your data in CSV format.

  • The first line should contain the column headers.

  • The second line onward should include the corresponding data rows.

Example:

col_1,col_2,col_3  
value,date,2

2. Click “Prepare data”

  • This will parse your input and generate a data preview.

  • Columns will be detected and their types automatically inferred.

3. Adjust Column Types (Optional)

  • Click on a column header to manually change its data type:

    • String, Int, Float, Date, DateTime, etc.

  • You can also delete columns using the trash icon.

4. Set Table Options

  • Result table: Enter the name of the table you want to create.

  • Options:

    • Active to drop table then create: If the table already exists, it will be dropped and recreated (use with caution).

    • Create reference on current process: Links the new table to the current data flow for further use.

5. Execute

  • Click Execute to finalize the creation of the table and load the data.

Use Cases

  • Create test datasets for development

  • Add small reference tables manually

  • Prototype transformations and visualizations

  • Manually define mappings or constants