Yes, you can store more than five rows of failing records per test per run in the

test_result_rows

table by configuring the

test_sample_row_count

variable. By default, Elementary saves 5 sample rows per test, but you can increase this number by adding the following to your

dbt_project.yml

file:

yaml vars:   test_sample_row_count: 10  # or any number you prefer

Alternatively, you can pass this variable when running dbt tests:

dbt test --vars '{"test_sample_row_count": 10}'

Keep in mind that increasing this number will store more data in your database, which could affect performance and costs depending on your database setup. [Elementary FAQ](https://docs.elementary-data.com/oss/general/faq) provides this information in the "Can I see more result samples in the report?" section. I should note that some users have reported that the configuration needs to be placed directly under the global

vars

section in your

dbt_project.yml

, not under

models.elementary

or other nested sections. I hope this helps!