Data Freshness Alert

Hey,

I would like to create an alert for data freshness. The data is coming to our DB on real-time basis hence do you have an idea how to get alert for this?

Hi @amzar
Sounds like you are looking for this:
https://github.com/metabase/metabase/issues/7860 - upvote by clicking :+1: on the first post

If you always know there should be data, then you can do something like this (adjust the amount of hours):
select count(*) from your_table where your_column > (now() + (INTERVAL '-2 hour'))
And create an alert when it goes below 1.