Skip to main content

​
Bulk Edit Test Cases

Bulk Edit lets you update several existing test cases at once from an inline spreadsheet-style grid, without preparing a CSV file yourself. Under the hood, it uses the same export and import endpoints as Bulk Export and Bulk Import: Collate automatically exports your current test cases, loads them into an editable grid, then validates and re-imports your changes when you confirm. You can bulk edit test cases for a single table, for a test suite, or across your entire platform.
Note: You need EditAll permission on test cases to use Bulk Edit.

​
What You Can Edit

The name, testDefinition, entityFQN, and testSuite columns are locked, since they identify the test case and what it runs against. You can edit:
  • displayName
  • description
  • parameterValues
  • computePassedFailedRowCount
  • useDynamicAssertion
  • inspectionQuery
  • tags
  • glossaryTerms
For more information about what each column in the file means, see the CSV Field Reference.

​
Bulk Edit Test Cases for a Table

To edit test cases added to a single table:
  1. In the left navigation menu, click Explore, and select the table whose test cases you want to edit.
  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 Bulk Edit. Select Bulk Edit for a single table
  5. Collate exports the table’s current test cases in the background and loads them into an editable grid. Edit or modify data using the inline editor and click Next. Edit test cases in the inline grid
  6. Validate your changes. A green or red tick in the Status column displays the success or failure of the test cases. Validate changes as a dry run
  7. Click Update again to apply the changes.

​
Bulk Edit Test Cases in a Suite

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

​
Bulk Edit All Test Cases

To edit test cases across your entire Collate instance:
  1. Navigate to Data Observability > Data Quality, and click Test Cases. Test Cases Tab
  2. Click the ⋮ icon and select Bulk Edit. Select Bulk Edit Test Cases
  3. Repeat steps 5 to 7 from Bulk Edit Test Cases for a Table.
Note: You can click Cancel at any point before the final update to discard your changes.
Tip: Bulk Edit doesn’t have its own API. It uses the same export and import endpoints described in Bulk Export Test Cases and Bulk Import Test Cases, with recursive=false passed on the import call.