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 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 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 respects the filters and search text active on the list you open it from, so only matching test cases are exported. To export everything in scope, clear the filters first. The filters that apply depend on where you start the export:
  • Data Quality > Test Cases: status, type, table, tags, tier, platform, service, dimension, data product, last-run window, and search.
  • A table’s Data Quality tab: test type, status, and search.
  • A test suite page: the filters available on that page.

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. Both endpoints also accept optional query parameters to filter and page the export, such as testCaseStatus, testCaseType, entityFQN, entityLink, tags, tier, owner, q, testPlatforms, dataQualityDimension, serviceName, dataProductFqn, startTimestamp, endTimestamp, limit, and offset. With no parameters, the export covers every test case in scope. For details, see the Export Test Cases API reference.