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?


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

thanks, Jesse. It works fine for me.