In dbt, i’ve applied the tests on the sources and want to store the failed tests results into the dremio in single table of all tests.
I have tried with the macros - using the functions like read_file(), open(), read_run_results() and also with the on-run-end feature in dbt.
Any of the way is not working for me. Could you please help me with the solution or how can i move forward with it.