Manage Dataset

After saving the dataset, users are redirected to the Dataset Management page. Users can also access this page at any time by clicking the Manage Dataset icon corresponding to an existing dataset.

Alter Data

The Alter Data option allows users to modify or update the structure and content of an existing dataset after it has been created. This helps users keep datasets current and aligned with changing business requirements without creating a new dataset from scratch.

Steps to Alter Data:

Step 1: Click Alter Data, select the required file, and then click Next to continue.Here, it provides a visual guide to dragging and dropping columns for column mapping.Step 2: Now select the required table. The data will be updated according to the selected Data Load Strategy. In this example, the Truncate and Load strategy is used, which replaces the existing data in the table with the newly loaded data.Alerts

The Alerts panel provides a quick validation summary during Table & Column Mapping. It helps users identify potential issues that may prevent successful dataset loading or cause data inconsistencies.
In this example, all alert counts are 0, which means no issues were detected.

Alert Types

• Missing Columns:
  Indicates columns expected in the target table but not found in the uploaded source file.
• Mismatched Data Type:
  Shows columns where the source data type does not match the target column data type.

  Examples:

  • Text mapped to numeric field
  • Date mapped to string field
  • Missing Column Mapping

Indicates source columns that have not been mapped to a target column.

Data Preview

Once the data is loaded successfully, the dataset preview will appear under the Data Preview tab.

Data Load History

Under the Data load history tab, users can track when data was loaded, which load strategy was used, and the loading status.

Scheduler

The Scheduler tab shows the set schedulers, which allow users to automate dataset refreshes and data loading operations at predefined intervals.

Add Table

The Add Table option allows users to add a new table to an existing dataset. This is useful when additional data needs to be included in the dataset without creating a new one.

Delete

When users click the Delete icon, the dataset and any associated schemas are deleted.