|
|
|
|
|
|
by toto444
1231 days ago
|
|
|
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 |
|
|