Elementary Community

Screenshot 2024-02-27 at 12.15.50 PM.png

Hello,

I am wondering about test tables Elementary writes to the data warehouse. Specifically:

1. dbt_prod_elementary.dbt_tests
2. dbt_prod_elementary.elementary_test_results
3. dbt_prod_elementary.test_result_rows
I see that the number of failing (or warning) records `test_results` does not equal the number of records in `test_result_rows`

*Does elementary save all of the failing rows on a test run to `dbt_prod_elementary.test_result_rows` or just a subset?*

The end goal here is to create a query using the elementary data that includes each failing row from a specific test run over time.

Hey <@U06LWSDK6KV>, elementary saves only a sample of the failing results in `test_result_rows` , you can change the sample size by following "Can I see more result samples in the report" <https://docs.elementary-data.com/oss/general/faq|in our docs>