Skip to main content

Failed rows

Common questions about querying failed rows in data quality, including when the nudge banner appears, dismissal limits, and configuration requirements.

When does the nudge banner appear?​

The nudge banner appears on the Data Quality tab when all of the following conditions are met:

  • Query failed rows feature is enabled in Labs
  • Connection is Snowflake or Databricks
  • Connection isn't fully configured (missing data quality, BYOC credentials, or "Allow query" setting)

The banner provides a quick path to configure the connection for failed rows queries. For detailed configuration steps, see Configure connection for failed rows.

How many times can I dismiss the nudge banner?​

The banner can be dismissed a limited number of times depending on the configuration scenario:

Scenario 1: Data quality not configured on connection

  • Can be dismissed 1 time
  • After 1 dismissal, the banner won't appear again for this scenario

Scenario 2: Data quality enabled but BYOC not configured or "Allow query" disabled

  • Can be dismissed 3 times
  • After 3 dismissals, the banner won't appear again for this scenario

When does the nudge banner disappear permanently?​

The banner stops appearing when any of the following conditions are met:

  • Query failed rows feature is disabled in Labs
  • Connection is fully configured (data quality enabled + BYOC credentials configured + "Allow query" setting enabled)
  • Maximum dismissals reached for the current scenario:
    • 1 dismissal for Scenario 1 (data quality not configured)
    • 3 dismissals for Scenario 2 (data quality enabled but BYOC not configured or "Allow query" disabled)

Once the banner disappears permanently, you can still configure the connection through Labs or connection settings. See Configure connection for failed rows for configuration methods.

Which rules support failed rows queries?​

The Query failed rows button only appears for rules that support failed rows queries. Failed-rows SQL is generated for per-row rules, including:

  • Null Count
  • Null Percentage
  • Blank Percentage
  • Duplicate Count
  • Unique Count
  • Min
  • Max
  • Regex
  • String Length
  • Valid Values
  • Custom SQL (invalid-rows mode)

Rules that don't support failed rows queries:

For aggregate-only rules (Average, Standard Deviation, Row Count, Freshness), failed rows queries aren't available because these rules don't identify specific rows that failed.

See Rule types and failed rows validations for complete details.

See also​

Need help​

If you can't find the answer you're looking for, contact Atlan support: Submit a request.