# Subsetting data

{% hint style="info" %}
**Required license:** Professional or Enterprise

**Required workspace permission:** Configure subsetting
{% endhint %}

Subsetting generates a representative sample of your data in a way that maintains referential integrity.

You can also view this [video overview of subsetting](https://youtu.be/j0-958NyTFc).

## Subsetting overview and table filtering <a href="#overview-table-filtering" id="overview-table-filtering"></a>

<table data-view="cards"><thead><tr><th></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><strong>About subsetting</strong><br><br>Learn about subsetting, its components, and how subsetting generation works.</td><td><a href="/pages/yYuyOa7ryLhGCqLLb5IK">/pages/yYuyOa7ryLhGCqLLb5IK</a></td></tr><tr><td><strong>Use table filtering</strong><br><br>Instead of subsetting, some connectors allow you to add filters to tables.</td><td><a href="/pages/c1RXCHKRpCB5wPWyWzeR">/pages/c1RXCHKRpCB5wPWyWzeR</a></td></tr></tbody></table>

## Viewing and updating the subset configuration <a href="#view-update-subset-config" id="view-update-subset-config"></a>

<table data-view="cards"><thead><tr><th></th><th></th><th></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><strong>View the subset configuration</strong></td><td>Review the current subset configuration.</td><td></td><td><a href="/pages/jPhJfdhrj6PvkVQd9WY6">/pages/jPhJfdhrj6PvkVQd9WY6</a></td></tr><tr><td><strong>Foreign keys and circular dependencies</strong></td><td>Create virtual foreign keys. Manage circular dependencies in the data.</td><td></td><td><a href="/pages/adzeJrXmEHnNqGuzWe62">/pages/adzeJrXmEHnNqGuzWe62</a></td></tr><tr><td><strong>Configure subsetting</strong></td><td>Select and configure target and lookup tables.</td><td></td><td><a href="/pages/gxtJjDrjwH1PiM01B9Bd">/pages/gxtJjDrjwH1PiM01B9Bd</a></td></tr><tr><td><strong>Manage configuration inheritance</strong></td><td>Override or restore inheritance from a parent workspace to a child workspace.</td><td></td><td><a href="/pages/uNU2ITG4QI02CdpTPaL2">/pages/uNU2ITG4QI02CdpTPaL2</a></td></tr></tbody></table>

## Viewing subsetting steps and run results <a href="#view-subset-steps-results" id="view-subset-steps-results"></a>

<table data-view="cards"><thead><tr><th></th></tr></thead><tbody><tr><td><strong>View the subset creation steps</strong><br><br>Review the path that Structural takes to identify the subset records.</td></tr><tr><td><strong>View previous subset generation runs</strong><br><br>Get the results and the configuration for previous runs of subsetting generation.</td></tr></tbody></table>

## Other resources for subset configuration

<table data-view="cards"><thead><tr><th></th><th></th><th></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><strong>Generate subset data from related databases</strong></td><td>Ensure that generated subsets are cohesive.</td><td></td><td><a href="/pages/psbX2wAlctGKbqxKSnlp">/pages/psbX2wAlctGKbqxKSnlp</a></td></tr><tr><td><strong>Subsetting hints and tips</strong></td><td>Hints and tips for subset configuration.</td><td></td><td><a href="/pages/MLmP6TFAUcx5Z9SCjVLF">/pages/MLmP6TFAUcx5Z9SCjVLF</a></td></tr></tbody></table>


---

# 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.tonic.ai/app/generation/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.