How we can generate report in test failure

Archive
1

In dbt if our test case fail is their way to generate report for it, --store-failure will store failed records
is their any way we can insert dbt test report in BQ with failure reason