> For the complete documentation index, see [llms.txt](https://docs.tonic.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tonic.ai/app/generation/subsetting.md).

# 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
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.tonic.ai/app/generation/subsetting.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.