[Solved] After running a dbt test with store_failures = true, what will the following SQL query return?SELECT * FROM {{ ref('my_model') }}_test_unique_test__failures | dbt

dbt - Advanced Testing

After running a dbt test with store_failures = true, what will the following SQL query return?

SELECT * FROM {{ ref('my_model') }}_test_unique_test__failures

AAn error because the table does not exist

BAll rows from the model regardless of test results

CAn empty table if no failures occurred

DAll rows from the model that failed the unique_test

Step-by-Step Solution

Solution:

Step 1: Understand what the failure table stores
The failure table stores rows that failed the specific test.
Step 2: Interpret the query on the failure table
Selecting from the failure table returns only failing rows, not all rows.
Final Answer:
All rows from the model that failed the unique_test -> Option D
Quick Check:
Failure table query returns failing rows only [OK]

Quick Trick: Failure tables contain only failing rows, not all data [OK]

Common Mistakes:

MISTAKES

Master "Advanced Testing" in dbt

9 interactive learning modes - each teaches the same concept differently

More dbt Quizzes

After running a dbt test with store_failures = true, what will the following SQL query return?