Actions

View Object

The View Object action allows you to view detailed information about a created object, including columns, indexes, sample data, and the SQL query used to create the object.

• Columns: Define the data stored in the object, such as name, type, and other field information.

  

• Indexes: Allow more efficient access to data in an object.

  

• Sample Data: A set of data used to demonstrate how data is stored in the object.

  

• SQL: The statement used to create the object.

  

Edit Data

Allows importing data from CSV and TXT files, adding new rows, and displaying an editable preview of the table. You can adjust the number of visible rows, apply filters, update the table, and edit or delete existing rows.

Import

The Import action enables you to import data from CSV or TXT files into a table, provided the files have the same structure as the destination table. Configure the following parameters:

• Handling Duplicate Records: Overwrite duplicate records or insert them at the end of the table.
• Date Format: Choose between month, day, and year.
• Date Delimiter: Use '-' or '/' as the delimiter.
• Year Format for Dates: Choose between a 4-digit or 2-digit year format.

Table Data Profile

Provides a preview of the first 5 rows of the table and allows exploring the profile of each column. For numeric columns, it shows:

• Chart of the 50 unique values.
• Data type of the column.
• Sum and average.
• Maximum and minimum values.
• Mean, variance, and standard deviation.

For string-type columns, it shows:

• The data type.
• A categorization tool section where values and categories are displayed.

See Token

Used to obtain the access token needed to authenticate and access the specified table through the API. The access token is a securely generated random string that allows API requests.

Design Table

Provides complete control over your table. You can add fields, edit or delete fields as needed. Options to delete the entire table, clear it (remove all data), and close the window for easy and convenient data management.

Duplicate

Create a copy of the selected table. Enter a name for the new table and choose the compression type (compressed or uncompressed). You can create an empty copy (structure only) or a complete copy (structure and data).

Create Snapshot

Create a copy of an existing table. There are two types of table snapshots:

• Compress Only: Faster to create and mainly used for queries.
• Compressed Snapshot for Backup: More comprehensive, used for backing up or archiving data.

Create Knowledge Node

Create a Knowledge Node using the selected Data Object as the primary table for the Node. If a Node already exists with this table as the primary key, an additional option will appear to open the existing Knowledge Node.

Add Trigger

Add a Trigger, an event executed when a specific action is triggered. Types of Triggers that can be created: