Edit SQL Dataset

The newly created SQL Dataset is displayed under the Datasets screen.
To view or edit the SQL Dataset, click the name of the Dataset in the Datasets screen.
The SQL dataset with manipulated data is displayed.

1. Click the icon on the right-hand panel and the following options are displayed.
   1. SQL Editor: You can modify the Dataset in SQL Editor to make changes in the data that is retrieved as per the requirements in further steps of automation.
   2. Description: You can add description using this option.
   3. Reload Dataset: You can use this option to get the dataset back without any filters or sorting.
2. Click the icon against each column to sort or filter the data in the column.

SQL Editor Options

Click the SQL Editor icon and select the SQL Dataset from left-hand panel to modify the Dataset.

• Click the icon to filter the data.
• Click the Schema Edit icon to edit the schema.
• Click the SQL Query Editor icon to view the SQL Query Editor with the table listed in the lower panel and Query above it.
• Click the icon to publish the Dataset.

Publish the Dataset after modification, so that the modified dataset can be used in automation tasks.

Schema Edit

Schema Edit is used to modify the schema of the dataset as per the requirement before publishing.
The data in the SQL Dataset can be cleansed or transformed as needed to use in the automation process. The following transformations can be done to make the data more usable:

• Transform existing columns by making them Nullable, Hide, Duplicate, or Delete the column.
• Add derived columns to add new rules to the data.
• Transform the data in the existing columns using expressions.

1. Click the icon. A Schema popup window opens with all the columns of the selected dataset.
2. Click the icon to modify the schema. The data in the SQL Dataset can be transformed as needed to use in the automation process.
   To know more about how to transform SQL Dataset, click here.

SQL Query Editor

The right-hand panel of the page displays options to edit the schema , toggle to SQL Editor , and publish .