Data Error Tracking


#1

I’d like to have a number of queries that are used find data errors (ex: SELECT * FROM users WHERE name IS NULL or email ILIKE ‘%test.com’. If the queries come back with any records (i.e. null), the data will be sent to admins via a Slack notification or an email.

In order to prevent multiple dashboards that admins need to manage, would it be possible to do this with Metabase? If so, what would you recommend our customization / next steps be?

Using a cron job, these queries would run every hour.


#2

Set up an alert.