Greetings everyone! I'm exploring the possibility of conducting a pulse check in Metabase to determine if a table is empty. The goal is to receive an email notification if the table contains no data. I've crafted a query that checks each row, and my intention is to trigger an email notification when the row count is zero. However, I'm unsure about the steps to integrate this with an email notification. Any guidance on incorporating email notifications would be greatly appreciated!
SELECT COUNT(*) AS row_count
SUM(metrics_impressions) AS total_impressions,
SUM(metrics_cost_micros)/1000000.0 AS total_cost
WHERE segments_date BETWEEN CURRENT_DATE() - 1 AND CURRENT_DATE()
GROUP BY segments_date, customer_id
) AS subquery