Subsetting data

Required license: Professional or Enterprise

Required workspace permission: Configure subsetting

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

You can also view this video overview of subsetting.

Subsetting overview and table filtering

About subsetting Learn about subsetting, its components, and how subsetting generation works.

Use table filtering Instead of subsetting, some connectors allow you to add filters to tables.

Viewing and updating the subset configuration

View the subset configuration

Review the current subset configuration.

Foreign keys and circular dependencies

Create virtual foreign keys. Manage circular dependencies in the data.

Configure subsetting

Select and configure target and lookup tables.

Manage configuration inheritance

Override or restore inheritance from a parent workspace to a child workspace.

Viewing subsetting steps and run results

View the subset creation steps Review the path that Structural takes to identify the subset records.

View previous subset generation runs See the results and the configuration for previous runs of subsetting generation.

Other resources for subset configuration

Generate subset data from related databases

Ensure that generated subsets are cohesive.

Subsetting hints and tips

Hints and tips for subset configuration.