[Feature] Test run results should include failure value, even if not fail or warning

[vglocus]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt functionality, rather than a Big Idea better suited to a discussion

Describe the feature

Currently the RunResult of data test will report failures at 0 unless there is a warning or error. [code]

The scenario: I have severity: warn and warn_if: '> 10', my data test returns 4 failures, my RunResult shows 0 failures.
I would expect the 4 to go through.

What would be the problem if we always returned the "failures" column of the query?

Describe alternatives you've considered

Alternative to getting the actual failure result is to use the adapter response, get a reference to the job id (BigQuery) and look up the job result manually. A lot of effort for getting number correctly.

Who will this benefit?

Anyone who uses RunResults, either via the produced json file or programmatically, to monitor their data workflows to some degree.

Are you interested in contributing this feature?

Yes

Anything else?

No response