I have several data quality tests set up in my pipeline and using dbt test
to execute them. Currently, using elementary
and dbt_expectations
package, I am also able to load the test results onto snowflake tables. All details (node_id, database, schema, test_name, severity…) is getting logged as records into the table.
But in order to deep dive into data quality issues, I want to identify the records that failed test cases . I currently do not see any package or a macro that can help me visibilty get the rows of failed cases.
Is there an approach that I should follow ?