How to read the run_results.json to store the data into the dremio .

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.

Here’s a guide that might help you.