You want to analyze failing rows from multiple tests on the customers model. Which approach best helps you combine all failure data for analysis?

hard📝 Application Q15 of 15

dbt - Advanced Testing

You want to analyze failing rows from multiple tests on the customers model. Which approach best helps you combine all failure data for analysis?

AManually export failure tables and merge them outside the database.

BCreate a union query combining all <code>dbt_test__customers__*</code> failure tables.

CRun each test again with <code>store_failures = false</code> to avoid duplicates.

DUse the original <code>customers</code> table and filter rows with errors.

Step-by-Step Solution

Solution:

Step 1: Identify failure tables for each test
Each test creates a failure table named dbt_test__customers__testname.
Step 2: Combine failure tables using SQL UNION
Use a UNION query to combine all failure rows from these tables into one result set.
Final Answer:
Create a union query combining all dbt_test__customers__* failure tables. -> Option B
Quick Check:
Union failure tables to analyze all failures together [OK]

Quick Trick: Use UNION on all failure tables for combined analysis [OK]

Common Mistakes:

MISTAKES

Master "Advanced Testing" in dbt

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More dbt Quizzes