Skip to main content

Enable query failed rows

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:

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.

  1. Navigate to Admin from the profile menu

  2. Under the Workspace heading, 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.

View configured connections​

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

  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)

Next steps​