I am using dbt test with the --store-failures flag, but it creates a separate table for each test failure. I would like to know if there is a way to store all test failures in a single consolidated table instead of multiple ones.
Checked the dbt documentation for --store-failures, but it seems to create separate tables by default.
Searched in community discussions but haven’t found a clear solution.
Considered using post-processing scripts to merge failure tables into one, but I would prefer a built-in solution if possible.