# How to read the run\_results.json to store the data into the dremio .
**URL:** https://discourse.getdbt.com/t/how-to-read-the-run-results-json-to-store-the-data-into-the-dremio/16732
**Category:** Help
**Tags:** jinja, macros, dbt-core
**Created:** [October 25, 2024, 2:03pm UTC](https://discourse.getdbt.com/t/how-to-read-the-run-results-json-to-store-the-data-into-the-dremio/16732 "2024-10-25T14:03:33Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@RiyaGupta](https://discourse.getdbt.com/u/RiyaGupta)
#### Post date: [October 25, 2024, 2:03pm UTC](https://discourse.getdbt.com/t/how-to-read-the-run-results-json-to-store-the-data-into-the-dremio/16732/1 "2024-10-25T14:03:33Z")
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.
---
### Author:  [@Surya](https://discourse.getdbt.com/u/Surya)
#### Post date: [November 1, 2024, 7:54am UTC](https://discourse.getdbt.com/t/how-to-read-the-run-results-json-to-store-the-data-into-the-dremio/16732/2 "2024-11-01T07:54:20Z")
Here’s a guide that might help you.
> **[dbt observability 101: How to monitor dbt run and test results](https://www.elementary-data.com/post/dbt-observability-101-how-to-monitor-dbt-run-and-test-results)**
>
> Monitoring and logging are essential in every production environment, and your dbt project is no exception. In this post we will share a step-by-step guide on how you can implement a simple monitoring solution for your dbt project, including code...