Configure connection for failed rows

Configure your Snowflake or Databricks connection with BYOC (Bring Your Own Credentials) to enable failed rows queries. This uses the same BYOC setup process as querying data in Insights, ensuring consistent credential management across Atlan.

When a connection is properly configured, users can execute SQL queries directly from the Data Quality tab to investigate data quality issues. The connection uses your credentials to query your data warehouse securely.

Prerequisites

Before configuring a connection for failed rows queries, make sure you have:

• Query failed rows feature enabled in Labs - See Enable query failed rows
• Data quality enabled on the connection - See setup guides for Snowflake or Databricks
• BYOC credentials ready for Basic or SSO authentication - See Query without shared credentials for BYOC overview
• Administrative or connection management access in Atlan
• Credentials with at minimum SELECT permission on the tables where data quality rules are applied - Without proper permissions, failed rows queries fail when users attempt to execute them

Configure authentication

Configure the credentials used to query failed rows. Atlan supports two authentication methods for querying failed rows. Access connection settings using one of these methods:

Via nudge banner

When you view the Data Quality tab on an asset, a yellow banner appears if the connection isn't fully configured. This banner provides a quick path to configure the connection. For questions about when the banner appears, dismissal limits, and when it disappears, see Failed rows FAQ.

1. Navigate to any asset on the connection you want to configure

2. Click the Data Quality tab

3. If the connection isn't configured, a yellow banner appears with:

   • Message: "Allow your team to view failed rows"
   • Current configuration status
   • "Learn more" link to documentation
   • Configure connection button

4. Click Configure connection in the banner

5. The connection settings drawer opens with the Connection tab selected

6. In the Connection tab, locate the Query permissions section

7. For Authentication type, select your authentication method:

Basic credentials

1. Select Basic credentials as the authentication type

2. Follow the detailed setup instructions in Query without shared credentials to configure username and password

3. Enable the Allow query toggle to permit failed rows queries

4. Click Update to save the configuration

SSO authentication

1. Select SSO as the authentication type

2. Follow the detailed setup instructions in Authenticate SSO credentials to query data for connector-specific SSO setup

3. Enable the Allow query toggle to permit failed rows queries

4. Click Update to save the configuration

Via Labs connections popover

Access connection configuration directly from the Labs page where you enabled the feature.

1. Navigate to Admin from the profile menu

2. Under the Workspace heading, click Labs

3. On the Labs page, find the Query Failed Rows option in the Data Quality section

4. Click CONNECTIONS next to the toggle

5. In the popover that appears:

   • View all connections with data quality enabled
   • Check current status: Query Enabled or Query Disabled
   • Click on any connection showing Query Disabled

6. The connection settings drawer opens

7. In the Connection tab, locate the Query permissions section

8. For Authentication type, select your authentication method:

Basic credentials

1. Select Basic credentials as the authentication type

2. Follow the detailed setup instructions in Query without shared credentials to configure username and password

3. Enable the Allow query toggle to permit failed rows queries

4. Click Update to save the configuration

SSO authentication

1. Select SSO as the authentication type

2. Follow the detailed setup instructions in Authenticate SSO credentials to query data for connector-specific SSO setup

3. Enable the Allow query toggle to permit failed rows queries

4. Click Update to save the configuration

Via connection settings

Configure the connection directly from the connections management interface.

1. Navigate to Governance > Connections from the left menu

2. Find and select your Snowflake or Databricks connection

3. Click the settings icon to open Connection settings

4. Select the Connection tab

5. Locate the Query permissions section

6. For Authentication type, select your authentication method:

Basic credentials

1. Select Basic credentials as the authentication type

2. Follow the detailed setup instructions in Query without shared credentials to configure username and password

3. Enable the Allow query toggle to permit failed rows queries

4. Click Update to save the configuration

SSO authentication

1. Select SSO as the authentication type

2. Follow the detailed setup instructions in Authenticate SSO credentials to query data for connector-specific SSO setup

3. Enable the Allow query toggle to permit failed rows queries

4. Click Update to save the configuration

Verify configuration

After configuring credentials, verify that the connection is ready for failed rows queries using one of these methods:

via Labs

Verify the connection status directly from Labs.

1. Navigate to Admin > Labs

2. Find Query Failed Rows in the Data Quality section

3. Click CONNECTIONS

4. Verify your connection shows Query Enabled status

If the status shows Query Disabled, review your configuration to confirm:

• BYOC credentials are properly saved
• "Allow query" toggle is enabled
• Credentials have the necessary permissions

Test failed rule

The best way to verify configuration is to test with an actual failed rule.

1. Navigate to an asset on the configured connection

2. Click the Data Quality tab

3. Find a failed rule in the rules table

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

5. Click the button to execute a query

If the query executes successfully, your configuration is complete.

Troubleshooting

If you encounter issues configuring connections for failed rows queries, such as connection status showing "Query Disabled" or queries failing to execute, see Troubleshooting failed rows connection.

For questions about nudge banner behavior and which rules support failed rows queries, see Failed rows FAQ.

Next steps

• Query failed rows: View and export the actual data rows that failed data quality rules