# 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.

{% hint style="warning" %}
To use this module, [Data Management](/english/skyone-studio/data-management.md) must be enabled and a [Data Engine](/english/skyone-studio/data-management/engine.md) must be configured in advance. 
{% endhint %}

### 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.

<figure><img src="/files/uIdoRUmOUX1wITbIIpVe" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/ZzwpOwzNDmV9HLo3bLQC" alt=""><figcaption></figcaption></figure>

To finish, click "**Save**".

#### Edit module&#x20;

To edit it, simply click "[**Edit**](/english/skyone-studio/integrations/flows/editing-triggers-and-modules.md#edit-component)" 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.

{% hint style="warning" %}
If disabled, execution will only trigger the processing and then move on.
{% endhint %}

* **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.

<figure><img src="/files/LQEc42ipj5qdlyLVi1OA" alt=""><figcaption></figcaption></figure>

{% hint style="warning" %}
If **"Return data"** is enabled, this option cannot be used.
{% endhint %}

### Pagination Settings

In this block, you can configure pagination to optimize the execution of SQL queries, ensuring greater control, security, and flexibility for each use case.

To manage the volume of returned records, fill in the **Limit** and **Offset** parameters, where:

* **Limit:** Defines the maximum number of records to be returned in a single execution.
* **Offset:** Defines the starting point for data retrieval.

<figure><img src="/files/3mEHFfisTWfbuRW7YoDa" alt=""><figcaption></figcaption></figure>

#### **Practical example**

To understand how these parameters affect your data return, consider the following scenario:

**Configuration:**

* Limit: 5
* Offset: 10

**Result:** The system will skip the first 10 records and return only the next 5 items. In practice, you will receive the results located between the 11th and 15th positions in your database.

***

**Sync parameters:** updates the component [parameters](/english/skyone-studio/data-management/parameters.md) with the current [Data Job](/english/skyone-studio/data-warehouse/data-jobs.md) definitions to ensure execution integrity.

<figure><img src="/files/GUCdprJ36kWfewAdzSIt" alt=""><figcaption></figcaption></figure>

***

To finish, click "**Next**." You will be redirected to the execution test screen

If everything looks good, simply click **"Save"**.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.skyone.cloud/english/skyone-studio/integrations/flows/tool-modules/data-sql-execute-module.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.