Data SQL Execute Module

Definition

The "Data SQL Execute" tool module allows you to run "Data Jobs" within a flow, enabling the customization and dynamic configuration of the data being processed. It also includes features like "Return Data" to provide an overview of the information in a file.

To use this module, Data Management must be enabled and a Data Engine must be configured in advance.

Add the "Data SQL Execute” Module

The "Data SQL Execute" module appears under the Tools section when editing a flow. After clicking to add it, the initial configuration modal will be displayed.

Fill in or select the following items to run a Data Job in your flow:

• Select the Data Engine

• Choose the Data Job and its corresponding Database

To finish, click "Save".

Edit module

To edit it, simply click "Edit" on the module.

You can use the following features:

• Wait for data processing: When enabled, execution will wait for the processing to finish before continuing the flow.

If disabled, execution will only trigger the processing and then move on.

• Return data: Linked to the “Wait for processing” option, this returns a sample of the data. This sample can be used as a parameter within the flow.

• Mock test output: Simulates the component's return without needing to execute it in order to save.

If "Return data" is enabled, this option cannot be used.

Click "Next". You will be redirected to the test execution screen.

If everything looks good, simply click "Save".