Hello, I am trying to see sample failed rows. But...
# community-support
a
Hello, I am trying to see sample failed rows. But I am not able to find it in elementary dashboard. I have run the test like
dbt test --vars '{"test_sample_row_count": 10}'
as suggested in the documentation. And also tried adding
vars:
test_sample_row_count: 10
as suggested in documentation. What am I doing wrong ? Also, is there any way to see all the failed rows in elementary ui ?
n
Hey @Abhishek Padhi! You've configured it correctly, but have you set this flag in your
dbt_project.yml
?
Copy code
flags:
       require_explicit_package_overrides_for_builtin_materializations: false
It will show a dbt warning (it's harmless), but should start collecting samples once it's configured 🙂 As for the failed rows - Elementary only collects sample data (as many rows as you'd like), but we provide a query that allows you to retrieve all failing rows. This is true for all tests but anomaly tests, since they have a deeper calculation behind them. Let me know if this helps!