Gaio DataOS
English
English
  • Welcome to the Gaio Platform documentation!
  • Documentação
    • General information
      • Functioning Structure
      • Login
      • Home page
    • Applications
    • Studio
      • Suit
      • Data Sources
      • Tasks
        • ETL
          • Builder
          • SQL
          • SQL External
          • Insert Table
          • Insert Row
          • Update
          • Delete
          • Create Table
          • Quick Table
          • pivot table
          • Unpivot Table
          • Run Process
          • Rest
          • Parameters to Table
          • Table to Parameters
          • Users
          • CSV Web
          • Google Planilhas
        • Analytics
          • Sample
          • AutoML
          • Scoring
          • Cluster
          • Main Components
          • Association Rules
          • Time Series
          • Python
        • Delivery
          • Report
          • Power Search
          • Content
          • Form
          • Exportar Output
          • Banner
          • Export CSV
          • Map
          • Insights
          • API
          • SMS
          • Whatsapp
          • Email
          • Network
      • Parameters
      • Forms
      • Files
      • Action Buttons
      • Top Menu
        • SQL
        • Edit Bucket Tables
        • Executions in Progress
        • Map Editor
        • Schedule
        • Models
        • Cognitive
        • Error log
        • Edit Dashboard
        • Chat - GPS
        • General Menu
    • Administration
      • Permissions
      • Users
      • Data Sources
      • Repositories
        • Creation
        • Data Management
      • Sharing
      • Schedules
      • Logs
    • Keyboard Shortcuts
  • Integrações
    • LDAP
  • HUB
    • Exemplos
      • Tarefa Conteúdo
        • Manual Form
  • FAQ
  • Gestão de Servidor
    • Gaio startup
  • What's New!
    • Release Notes
      • 2022
  • Import
    • Editor de Mapas
    • Parâmetros
    • Formulários
    • Processos
    • Editar Dashboard
    • Administração
      • Usuários
        • Permissões
      • Fontes de Dados
      • Repositórios
        • Criação
        • Gestão de Dados
      • Compartilhamento
      • Agendamento
      • Log
    • Consulta
Powered by GitBook
On this page
  1. Documentação
  2. Studio
  3. Tasks
  4. ETL

Create Table

PreviousDeleteNextQuick Table

Last updated 1 year ago

This task does not depend on a table as a source for its execution. With the Create Table task you define the columns and their types to create a new table without data. It can be very useful to create a table that will start receiving data, for example from the .

It is necessary for each new column to define its name, type (text, date, date/time, numeric, etc.) and default value if the user does not provide it.

You can create as many fields as you need. Using item 1 , you will create the table, but the table creation task will not be generated and therefore will not exist to be reused or changed.

At the same time, keeping this task in one process means recreating the table again with each run, which would mean losing data. However, if this is the intention, it is essential to check the box in item 2 , so that Gaio deletes the table before recreating it.

Finally, in item 3 , you create and save the task in your process.

Insert Row task