Data Sources

1. Accessing Data Sources

Click on the Fonts icon located in the Studio menu.

There are three main types of data sources:

1. Current application bucket: represented by the red bucket
2. Buckets for other applications: represented by a black bucket
3. External data sources: these can be MySQL, MemSQL, MariaDB, SQL Server, PostgreSQL and Oracle databases.

To access external sources, an Administrator user must connect to the database and grant permission to the developer user or a group of users.

To access tables from other Gaio applications, an Administrator user must also share them.

2. Importing tables from CSV/TSV and Spreadsheets

TSV/CSV files and Spreadsheets can also be used as data sources after importing the file in the Files menu.

1. Access the Files > Inputs menu and select the desired file.

2. Click and drag the file to the Canvas area. The CSV preview task will open automatically.

3. If necessary, format the columns.

4. Select the Import Type.

5. Give a name to the table that will be generated in Gaio.

6. Save , or save and run the task .

3. Connecting to Databases

After carrying out the necessary procedures mentioned in the first topic of this article, click on an external data source. They are differentiated through the icon corresponding to the database they belong to. In the example below we will connect to a MySQL database.

Click on the desired table and drag it to Canvas. The icon referring to the database used, with the name of the chosen table will be available for use.

Then, click on the task with the right or left mouse button, and select one of the options to access the Query task.

In the query task, select the columns to import, name the table, save, or save and run the task . At this point the data will be brought to a Gaio table.

1. Add all columns at once.

2. Select the desired columns.

3. Name the table.

4. Save only.

5. Save and run the task, generating the desired table.

Once the execution is complete, the Query task icon and the process status will turn green.

4. Using Tables

After bringing query data from a database to the Gaio table, its use is not limited to the process that created it. Simply click and drag tables from the current bucket (application) , from shared buckets (other Gaio applications) or from an external source to any new process in order to bring data from a new query.

Exemplo

5. Exploring Tables

You can easily explore the tables in Gaio. Just double-click on any table, even a Database table.

Let's navigate through all the options present in this environment, starting with the options menu.

5.1 Top Menu

1. Home: returns to Gaio's home.

2. Back: Returns to the application Studio.

3. Current application information

4. Updates table data.

5. View of the entire table.

6. View column metadata.

7. View statistics for numeric columns in the table.

8. Frequencies.

On the Frequencies screen, when clicking on the columns, Gaio displays:

• Lines (number of lines): Number of times that value (text, number or date) is repeated;

• Lines (%): Percentage count of the value in relation to the whole;

• Accumulated (%): Accumulated sum of percentages;

• Selected column.

Still on the same screen, notice that the selected column values can be clicked, and when clicking, a filter is applied to the visualization.

If you then select another column, the data presented will correspond to the result applied to the filter condition.

See the video below for an example of this navigation.

9. Shortcut to query task.

5.2 Other navigation options

1. Filters applied to the visualization.

Apply filters to the table by selecting the column, criteria and value to be filtered.

2. Number of rows in the table.

3. Number of lines viewed per page.

4. Filter the view by column type or name.

5. Statistics about the column

Frequency for text fields.

Other statistics and histogram for numeric fields.