Setup alarms with date as a reference

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:

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

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

1 Like

thanks, Jesse. It works fine for me.