create alerts

[aris-2]

Hello, what would be the correct way to create alerts based on the entered data?

I need to create alerts for IoT devices.

The alerts are for CPU usage, temperature, memory, etc.

[sunng87]

Hello @aris-2 , at the moment you will need to poll the database to check against your rules. There are some external solutions like https://github.com/keephq/keep that will work with greptimedb because we are compatible with prometheus http api.

And we are working on mechanism that is similar to prometheus' alert rules in greptimedb enterprise version, which will allow you to configure rules and trigger external hook.

[aris-2]

Hi, thanks for responding.

Do you have any guides on how to implement it?

[sunng87]

Typically you will deploy a program to run a query, either in SQL or in PromQL, against the database periodically. Depends on your use-case, the query can be different, for example, fetch the latest value, or getting a max/min/avg value from a time window, and you compare it with your static threshold or some historical time window.

Do you have a time frame for your project and will you be interested to have this built into greptimedb enterprise? We can also talk about this on the community slack.