Data Freshness Alert


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 @mamzarmr
Sounds like you are looking for this: - 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.