I admit it's not the best but I do almost like you. Graphs are definitely helpful.
I also have a few 'test' queries that insert there results into a 'test_results' table. Most of the queries check the cardinality of the table since to me wrong cardinality is where the biggest errors come from. I do something like :
insert into test_table
select
case when count(*) = count(distinct users) then 'pass'
else 'fail'
end as result,
'test_cardinality_temporary_table_a' as test_name
from temporary_table_a
I also have a few 'test' queries that insert there results into a 'test_results' table. Most of the queries check the cardinality of the table since to me wrong cardinality is where the biggest errors come from. I do something like :
insert into test_table
select case when count(*) = count(distinct users) then 'pass' else 'fail' end as result, 'test_cardinality_temporary_table_a' as test_name from temporary_table_a