Skip to main content

​
Bulk Import Test Cases

Importing test cases from a CSV file lets you create or update several test cases at once, instead of adding them one at a time through the UI. You can import test cases for a single table, for a test suite, or across your entire platform. For more information about what each column in the file means, see the CSV Field Reference.

​
Bulk Import Test Cases for a Table

To import test cases scoped to a single table:
  1. In the left navigation menu, click Explore, and select the table whose test cases you want to import.
  2. Navigate to the Data Observability tab.
  3. In the Data Quality tab, click Test Cases if not selected. Access Table Test Cases
  4. Click the ⋮ icon and click Import. Import test cases for a single table
  5. Upload or drop the CSV file. Upload the test case CSV file
  6. Preview the uploaded file and add or modify rows using the inline editor. Preview of the test case CSV file
  7. Validate your changes. A green or red tick in the Status column displays the success or failure of the test cases. Validate the test case CSV file
  8. Click Update to apply the changes.

​
Bulk Import Test Cases in a Suite

To import test cases scoped to a single test suite:
  1. Navigate to Data Observability > Data Quality.
  2. Click the Test Suites tab and switch to Bundle Suites. Select a bundle test suite
  3. Search and select the bundle suite whose test cases you want to import.
  4. Click the ⋮ icon and click Import. Import test cases for a test suite
  5. Repeat steps 5 to 8 from Bulk Import Test Cases for a Table.

​
Bulk Import All Test Cases

To import test cases across your entire OpenMetadata instance:
  1. Navigate to Data Observability > Data Quality, and click Test Cases. Test Cases Tab
  2. Click the ⋮ icon and select Import. Import test cases platform-wide
  3. Repeat steps 5 to 8 from Bulk Import Test Cases for a Table.

​
Import Using API

You can also import test cases using the API with the following endpoints: PUT /api/v1/dataQuality/testCases/name/{name}/import PUT /api/v1/dataQuality/testCases/name/{name}/importAsync {name} only matters when targetEntityType=testSuite: set it to the Fully Qualified Name (FQN) of the test suite that newly created test cases should be added to. For any other targetEntityType (or when it’s omitted), {name} isn’t used — each row’s entityFQN column determines which table or column the test case applies to. Both endpoints take the CSV file as the raw request body and support two query parameters:
  • dryRun: true or false (default true). Validates the file without making changes, matching the preview step in the UI.
  • targetEntityType: The entity type the test cases are being added to, for example table or testSuite.
The importAsync endpoint runs the import as a background job and is what the UI uses. The import endpoint returns the result synchronously.