> For the complete documentation index, see [llms.txt](https://docs.soda.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.soda.io/manage-issues/failed-row-samples.md).

# Failed row samples

{% hint style="info" %}
Failed row samples are an **opt-in feature** and must be enabled by the Soda support team before it is available in your organization, as it involves **storing a subset of your monitored data in Soda Cloud**.
{% endhint %}

When a Soda scan results in a failed check, Soda Cloud displays details of the scan results in each check's **Check History** page. To offer more insight into the data that failed a check during a scan, **you can enable Soda Cloud to display** **failed rows samples** in a check's history.

<figure><img src="/files/nxvlvdEhpRSlKWsRprwx" alt=""><figcaption></figcaption></figure>

If enabled, when a check fails during a scan, Soda automatically collects a sample of the failing rows and stores them in the [**Diagnostics Warehouse**](broken://pages/UZCAHd8ZBgl01336NkZa). You can then view these samples directly in the **Failed Rows** tab of the check result in Soda Cloud.

{% hint style="info" %}
The default sample size is **100 rows**. This can be overridden at the data source or dataset level.
{% endhint %}

## Configure failed row sampling

You can enable or disable failed row sampling, and adjust the sample size, at the [**data source**](#at-the-data-source-level) or [**dataset**](#at-the-dataset-level) level.

{% hint style="warning" %}
Failed rows are not emitted for Group By checks.
{% endhint %}

### At the data source level

To configure sampling for all datasets in a data source:

{% stepper %}
{% step %}
In Soda Cloud, navigate to **Data Sources** and select the data source you want to configure. Click on **Edit Diagnostics Warehouse**.

<figure><img src="/files/mKzd5J2VuSbmMxVIpNng" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
Navigate to the **Failed Row Samples** section and select the checkbox "**Allow sending failed row samples to Soda Cloud**".

<figure><img src="/files/oP1mH9cwAj3zXjSBYYCe" alt="" width="563"><figcaption></figcaption></figure>
{% endstep %}

{% step %}
Adjust the sample size.

Failed row samples default to 100 rows.
{% endstep %}

{% step %}
**Save** your changes.
{% endstep %}
{% endstepper %}

### At the dataset level

To override the data source setting for a specific dataset:

{% stepper %}
{% step %}
Navigate to the dataset you want to configure, click on the stacked dots menu > **Edit Dataset**.

<figure><img src="/files/Y5zhJTRp5sK9yAY3BjIP" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
Navigate to the **Diagnostics Warehouse Configuration** tab > **Failed row samples** section > select the checkbox.

<figure><img src="/files/xHx9nx0t0wCQnmpiT149" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
Adjust the sample size.

Failed row samples default to 100 rows.
{% endstep %}

{% step %}
**Save** your changes.
{% endstep %}
{% endstepper %}

## View failed row samples

To view failed row samples for a check result:

{% stepper %}
{% step %}
Navigate to the **Checks** page and select a check that has a **Failed** status.

<figure><img src="/files/OtTM7O7M2fr6pEmRKXar" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
At the bottom of the check page, navigate to the **Failed Rows** tab.

If failed row sampling is enabled and rows were collected, the sample is displayed here.

<figure><img src="/files/M91gkQVxL3XpW8uXhmQt" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}
\[Optional] Find column.

By searching for a column name, Soda will highlight it in the results to facilitate root cause analysis.

<figure><img src="/files/pGE5JsjfdjRRQRaA41HV" alt=""><figcaption></figcaption></figure>
{% endstep %}
{% endstepper %}

## Reroute failed row samples

If the data you are checking contains sensitive information, you may wish to send any failed rows samples that Soda collects to your own Diagnostics Warehouse rather than Soda Cloud. To do so, allow Failed Row Collection while [configuring the Diagnostics Warehouse](broken://pages/E1KTiEL4c6zytpedbEZg#optional-allow-failed-row-collection).

***

{% if visitor.claims.plan === 'datasetStandard' %}
{% hint style="success" %}
You are **logged in to Soda** and seeing the **Dataset Standard license** documentation. Learn more about [Documentation access & licensing](/reference/documentation-access-and-licensing.md).
{% endhint %}
{% endif %}

{% if visitor.claims.plan === 'enterprise' %}
{% hint style="success" %}
You are **logged in to Soda** and seeing the **Team license** documentation. Learn more about [Documentation access & licensing](/reference/documentation-access-and-licensing.md).
{% endhint %}
{% endif %}

{% if visitor.claims.plan === 'enterpriseUserBased' %}
{% hint style="success" %}
You are **logged in to Soda** and seeing the **Enterprise license** documentation. Learn more about [Documentation access & licensing](/reference/documentation-access-and-licensing.md).
{% endhint %}
{% endif %}

{% if !(visitor.claims.plan === 'enterprise' || visitor.claims.plan === 'enterpriseUserBased' || visitor.claims.plan === 'datasetStandard') %}
{% hint style="info" %}
You are **not logged in to Soda** and are viewing the default public documentation. Learn more about [Documentation access & licensing](/reference/documentation-access-and-licensing.md).

If you do have a Soda license, make sure to **log in to Soda Cloud in this same browser**.
{% endhint %}
{% endif %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.soda.io/manage-issues/failed-row-samples.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
