Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-10-2024 10:58 AM
You could set your alert with query as:
-- Custom alert to monitor for new rows added to a table
SELECT COUNT(*) AS new_rows
FROM your_table
WHERE event_time > current_timestamp() - interval '1' hour
In this example, the query checks for rows added to your_table within the last hour. If the query returns a non-zero count, the alert will be triggered.