Hello all, I can't get the test_failure_rows to po...
# community-support
j
Hello all, I can't get the test_failure_rows to populate. Has something changed in the past while where we need to pass a value to elementary to get the failure rows to show up? I get the count, but the rows (sample failures) are empty. I'd like to show most if not all of the rows, we're only working with master data.
n
Hey Jordan, Are the test results on the report empty or is there a specific table that does not populate?
j
I was able to get the row evaluation value, just not the entire row.
n
Can you share which versions of dbt and the Elementary dbt package you're using? Also, have you made any recent updates to them? It would be helpful to know which specific tests aren't returning results. Are any tests working? And if none are, when was the last time you saw results?
And also, what DWH are you using? 🙂
Hey, we might have an explanation to the issue you're having 🙂 There was a change in the materializations in dbt 1.8 and above that affected the
test_result_rows
. Try adding this flag to your
dbt_project.yml
and see if it works:
Copy code
flags:
  require_explicit_package_overrides_for_builtin_materializations: false
See all details here - https://docs.elementary-data.com/oss/quickstart/quickstart-cli-package#important-allowing-elementary-to-over[…]aterializations-relevant-from-dbt-1-8 Let me know if this helps!
j
Thanks ill take a look at this