Overview
The Dataset Tables section in the Dataset module simplifies data table management. Customize structure, relationships, and data types effortlessly through an intuitive interface that streamlines data handling and promotes efficient data management.
On this page:
Tables
To create and configure a Database Table follow these steps:
- Access Datasets → Tables.
- Click the plus icon.
Enter a Name and Description for the table, and click Ok.
The use of spaces is not allowed in the Name. Instead, use underscores. For example: My_Table
- In the list of Dataset Tables, double-click the property you wish to edit on the row corresponding to the table you want to modify.
Table configuration properties in the Dataset module allow users to tailor their database tables for optimal data management. The table below describes each property column.
Column | Description |
|---|---|
Name | Enter a name for the table configuration. |
DB | Select the database connection. |
Table Name | Select or type the table name in the Database you want to access. |
Where Condition | Specify the parameters that will filter the data using SQL syntax. For example: " |
Access | Select the access permissions for the table. |
Mapping | Click the button with three dots (...) to select the tags that you want to populate with data in the first row of the table with data from specific columns. |
Mapping Date Time | Select the time reference (UTC or Local). |
Description | Enter a description for the table configuration. |