## Enable query failed rows

URL: https://docs.atlan.com/product/capabilities/governance/data-quality/how-tos/enable-query-failed-rows

> Enable the query failed rows feature in Labs so users can investigate data quality issues by viewing the actual rows that failed DQ rules.

Enable the query failed rows feature in Labs so users can investigate data quality issues by viewing and exporting the actual data rows that failed quality rules. Once enabled, users can query failed rows directly from the Data Quality tab for per-row rules like Null Count, Min, and Max.

## Prerequisites

Before you enable query failed rows, make sure you have:

* Administrative access to Atlan
* At least set up [Snowflake](https://docs.atlan.com/llms/governance/data-quality/set-up-snowflake/llms.txt), [Databricks](https://docs.atlan.com/llms/governance/data-quality/set-up-databricks/llms.txt), or [BigQuery](https://docs.atlan.com/llms/governance/data-quality/set-up-bigquery/llms.txt) for your data quality studio.
* Enabled data quality on [Snowflake](https://docs.atlan.com/llms/governance/data-quality/enable-data-quality/llms.txt), [Databricks](https://docs.atlan.com/llms/governance/data-quality/enable-data-quality/llms.txt), or [BigQuery](https://docs.atlan.com/llms/governance/data-quality/enable-data-quality/llms.txt) connection.

## Enable query failed rows

Enable the feature to make it available across your organization. Users can then query failed rows on any properly configured connection.

### Snowflake

1. In your Atlan workspace, click **Settings** from the left menu.

 If you are using the **Old UI (Classic)**, navigate to **Admin** from the profile menu.

2. Click **Labs**

3. On the **Labs** page, find the **Data Quality** section

4. Locate the **Query Failed Rows** option in the **Data Quality** section

5. Click the toggle to enable **Query Failed Rows**

The feature is now enabled for your organization. Users can start querying failed rows on Snowflake connections that are properly configured.

### Databricks

1. In your Atlan workspace, click **Settings** from the left menu.

 If you are using the **Old UI (Classic)**, navigate to **Admin** from the profile menu.

2. Click **Labs**

3. On the **Labs** page, find the **Data Quality** section

4. Locate the **Query Failed Rows** option in the **Data Quality** section

5. Click the toggle to enable **Query Failed Rows**

The feature is now enabled for your organization. Users can start querying failed rows on Databricks connections that are properly configured.

### BigQuery

1. In your Atlan workspace, click **Settings** from the left menu.

 If you are using the **Old UI (Classic)**, navigate to **Admin** from the profile menu.

2. Click **Labs**

3. On the **Labs** page, find the **Data Quality** section

4. Locate the **Query Failed Rows** option in the **Data Quality** section

5. Click the toggle to enable **Query Failed Rows**

The feature is now enabled for your organization. Users can start querying failed rows on BigQuery connections that are properly configured.

## View configured connections

After enabling the feature, you can view which connections support failed rows queries and their current status.

### Snowflake

1. In Labs, next to the **Query Failed Rows** toggle, click **CONNECTIONS**

2. Review the connection status in the popover:

 The popover displays all Snowflake connections that have data quality enabled:
 * Only Snowflake connections with data quality enabled appear in the list
 * Status for each connection: **Query Enabled** or **Query Disabled**
 * **Query Enabled**: Connection is fully configured with BYOC credentials and "Allow query" setting enabled
 * **Query Disabled**: Connection needs configuration (BYOC credentials and "Allow query" setting)

### Databricks

1. In Labs, next to the **Query Failed Rows** toggle, click **CONNECTIONS**

2. Review the connection status in the popover:

 The popover displays all Databricks connections that have data quality enabled:
 * Only Databricks connections with data quality enabled appear in the list
 * Status for each connection: **Query Enabled** or **Query Disabled**
 * **Query Enabled**: Connection is fully configured with BYOC credentials and "Allow query" setting enabled
 * **Query Disabled**: Connection needs configuration (BYOC credentials and "Allow query" setting)

### BigQuery

1. In Labs, next to the **Query Failed Rows** toggle, click **CONNECTIONS**

2. Review the connection status in the popover:

 The popover displays all BigQuery connections that have data quality enabled:
 * Only BigQuery connections with data quality enabled appear in the list
 * Status for each connection: **Query Enabled** or **Query Disabled**
 * **Query Enabled**: Connection is fully configured with BYOC credentials and "Allow query" setting enabled
 * **Query Disabled**: Connection needs configuration (BYOC credentials and "Allow query" setting)

## Next steps

* [Configure connection for failed rows](https://docs.atlan.com/llms/governance/data-quality/configure-connection-for-failed-rows/llms.txt): Set up connections to enable failed rows queries

---