# Configure subsetting

{% hint style="info" %}
**Coming Soon**

Syntho's improved subsetting feature will be re-introduced in the platform soon.
{% endhint %}

On the **Job configuration** panel, click on **Switch to Subsetting ->** to go to the **Subsetting** panel.

## View subsetting configuration

On the **Subsetting** panel, you can view the subsetting configuration in the table overview.

* The **Table name** column shows all tables that are part of the source database.
* The **Include** column indicates whether the table will be included in the subset.
* The **Row count** column indicates, by estimate, how many rows will be generated for the subset.

You can quickly filter tables by selecting the dropdown icons next to the column headers.

By default, all tables are marked as **Exclude,** indicating they are excluded from the subsetting configuration.

You can adjust the table mode by selecting a row in the table overview.

## Configure target table

Select **Subsetting mode** > **Target** to configure the table as **Target** table.

You can specify a **percentage** of the target table to include. This percentage is converted into a filter or **WHERE** clause depending on the database type.

It is possible that the target table in the subset contains more rows than the specified percentage in order to maintain referential integrity.

{% hint style="info" %}
**Note:** To preserve referential integrity, at most one target table can be set in. When updating the targe table, all linked tables will be updated accordingly.
{% endhint %}

## Configure linked tables

Once a target table has been selected, all linked tables will automatically be marked as **Linked** in the subsetting configuration.

Select **Subsetting mode** > **Target | Duplicate | Exclude** to change the **Subsetting** mode for any linked table.

Select **Subsetting mode** > **Linked** to reconfigure a table as **Linked** table. Note that this is only possible if a target table has been defined that is directly or indirectly related to the table.

## Configure duplicated tables

Select **Subsetting mode** > **Duplicate** to copy, i.e. duplicate, the full table to the subset.

## Configure excluded tables

By default, tables that are not defined as target tables, linked tables, or duplicated tables, will be automatically set to **Exclude**.

You cannot manually exclude a table from the subsetting configuration. If you want to exclude a table from a data generation job, you can do this using the appropriate [table mode](/configure-a-data-generation-job/configure-column-settings/exclude.md).

## Launch subsetting job

When you select **Generate** from the **Job configuration** panel, Syntho performs several validation steps against the schema of the source database and the destination database.

At last, select **Start generating** to launch your subsetting job.


---

# 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.syntho.ai/subsetting/configure-subsetting.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.