Skip to content

Generate Tests

Generate tests to automatically populate a test suite based on the latest profiling results for a table group. The system selects relevant test types, sets thresholds, and configures parameters based on the data types, patterns, and characteristics discovered in your columns.

TestGen includes 83 test types, plus 12 Commercial Pharma tests in TestGen Enterprise. See TestGen Test Types for the complete list and descriptions.

Tip

Best practice is to regenerate tests every few weeks or when your data has evolved, so that test criteria stay aligned with current data characteristics.

Prerequisites

  • A test suite is required to generate tests. Use an existing test suite or create a new one from the Test Suites page.
  • The test suite's table group must have been profiled.

Note

Some test types compare a table across profiling runs and are generated only after the table has been profiled at least twice.

Generation sets

A generation set is a named group of test types. Select more than one set when a test suite needs test types from each.

Set Use it for
Standard General-purpose tests. Suits most test suites.
Table Comparison Checking each table and column against its profiled baseline, from the row count and column types to null counts, sums, most frequent values, and hashes of the values themselves. See Verify a Data Migration.
Contract Tests a data contract states. Contracts only. See Contract generation set.
Industry sets, such as Commercial Pharma Test types for a specific industry.

Note

The Table Comparison hash tests and Match Epoch Sum are generated only from a profiling run with the table group's Profile for table comparison setting on. To get them, edit the table group (Manage Table Groups), select Profile for table comparison under Settings, run profiling, and then generate tests.

TestGen remembers the generation sets you chose, so regenerating later starts from the same selection. A test suite that has never generated tests starts with Standard selected, or Contract if it is a contract.

Generate tests for a test suite

  1. Select Test Suites from the menu.
  2. On the test suite that you want to generate tests for, click Generate Tests, or Regenerate Tests when the suite already has tests.
  3. In the dialog, select one or more Generation Sets, and click Generate Tests.

On a contract, the button is Regenerate Contract, and you select the generation sets under Tests, along with what else to refresh. See Regenerate a contract.

Warning

De-selecting a generation set removes its test types from the test suite. The next generation deletes that set's unlocked auto-generated tests. Before you confirm, the dialog names the sets you removed and how many tests will be deleted.

Adding a set can also remove tests. A domain-specific test type replaces the general-purpose test it supersedes on the same column. For example, a Commercial Pharma test replaces the Pattern Match test on that column. Whether the replacement applies depends on the profiled data, so the dialog reports how many unlocked auto-generated tests may be deleted at most.

Keep tuned tests across regeneration

When you regenerate tests:

  • Unlocked auto-generated tests are refreshed — tests may be added or removed, and parameters like expected patterns, value ranges, and thresholds may change to reflect current data.
  • Locked auto-generated tests are preserved exactly as configured.
  • Manually created tests (including custom tests) are never affected by regeneration.
  • Locked auto-generated tests are also kept when you de-select their generation set — locking is how you preserve tests from a set you no longer generate.

Lock a test when you have manually tuned its parameters and want to preserve your changes across regenerations, or when you want to keep a test whose generation set you no longer select. To lock or unlock a test, navigate to the Test Definitions page and toggle the lock status.

Next steps

  • Test Definitions to review the generated tests, tune thresholds, add tests manually, and lock the tests you want to keep
  • Run Tests to run the tests against your data