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.
thanks, Jesse. It works fine for me.