> ## Documentation Index
> Fetch the complete documentation index at: https://docs.getcollate.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Root Cause Analysis | Collate Incident Management

> Identify root causes of data incidents using observability metrics, lineage context, and entity-level impact traces.

# Root Cause Analysis

## Failed Rows Sample

Some tests will produce a failed sample upon failure. This allows the platform users to understand the nature of the failure and take corrective actions. The failed sample will be a subset of the rows that failed the test.

The sample will be collected when the option `computePassedFailedRowCount` is set.

### Supported Test Definitions

* [Column Values to Be Not Null](/how-to-guides/data-quality-observability/quality/tests-yaml#column-values-to-be-not-null)
* [Column Values to Match Regex](/how-to-guides/data-quality-observability/quality/tests-yaml#column-values-to-match-regex)
* [Column Values to not Match Regex](/how-to-guides/data-quality-observability/quality/tests-yaml#column-values-to-not-match-regex)
* [Column Values to Be in Set](/how-to-guides/data-quality-observability/quality/tests-yaml#column-values-to-be-in-set)
* [Column Values to Be Not In Set](/how-to-guides/data-quality-observability/quality/tests-yaml#column-values-to-be-not-in-set)
* [Column Values to Be Between](/how-to-guides/data-quality-observability/quality/tests-yaml#column-values-to-be-between)
* [Column Values Lengths to Be Between](/how-to-guides/data-quality-observability/quality/tests-yaml#column-values-lengths-to-be-between)
* [Custom SQL](/how-to-guides/data-quality-observability/quality/tests-yaml#table-custom-sql-test)

### Deleting Sample Rows

If you wish to delete sample rows, you can do so by clicking on the three dots above the table of sample rows. This will open a window with the `Delete` option. Note that failed sample rows will automatically be deleted upon test success.

<img src="https://mintcdn.com/collatedocs/hzvCWOBUMdmV543T/public/images/features/ingestion/workflows/data-quality/sample-row-failure-deletion.png?fit=max&auto=format&n=hzvCWOBUMdmV543T&q=85&s=aebc5d2b5d33e7b9379f3e06d84cef6b" alt="set compute row count" width="1405" height="383" data-path="public/images/features/ingestion/workflows/data-quality/sample-row-failure-deletion.png" />

### Example

<img src="https://mintcdn.com/collatedocs/hzvCWOBUMdmV543T/public/images/features/ingestion/workflows/data-quality/set_compute_row_count.png?fit=max&auto=format&n=hzvCWOBUMdmV543T&q=85&s=80e970c1384b738e3883b8ffdb1038c1" alt="set compute row count" width="1223" height="847" data-path="public/images/features/ingestion/workflows/data-quality/set_compute_row_count.png" />

<img src="https://mintcdn.com/collatedocs/hzvCWOBUMdmV543T/public/images/features/ingestion/workflows/data-quality/failed_rows_sample_1.png?fit=max&auto=format&n=hzvCWOBUMdmV543T&q=85&s=bc3e1b362588d34a8b3c8b9b8508bb4c" alt="test definition" width="2846" height="772" data-path="public/images/features/ingestion/workflows/data-quality/failed_rows_sample_1.png" />

<img src="https://mintcdn.com/collatedocs/hzvCWOBUMdmV543T/public/images/features/ingestion/workflows/data-quality/failed_rows_sample_2.png?fit=max&auto=format&n=hzvCWOBUMdmV543T&q=85&s=eeef76ac666a33bd15ddfb91e30cfd25" alt="failed rows sampls" width="2838" height="1122" data-path="public/images/features/ingestion/workflows/data-quality/failed_rows_sample_2.png" />

## Inspection Query

Supported test will generate an inspection query upon failure. This query can be run on the source data to understand
the nature of the failure and take corrective actions.

This query can be added to the table and shared with other users.

<img src="https://mintcdn.com/collatedocs/hzvCWOBUMdmV543T/public/images/features/ingestion/workflows/data-quality/inspection-query.png?fit=max&auto=format&n=hzvCWOBUMdmV543T&q=85&s=d8052a0f5829e038a4115f1e4ebde733" alt="inspection query" width="1205" height="497" data-path="public/images/features/ingestion/workflows/data-quality/inspection-query.png" />
