Adding a Dataset
A flow is created by adding a dataset to the canvas. In order to do that, drag the “Add Dataset” icon and drop it in the canvas. Select the Dataset icon on the canvas to display the Details pane below the canvas. Follow these steps to configure the dataset.
1. Select the Dataset icon on the canvas. The details pane is displayed.
2. Click on “Select a dataset” button. The “Add a dataset” window is displayed.
3. Choose a datasource to be associated with the dataset by clicking on the “Choose a Dataset” button. A list of data sources is displayed in the “Add a Dataset” window. The list includes existing Flows created using the Web UI along with other published resources.
4. Choose the data source and click Ok.
- All the available columns in the data set are displayed in the Columns tab of the Data Configuration pane.
- A preview of the dataset is displayed in the Preview Pane. The columns can be sorted by clicking on the column header.
- A view-only SQL query is displayed in the Query pane.
Features and Limitations of the Dataset Operation
• There are no inputs to the Dataset node/operation.
• The Dataset node can have only one output.
• By default, the name of the table/datasource is the name of the dataset node. However, this can be edited by clicking on the name. The path of the datasource is also displayed on the node.
• There is no limit to the number of datasets defined in a flow. But there must be at least one dataset node defined.
• To delete a dataset node, hover the mouse on the node and click on the delete icon that is displayed on the top right corner of the node.