Skip to main content

Bulk Export Test Cases

Exporting test cases to a CSV file gives you a copy of your test case metadata to review offline, or a template you can edit and re-import. You can export 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 Export Test Cases for a Table

To export 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 export.
  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 Export. Export test cases for a single table
  5. In the export dialog, confirm the CSV format and start the export. Confirm and start the export
  6. OpenMetadata generates the file in the background and downloads it once it’s ready.

Bulk Export Test Cases in a Suite

To export 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 export.
  4. Click the icon and click Export. Export test cases for a test suite
  5. Repeat steps 5 to 6 from Bulk Export Test Cases for a Table.

Bulk Export All Test Cases

To export 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 Export. Export test cases platform-wide
  3. Repeat steps 5 to 6 from Bulk Export Test Cases for a Table.

Export Using API

You can also export test cases using the API with the following endpoints: GET /api/v1/dataQuality/testCases/name/{name}/export GET /api/v1/dataQuality/testCases/name/{name}/exportAsync Replace {name} with the Fully Qualified Name (FQN) of the table or test suite you’re exporting from, or with * to export every test case in the instance. The exportAsync endpoint runs the export as a background job and is what the UI uses. The export endpoint returns the CSV synchronously.