We need to add some kind of mechanism for identifying data inconsistencies and raising flags accordingly. The solution should do the following:
1) If the "udw_table_counts" query returns any table counts equal to 0, we need to flag that in the emailed results and the program should exit with code 1.
2) If the "unizin_metadata" query returns a canvasdatadate older than 48 hours, we need to flag that in the emailed results.
In implementing this, it may make sense to separate generating the results from emailing them.
We need to add some kind of mechanism for identifying data inconsistencies and raising flags accordingly. The solution should do the following:
1) If the "udw_table_counts" query returns any table counts equal to 0, we need to flag that in the emailed results and the program should exit with code
1
.2) If the "unizin_metadata" query returns a
canvasdatadate
older than 48 hours, we need to flag that in the emailed results.In implementing this, it may make sense to separate generating the results from emailing them.