Query failed rows

Query the actual data rows that failed data quality rules directly from Atlan to investigate data quality issues, export results for analysis, and understand what went wrong.

Prerequisites

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

• Query failed rows feature enabled in Labs - Ask your admin to enable the feature
• Connection configured with BYOC credentials - See Configure connection for failed rows queries
• Data quality rules already created and monitored
• At least one rule in FAILED state

Query failed rows

View the specific rows that caused a data quality rule to fail. When a data quality rule fails, Atlan automatically generates SQL queries that identify the problematic rows in your source system. You can execute these queries directly from the Data Quality tab, view results in Atlan, and export them for deeper analysis.

1. Navigate to an asset with data quality rules:

   • From the discovery search, find your table or view
   • Click the asset to open its profile page

2. Click the Data Quality tab to view all rules for this asset

3. In the rules table, find a failed rule that supports failed rows queries

   The Query failed rows button only appears for rules that support failed rows queries. For details about which rule types support failed rows queries, see Failed rows FAQ.

4. Hover over the rule row to reveal the Query failed rows button

5. Click Query failed rows to execute the query. The query results modal opens displaying the failed rows with row and column counts, query execution timestamp, and action buttons for working with results.

6. Choose how you want to work with the query results using the available actions:

   • Copy: Copy results to clipboard for pasting into spreadsheets, text editors, or analysis tools
   • Download: Export results as a CSV file for offline analysis or archival
   • Query Again: Re-execute the query to get fresh data and check if the data quality issue persists
   • View SQL: View and copy the underlying query to run directly in your data warehouse or modify for deeper investigation

Troubleshooting

If you encounter issues querying failed rows, such as the query button not appearing or queries failing to execute, see Troubleshooting failed rows connection.

See also

• FAD - failed rows: Common questions about querying failed rows, including which rules support failed rows queries
• Rule types and failed rows validations: Complete reference of supported rule types