Last Updated: Sep 13, 2021
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.
Click the SQL Editor icon and select the SQL Dataset from left-hand panel to modify the Dataset.
Publish the Dataset after modification, so that the modified dataset can be used in automation tasks.
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:
The right-hand panel of the page displays options to edit the schema , toggle to SQL Editor , and publish .