Setup alarms with date as a reference

Support Usage Support
1

Hi there,
I want to clarify if there is a possibility to set up alerts with a date as a reference. Or maybe a value from another column.
We are doing a daily data load and I want to create an alarm in case if data was failed to load. So, I have a query that returns the load date and today’s date and I want to compare these values in an alert configuration. Can you please advise?

redash1
redash1727×525 14.1 KB

redash2
redash21268×270 10.1 KB

2

I would do it this way:

SELECT
  CASE
    WHEN load_date = (current_date) THEN 1
    ELSE 0
  END AS `match`
FROM some_table
LIMIT 1;

Then set your alert to evaluate whether match == 1.

1 Like
3

thanks, Jesse. It works fine for me.

4