[FEATURE]: Tests run metrics summary

[feliblo]

Is there an existing issue for this?

• I have searched the existing issues

Problem statement

Currently the summary metrics https://databrickslabs.github.io/dqx/docs/guide/summary_metrics/#metrics-table-schema are focussed on row_level checks. It would be useful to monitor health in dashboarding tools by also being able to look at individual tests.

Example:
mycatalog.myschema.mytable -> run_id: 1234 gave 14/15 tests passed.

• For the failed tests I would obviously still want to see the detailed row-level findings.
• For passed tests it would be still be a useful overview.

Currently it's possible to check the rows that passed all tests, however context is missing on the tests that have run on a certain table/dataframe.

Proposed Solution

Include a metric/summary for test-level findings. Otherwise users would have to check the tests that ran, what
rows failed for which tests and create code that generates a pass for tests that don't show up.

Additional Context

No response

[IlyasFardaouix]

It looks like you're trying to extend the summary metrics to include test-level findings. I'm curious - have you considered how this would interact with the existing rows level checks, and whether you'd need to modify the metrics_table_schema to accommodate this new level of granularity?