# Diagnostics Warehouse

{% if visitor.claims.plan ===  %}
{% hint style="info" %}
Can't find what you're looking for? *You are seeing the **Free license** documentation.*

**Get access to Diagnostics Warehouse private documentation** with an **Enterprise license**. If you are in the wrong organization:

1. **Log out and back into Soda** with an organization under **Enterprise license**
2. **Refresh this page** (Soda and docs must be open in the same browser)

Learn more about [documentation-access-and-licensing](https://docs.soda.io/reference/documentation-access-and-licensing "mention").
{% endhint %}
{% endif %}

{% if visitor.claims.plan ===  %}
{% hint style="info" %}
Can't find what you're looking for? *You are seeing the **Teams license** documentation.*

**Get access to Diagnostics Warehouse private documentation** with an **Enterprise license**. If you are in the wrong organization:

1. **Log out and back into Soda** with an organization under **Enterprise license**
2. **Refresh this page** (Soda and docs must be open in the same browser)

Learn more about [documentation-access-and-licensing](https://docs.soda.io/reference/documentation-access-and-licensing "mention").
{% endhint %}
{% endif %}

{% if !(visitor.claims.plan ===  %}
{% hint style="info" %}
Can't find what you're looking for? **Get access to Diagnostics Warehouse private documentation**:

1. **Log into Soda**
2. **Refresh this page** (Soda and docs must be open in the same browser)

Note: Your organization must be under an **Enterprise license** to view private docs. Learn more about [documentation-access-and-licensing](https://docs.soda.io/reference/documentation-access-and-licensing "mention").
{% endhint %}
{% endif %}

## Overview

### What is Diagnostics Warehouse?

The **Diagnostics Warehouse is a place inside your data warehouse** (in one or multiple schemas) **reserved for Soda to store data quality information**.

***

With Diagnostics Warehouse, Soda stores all scans, failed records, and historical data quality issues directly in your own data warehouse. **Nothing is stored outside.** This gives you the ability to run diagnostics, resolve issues, and see exactly why problems happen. You can go as deep as you need, from a single record to a full dataset.

Each time a Soda scan runs, Diagnostics Warehouse stores failed rows together with **check**, **scan**, and **dataset attributes & metadata**. With that information, data teams can quickly **diagnose and resolve issues at both row and dataset level**. Additionally, Soda's Diagnostics Warehouse makes it easier for teams to build on top of Soda's outcomes to set up operation workflows, and connect to BI tools you already know and trust.

### Features & capabilities

* **Full diagnostic information in one place**, including attributes.
* **Faster root-cause analysis:** jump from a failed check to the exact failed rows, affected datasets/columns, and prior history to see if it’s a one-off issue or a pattern.
* **Open & portable features:** it’s just tables in your warehouse. Query with SQL, power dashboards, join with lineage, incident, or cost data, and automate workflows.
* **Privacy and transparency:** Diagnostics Warehouse stores tables in your own warehouse, giving you full control over security, retention and access.

### Security & governance

* **Data minimization:** Diagnostics Warehouse stores metadata about runs and checks and, **for row-level checks**, it only stores failed rows when the option is enabled.
* **Warehouse residency:** Diagnostics are **not stored in Soda**. They live in your analytics warehouse, respecting your access controls, encryption, and audit trails.
* **No destructive access**: Soda does not require permissions to delete data. It only **evaluates** checks, **stores** metadata, and **moves** failed rows into a designated location.\
  Cleanup and garbage-collection queries are provided, but Soda never drops tables itself.

### Supported data sources

Diagnostics Warehouse integrates with a range of data sources so that you can centralize, analyze, and act on diagnostics data across your organization.

| Data source    | Support status    | Notes                               |
| -------------- | ----------------- | ----------------------------------- |
| **Athena**     | ✅ Fully supported | Full functionality and scalability. |
| **BigQuery**   | ✅ Fully supported | Full functionality and scalability. |
| **Databricks** | ✅ Fully supported | Full functionality and scalability. |
| **Dremio**     | ✅ Fully supported | Views are not supported in Dremio.  |
| **OracleDB**   | ✅ Fully supported | Full functionality and scalability. |
| **Postgres**   | ✅ Fully supported | Full functionality and scalability. |
| **Snowflake**  | ✅ Fully supported | Full functionality and scalability. |
| **SQL Server** | ✅ Fully supported | Full functionality and scalability. |
| **Redshift**   | ✅ Fully supported | Full functionality and scalability. |
| **MS Fabric**  | ✅ Fully supported | Full functionality and scalability. |
| **Synapse**    | ✅ Fully supported | Full functionality and scalability. |

***

### Get started

1. **Enable Diagnostics Warehouse** in your Soda data source settings.
2. Grant the service **identity permission** to create and write to the Diagnostics Warehouse schema in your warehouse.
3. **Run your checks**; Diagnostics Warehouse tables populate automatically.
4. Query your warehouse and connect to your BI tools to **start exploring**.

> **Next**: to enable Diagnostics Warehouse in your organization, **reach out to Soda at** [**sales@soda.io**](mailto:sales@soda.io).

<br>

***

{% if (visitor.claims.plan === 'datasetStandard')
%}
{% hint style="success" %}
You are **logged in to Soda** and seeing the **Free license** documentation. Learn more about [documentation-access-and-licensing](https://docs.soda.io/reference/documentation-access-and-licensing "mention").
{% 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-and-licensing](https://docs.soda.io/reference/documentation-access-and-licensing "mention").
{% 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-and-licensing](https://docs.soda.io/reference/documentation-access-and-licensing "mention").
{% 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-and-licensing](https://docs.soda.io/reference/documentation-access-and-licensing "mention").
{% endhint %}
{% endif %}


---

# Agent Instructions: 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:

```
GET https://docs.soda.io/diagnostics-warehouse.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.