Last Updated: Sep 13, 2021
You can create an SQL Dataset in two ways; either through the graphical user interface or by writing the Query.
Click on any of the listed Datasets. A default query Select * from ‘dataset name’ displays all the records in the selected Dataset.
The data from the selected dataset is displayed in a tabular format.
select * from ‘InventoryTable’
In the above example, the records in InventoryTable table is displayed.
Click the icon to publish the dataset.
select * from ‘ProductInventory’ where Quantity < ‘600’
In the above example, the records in ProductInventory table with Quantity less than 600 is displayed.
Once the required data is achieved as per the requirements, click the icon to publish the Dataset. You can use the published dataset in further Task Automation.
This newly created SQL dataset with the manipulated data is published and listed in the Datasets listing page.