DBT test error dbt internally failed to run test

Viewed 24

I wrote a simple generic dbt test and I get error saying dbt internally failed to execute test.dbtlearn.no_nulls_in_dim_listings_cleansed: Returned 0 rows, but expected 1 row

I did not find any solution for this. Anyone has any solution for this?

1 Answers

It might be that you’re running an earlier version of dbt. Originally tests returned a count of failing rows (ie one row with a single value) but now they need a set of failing rows (one row per failure).

It sounds like your dbt version is expecting the former when your test is written for the latter, I’d try modifying your test or even better upgrading to a more recent version of dbt.

Related