Timely posting! I've been inspired by some recent... large gaps in data at work (silent analytics processing failures) to build a service called QueryCanary. It's a surprisingly powerful but simple tool that lets you define scheduled SQL checks to run against your database, and then checks those results for anomalies, variances, and other issues.
Really hoping to get some early feedback on this tool, I've been using it for two production sites for about a week now and I've already discovered (at work) that we've had the 2nd largest user signup day, and that we deployed a change that inaccurately tracked a specific metric. Check it out at https://querycanary.com
Really hoping to get some early feedback on this tool, I've been using it for two production sites for about a week now and I've already discovered (at work) that we've had the 2nd largest user signup day, and that we deployed a change that inaccurately tracked a specific metric. Check it out at https://querycanary.com