# 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="subsetting/subsetting-about">subsetting-about</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="subsetting/table-filtering">table-filtering</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="subsetting/subsetting-view-config">subsetting-view-config</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="subsetting/subsetting-foreign-keys">subsetting-foreign-keys</a></td></tr><tr><td><strong>Configure subsetting</strong></td><td>Select and configure target and lookup tables.</td><td></td><td><a href="subsetting/subsetting-configure">subsetting-configure</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="subsetting/subsetting-configuration-inheritance">subsetting-configuration-inheritance</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="subsetting/subsetting-cross-database-subsets">subsetting-cross-database-subsets</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="subsetting/subsetting-hints-tips">subsetting-hints-tips</a></td></tr></tbody></table>
